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