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:
- Register a test concurrent program from backend in Oracle EBS
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Query to find vacation rules in Oracle R12
- View java class source in oracle database
- Load Java source code in oracle database
- Query to find all APIs of Oracle Apps modules
- OAF customizations queries
- Oracle apps list of concurrent programs in a Request Set
- Query to get Organization Hierarchy in Oracle apps
- Oracle apps query to find incompatible programs blocking a concurrent request
- Query to find the responsibility attached to user in oracle apps
- How to enable debug log in Oracle apps EBS