Form function attached to which responsibility and user

By admin

Form function attached to which responsibility and user
Oracle apps Form function responsibility
Oracle ebs form responsibility

SQL Querysql
1SELECT DISTINCT rtl.responsibility_name,
2                ff.function_name,
3                ffl.user_function_name,
4                usr.user_name
5  FROM fnd_compiled_menu_functions cmf,
6       fnd_form_functions          ff,
7       fnd_form_functions_tl       ffl,
8       fnd_responsibility          r,
9       fnd_responsibility_tl       rtl,
10       fnd_user_resp_groups        urg,
11       fnd_user                    usr
12 WHERE     cmf.function_id = ff.function_id
13       AND r.menu_id = cmf.menu_id
14       AND urg.responsibility_id = r.responsibility_id
15       AND rtl.responsibility_id = r.responsibility_id
16       AND cmf.grant_flag = 'Y'
17       AND r.application_id = urg.responsibility_application_id
18       AND usr.user_id = urg.user_id
19       AND UPPER (ffl.user_function_name) = UPPER ('Invoices') --Enter the form function name here
20       AND ff.function_id = ffl.function_id
21--     AND responsibility_name LIKE 'AP%'
22;

Related posts: