Saturday, 1 July 2017

Query to find all the responsibilities Assigned to a user in Oracle Apps

SELECT fu.user_name,
       fr.responsibility_name,
       furg.START_DATE,
       furg.END_DATE
  FROM fnd_user_resp_groups_direct  furg,
       fnd_user                     fu,
       fnd_responsibility_tl        fr
 WHERE     fu.user_name = 'USER_NAME'
       AND furg.user_id = fu.user_id
       AND furg.responsibility_id = fr.responsibility_id
       AND fr.language = USERENV ('LANG');

No comments:

Post a Comment