SELECT r.responsibility_key, fa.application_short_name
FROM fnd_user u,
fnd_user_resp_groups ur,
fnd_responsibility r,
fnd_application_tl a,
fnd_application fa
WHERE u.user_id = ur.user_id
AND u.user_name = :p_user_name
AND r.version = 'W'
AND ur.responsibility_id = r.responsibility_id
AND fa.application_id = a.application_id
AND r.application_id = a.application_id
ORDER BY 1
No comments:
Post a Comment