responsibility - concurrent program - request set

To identify under which responsibility request set is available.

SELECT 'REQUEST SET' TYPE
,fr.responsibility_name
,frg.request_group_name
,frs.user_request_set_name
FROM
applsys.fnd_request_group_units frgus
,applsys.fnd_request_sets_vl frs
,applsys.fnd_request_groups frg
,applsys.fnd_responsibility_vl fr
WHERE 1=1
AND fr.request_group_id = frg.request_group_id
AND frg.request_group_id = frgus.request_group_id
AND frgus.request_unit_type = 'S'
AND frgus.request_unit_id = frs.request_set_id
AND frs.user_request_set_name LIKE &user_request_set_name

To identify under which responsibility the concurrent program is available.

SELECT 'CONC PROG' TYPE
,fr.responsibility_name
,frg.request_group_name
,fcp.user_concurrent_program_name
FROM
applsys.fnd_request_group_units frgup
,applsys.fnd_concurrent_programs_vl fcp
,applsys.fnd_request_groups frg
,applsys.fnd_responsibility_vl fr
WHERE 1=1
AND fr.request_group_id = frg.request_group_id
AND frg.request_group_id = frgup.request_group_id
AND frgup.request_unit_type = 'P'
AND frgup.request_unit_id = fcp.concurrent_program_id
AND fcp.user_concurrent_program_name LIKE &user_concurrent_program_name