Sunday, October 4, 2009

Query to fetch all request groups attached to responsibility

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

No comments:

Post a Comment

Blog Archive