-- get list of responsibilities that can access request set

SELECT distinct c.user_request_set_name, a.request_group_name,
d.responsibility_name , a.*,b.*
FROM apps.fnd_request_groups a,
apps.fnd_request_group_units b,
apps.fnd_request_sets_vl c,
apps.fnd_responsibility_vl d
WHERE a.request_group_id = b.request_group_id
AND a.application_id = b.application_id
AND c.request_set_id = b.request_unit_id
AND d.request_group_id = a.request_group_id
and c.user_request_set_name='Extract Data from GLP to FIS'