DCP

Thursday 22 September 2016

SQLFND - Query to Find who has access to given Responsibility

SELECT fu.user_id, fu.user_name, fu.email_address
    FROM fnd_user_resp_groups_direct furg,
         fnd_user fu,
         fnd_responsibility_tl fr
   WHERE     UPPER (fr.responsibility_name) = UPPER ('&Enter_Resp_Name')
         AND fr.responsibility_id = furg.responsibility_id
         AND furg.user_id = fu.user_id
         AND NVL(furg.end_date, SYSDATE) > SYSDATE
         AND fu.end_date IS NULL
         AND fr.language = USERENV ('LANG')
ORDER BY fu.user_name;

No comments:

Post a Comment