Monday, December 27, 2010

Concurrent Program with request group details

Concurrent Program with request group details:
 
SELECT   frg.request_group_name
       , fav1.APPLICATION_SHORT_NAME "RequestGroup Appln Shortname"
       , fav1.APPLICATION_NAME "RequestGroup Application Name"
       , fav1.application_id "RequestGroup Application ID"
       , fcp.concurrent_program_name
       , fcpl.user_concurrent_program_name
       , fav.APPLICATION_SHORT_NAME "Con Prog Application Shortname"
       , fav.APPLICATION_NAME "Con Prog Application Name"
       , fav.application_id "Con Prog Application ID"
       , fe.execution_file_name
       , fe.executable_name
  FROM fnd_request_group_units frgu,
       fnd_concurrent_programs fcp,
       fnd_concurrent_programs_tl fcpl,
       fnd_request_groups frg,
       fnd_executables fe,
       fnd_application_vl fav,
       fnd_application_vl fav1
 WHERE frgu.request_unit_id = fcp.concurrent_program_id
   AND fav.application_id=fcp.application_id
   AND fav1.application_id=frgu.application_id
   AND frgu.request_group_id = frg.request_group_id
   AND fe.executable_id = fcp.executable_id
   AND fcp.concurrent_program_name = :conc_prg_name;

1 comment: