Query to fetch Responsibilities attached to a User
September 2, 2010 Leave a comment
Query to fetch Responsibilities attached to a user:
The below query will fetch the responsibilities assigned to a particular user.
SELECT fu.user_id, fu.user_name, fr.responsibility_name, fr.description, fa.application_name FROM fnd_user fu, fnd_user_resp_groups g, fnd_application_tl fa, fnd_responsibility_tl fr WHERE g.user_id(+) = fu.user_id AND g.responsibility_application_id = fa.application_id AND fa.application_id = fr.application_id AND g.responsibility_id = fr.responsibility_id AND fu.user_name =UPPER('User_Name');