To get responsibility and attached request groups.

SELECTresponsibility_name responsibility, request_group_name, frg.description

FROMfnd_request_groups frg, fnd_responsibility_vl frv

WHERE frv.request_group_id =frg.request_group_id

ORDER BYresponsibility_name