Tags

, , , , ,

Quick query to find out a particular responsibility attached to which Oracle users:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SELECT fu.user_name, fu.description,furg.end_date
FROM
apps.fnd_user_resp_groups furg,
apps.FND_RESPONSIBILITY fr,
apps.fnd_responsibility_tl frt,
apps.fnd_user fu
WHERE 1=1
AND fu.user_id = furg.user_id
AND furg.responsibility_id = fr.RESPONSIBILITY_ID
AND frt.responsibility_id = fr.RESPONSIBILITY_ID
AND  frt.RESPONSIBILITY_NAME=:responsibility_name
ORDER BY 1

Advertisements