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,
  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. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

  2. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check