Search This Blog

Saturday, January 22, 2011

Concurrent Program Information

Below script retieves Concurrent Program Name, Application Name, Request Group Name
====================================================================
SELECT fcp.concurrent_program_name, fat.application_name,
       frg.request_group_name, fa.application_short_name, fa.basepath,
       frt.responsibility_name
  FROM fnd_concurrent_programs fcp,
       fnd_application fa,
       fnd_request_group_units frgu,
       fnd_request_groups frg,
       fnd_application_tl fat,
       fnd_responsibility fr,
       fnd_responsibility_tl frt
 WHERE 1=1
   AND fcp.application_id = fa.application_id
   AND frgu.request_unit_id = fcp.concurrent_program_id
   AND frg.request_group_id = frgu.request_group_id
   AND fat.application_id = frg.application_id
   AND fcp.CONCURRENT_PROGRAM_NAME LIKE '<Concurrent_Program_Name>'
   AND frgu.request_group_id = fr.request_group_id
   AND frt.responsibility_id = fr.responsibility_id

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete