Thursday, April 10, 2008

Responsibilities that have Access to a Request Set


SELECT reqset.request_set_id
, reqset.request_set_name
, reqset.user_request_set_name
, grp.request_group_name
, resp.responsibility_name
FROM apps.fnd_request_sets_vl reqset
, apps.fnd_request_group_units prog_unit
, apps.fnd_request_groups grp
, apps.fnd_responsibility_vl resp
WHERE (reqset.user_request_set_name LIKE '%' OR
reqset.request_set_name LIKE '%' )
AND reqset.request_set_id = prog_unit.request_unit_id
AND reqset.application_id = prog_unit.unit_application_id
AND prog_unit.request_group_id = grp.request_group_id
AND prog_unit.application_id = grp.application_id
AND resp.request_group_id = grp.request_group_id
AND resp.group_application_id = grp.application_id
ORDER BY reqset.user_request_set_name
, grp.request_group_name
, resp.responsibility_name;

No comments:

Post a Comment