Purpose To get all Request attached to a responsibility

SELECT
responsibility_name ,

frg.request_group_name,

fcpv.user_concurrent_program_name,

fcpv.description

FROM
fnd_request_groups frg,

fnd_request_group_units frgu,

fnd_concurrent_programs_vl fcpv,

fnd_responsibility_vl frv

WHERE
frgu.request_unit_type = 'P'

AND frgu.request_group_id = frg.request_group_id

AND frgu.request_unit_id = fcpv.concurrent_program_id

AND frv.request_group_id = frg.request_group_id

ORDER BY
responsibility_name