Query to get Concurrent Program and Related Resposnibility, Request Group in which its assigned.

--Query to get Standalone Request/Concurrent Program Info
SELECT distinct frv.responsibility_name,
       frg.request_group_name,
       frgu.request_unit_type,
       frgu.request_unit_id,
       fcpt.user_concurrent_program_name,
       null request_set_name
  FROM fnd_responsibility_vl frv
      ,fnd_request_groups frg
      ,FND_REQUEST_GROUP_UNITS frgu
      ,fnd_concurrent_programs fcp
      ,fnd_concurrent_programs_tl fcpt
WHERE  1=1
   AND frv.request_group_id= frg.request_group_id
   AND frgu.request_group_id= frg.request_group_id
   AND fcpt.application_id= frgu.unit_application_id
   AND fcp.concurrent_program_id= frgu.request_unit_id
   AND fcpt.concurrent_program_id=fcp.concurrent_program_id
   AND fcpt.user_concurrent_program_name like '%Concurrent Program Name%'