To get responsibility and attached request groups

SELECT
responsibility_name responsibility,

request_group_name,

frg.description

FROM
fnd_request_groups frg,
fnd_responsibility_vl frv

WHERE
frv.request_group_id = frg.request_group_id

ORDER BY
responsibility_name