Query to find the responsibility attached to user in oracle apps
•By admin
How to find responsibilities attached to user in Oracle apps
Query to find the responsibility attached to user in oracle apps
Query to fetch Responsibilities attached to a User
Query to find users attached to responsibility
How to check user responsibility in Oracle apps
Oracle EBS user responsibilities
Oracle apps responsibility users
SQL Querysql
1SELECT fu.user_name "User Name",
2 frt.responsibility_name "Responsibility Name",
3 furg.start_date "Start Date",
4 furg.end_date "End Date",
5 fr.responsibility_key "Responsibility Key",
6 fa.application_short_name "Application Short Name"
7 FROM fnd_user_resp_groups_direct furg,
8 applsys.fnd_user fu,
9 applsys.fnd_responsibility_tl frt,
10 applsys.fnd_responsibility fr,
11 applsys.fnd_application_tl fat,
12 applsys.fnd_application fa
13 WHERE furg.user_id = fu.user_id
14 AND furg.responsibility_id = frt.responsibility_id
15 AND fr.responsibility_id = frt.responsibility_id
16 AND fa.application_id = fat.application_id
17 AND fr.application_id = fat.application_id
18 AND frt.language = USERENV ('LANG')
19 AND UPPER (fu.user_name) = UPPER ('AMOL') -- modify user name
20-- AND frt.responsibility_name like 'AP%'
21ORDER BY frt.responsibility_name;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
- How to enable debug log in Oracle apps EBS