Thursday, September 15, 2011

Query to find the responsibilities assigned to the user

SELECT UNIQUE u.description, u.user_name user_name,
r.responsibility_name responsiblity,
a.application_name application
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 g.end_date IS NULL
AND u.end_date IS NULL
AND a.application_id in (275,809)
ORDER BY u.user_name

No comments:

Post a Comment