SELECT DISTINCT u.user_name, rtl.responsibility_name, ff.function_name, ffl.user_function_name FROM fnd_compiled_menu_functions cmf, fnd_form_functions ff, fnd_form_functions_tl ffl, fnd_responsibility r, fnd_responsibility_tl rtl, fnd_user_resp_groups urg, fnd_user u WHERE cmf.function_id = ff.function_id AND r.menu_id = cmf.menu_id AND urg.responsibility_id = r.responsibility_id AND rtl.responsibility_id = r.responsibility_id AND cmf.grant_flag = 'Y' AND r.application_id = urg.responsibility_application_id AND u.user_id = urg.user_id --and ff.function_id=19438 AND UPPER (ffl.user_function_name) LIKE UPPER ('Users') --Enter user function name here AND ff.function_id = ffl.function_id ORDER BY u.user_name;
No comments:
Post a Comment