Form function attached to which responsibility and user
Oracle apps Form function responsibility
Oracle ebs form responsibility
SELECT DISTINCT rtl.responsibility_name,
ff.function_name,
ffl.user_function_name,
usr.user_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 usr
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 usr.user_id = urg.user_id
AND UPPER (ffl.user_function_name) = UPPER ('Invoices') --Enter the form function name here
AND ff.function_id = ffl.function_id
-- AND responsibility_name LIKE 'AP%'
;
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
- Form function attached to which responsibility and user
- Query to find the responsibility attached to user in oracle apps
- How to enable debug log in Oracle apps EBS
- How to add AME role and responsibility to user
- Oracle form attached to which responsibility
- SQL query to get MIME type for file extension
- Query to get concurrent program and executable details
- Query to get responsibility level profile option values
- Query to validate migration of XML/BI Publisher Template and Data Definition
- Query to get details of XML/BI Publisher Template and Data Definition
- Query to get Site level and Organization level Profile Option Value
- PL-SQL code to reset application user password
- PL-SQL Procedure to send email with attachment
- PL-SQL to delete Concurrent Program and Executable
- Query to get the details of the lock in the database
- PL-SQL code to delete XML/BI Publisher template and Data Definition
- Query to find Form Personalization
- Query to find profile option values
- Query to get details of concurrent program parameters
- PL-SQL Code to find Menu Hierarchy of a responsibility
- Query to find details of Flex value sets
- Query to find concurrent program Responsibility and Request Group
- Concurrent program SQL statement currently running in background
- Query to find scheduled concurrent programs
- Query to kill database session for a concurrent request
- Query to get DFF (Descriptive Flex Field) Details