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