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