Regular queries in oracle apps

Find Directory where Trace Files are Stored:

SELECT value

FROM     v$parameter

WHERE  name = ‘user_dump_dest’;

User_dump_dest  is an initialization parameter defined in the init.ora file.

To check if multi-org is setup

Select multi_org_flag from FND_PRODUCT_GROUPS;

To find out details of concurrent request submitted with certain conditions

  SELECT request_id,

         req.CONCURRENT_PROGRAM_ID,

         prog.DESCRIPTION,

         Request_date,

         printer,

         number_of_copies,

         usr.user_name

    FROM fnd_concurrent_requests req,

         fnd_concurrent_programs_tl prog,

         fnd_user usr

   WHERE     printer <> 'noprint'

         AND requested_start_date > '14-AUG-06'

         AND status_code = 'C'

         AND number_of_copies > 0

         AND prog.CONCURRENT_PROGRAM_ID =req.CONCURRENT_PROGRAM_ID

         AND prog.language = 'US'

         AND req.requested_by = usr.user_id

ORDER BY request_date DESC