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');
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');
No comments:
Post a Comment