Query to fetch users assigned to a responsibility

Query to fetch users assigned to a responsibility, www.askhareesh.com

SELECT fu.user_name
  FROM FND_USER_RESP_GROUPS fur, fnd_responsibility_tl fr, fnd_user fu
 WHERE     fr.language = 'US'
       AND fr.responsibility_name LIKE :responsibility_name
       AND fr.responsibility_id = fur.responsibility_id
       AND fu.user_id = fur.user_id

*/

No comments:

Post a Comment