Monday, June 12, 2017

List Particular Responsibilities for All User

SELECT fu.user_name,frt.RESPONSIBILITY_NAME
FROM
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
WHERE fu.user_id = furg.user_id
AND furg.responsibility_id = fr.RESPONSIBILITY_ID
AND frt.responsibility_id = fr.RESPONSIBILITY_ID
AND frt.responsibility_name like '%system%Admi%'
ORDER BY 1

No comments:

Post a Comment