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 FND users having particular responsibility



SELECT DISTINCT res.responsibility_name, usr.user_name, usr.description
           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 res.responsibility_name IN ('System Administrator') --Enter responsibility name here
            AND usr.end_date IS NULL   --For Active users
            AND en.end_date IS NULL
       ORDER BY responsibility_name;

No comments:

Post a Comment