Way to success...

--"Running Away From Any PROBLEM Only Increases The DISTANCE From The SOLUTION"--.....--"Your Thoughts Create Your FUTURE"--.....--"EXCELLENCE is not ACT but a HABIT"--.....--"EXPECT nothing and APPRECIATE everything"--.....

Wednesday, December 23, 2015

Query to get list of responsibilities assigned to particular FND user



SELECT   usr.user_name,usr.description,res.responsibility_name, en.start_date
        -- en.end_date,
FROM     fnd_user usr,
         fnd_user_resp_groups_direct en,
         fnd_responsibility_vl res
   WHERE usr.user_id = en.user_id
     AND en.responsibility_id = res.responsibility_id
     AND usr.user_name IN ('RRC41569') --Enter FND username here
     AND usr.end_date IS NULL
     AND en.end_date IS NULL                    --Without end Date
ORDER BY responsibility_name;

No comments:

Post a Comment