Query to fetch Responsibilities attached to a User
FROM fnd_user fu,
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‘);
Leave a ReplyWant to join the discussion?
Feel free to contribute!