Sunday, October 4, 2009

List of responsibilities assigned to specific user

SELECT
UNIQUE u.user_id,
u.user_name,
r.responsibility_name,
a.application_name
FROM
fnd_user u,
fnd_user_resp_groups g,
fnd_application_tl a,
fnd_responsibility_tl r
WHERE
g.user_id(+) = u.user_id AND
g.responsibility_application_id = a.application_id AND
a.application_id = r.application_id AND
g.responsibility_id = r.responsibility_id and
a.application_name like 'Projects'
ORDER BY SUBSTR (user_name, 1, 30)
, SUBSTR (a.application_name, 1, 50)
, SUBSTR (r.responsibility_name, 1, 60)

No comments:

Post a Comment

Blog Archive