oracle ebs 11i > concurrent programs –> request group –> responsibility

--concurrent programs
--request group
--responsibility
SELECT frg.application_id
     , frg.request_group_id
     , frgu.request_unit_type
     , frg.request_group_name
     , frg.description request_group_desc
     , fcpl.concurrent_program_name
     , fcpl.user_concurrent_program_name
     , fcpl.description conc_desc
     , fr.responsibility_key
     , frt.responsibility_name
  FROM fnd_responsibility_tl frt
     , fnd_responsibility fr
     , fnd_request_groups frg
     , fnd_request_group_units frgu
     , fnd_concurrent_programs_vl fcpl
WHERE     1 = 1
       AND fcpl.queue_control_flag = ‘N‘
       AND (fcpl.executable_id IN
               (SELECT fe.executable_id
                  FROM fnd_executables fe
                 WHERE fe.executable_name LIKE ‘XX_WIP046‘))
       AND (fcpl.executable_application_id IN
               (SELECT fe.application_id
                  FROM fnd_executables fe
                 WHERE fe.executable_name LIKE ‘XX_WIP046‘))
       AND fcpl.concurrent_program_id = frgu.request_unit_id(+)
       AND frg.request_group_id = frgu.request_group_id
       AND frg.request_group_id = fr.request_group_id(+)
       AND fr.responsibility_id = frt.responsibility_id(+);