Query to find the Request Group Or a Concurrent Program Information

Query to find the Request Group Or a Concurrent Program Information

 
 SELECT DECODE(frgu.request_unit_type,
              'P','Program',
              'S','SET',
              'A','Application',
              'F','Set Function',
              NULL) REQUEST_TYPE,
      frg.request_group_name,
      fat.application_name,
      decode(frgu.request_unit_type,
      'P', fcpv.user_concurrent_program_name,
      'S',FRSV.user_request_set_name,
      'A', fat2.application_name,
      NULL)  CONC_PROGRAM_NAME         ,
      fatt.application_name CONC_APPLICATION_NAME
FROM FND_REQUEST_GROUP_UNITS frgu,
  fnd_application_tl fat            ,
  FND_REQUEST_GROUPS frg            ,
  FND_CONCURRENT_PROGRAMS_VL fcpv   ,
  fnd_application_tl fatt,
  FND_REQUEST_SETS_VL FRSV,
  fnd_application_tl fat2
  WHERE  frgu.application_id    =   fat.application_id(+)
AND frgu.request_group_id       =   frg.request_group_id(+)
AND frgu.request_unit_id        =   fcpv.concurrent_program_id(+)
AND frgu.unit_application_id    =   fatt.application_id(+)
AND frgu.request_unit_id        =   frsv.request_set_id(+)
and frgu.request_unit_id        =   fat2.application_id(+)
--and frg.request_group_name ='All Reports'
--and fat.application_name ='Payables'
and fcpv.user_concurrent_program_name='XX AP Supplier Site Conversion Loader Program'