add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, December 13

List of responsibilities assigned to user

Please provide user name as input

SELECT fu.user_name,
       frt.responsibility_name,
       furg.start_date,
       furg.end_date
  FROM fnd_user fu,
       fnd_user_resp_groups_direct furg,
       fnd_responsibility_vl frt
 WHERE     fu.user_id = furg.user_id
       AND frt.responsibility_id = furg.responsibility_id
       AND frt.application_id = furg.responsibility_application_id
       AND NVL (furg.end_date, SYSDATE + 1) > SYSDATE
       AND NVL (frt.end_date, SYSDATE + 1) > SYSDATE
       AND fu.user_name = upper( :p_user_name)

--and fu.user_name                   = :p_userid;
;

No comments: