Query To Find Request Set Details

SELECT

  fav.application_short_name,

  fav.application_name,

  frt.responsibility_name,

  frg.request_group_name,

  fcpt.request_set_name,

  fcpt.user_request_set_name

FROM

  apps.fnd_responsibility_vl frt,

  apps.fnd_request_groups frg,

  apps.fnd_request_group_units frgu,

  apps.fnd_request_Sets_vl fcpt,

  apps.fnd_application_vl fav

WHERE 1 = 1

  AND frg.request_group_id = frt.request_group_id

  AND frgu.request_group_id = frg.request_group_id

  AND fcpt.request_set_id = frgu.request_unit_id

  AND fcpt.application_id = fav.application_id

  AND fcpt.user_request_set_name LIKE 'XXRJ%'

ORDER BY 1,2,3,4