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 Query
sql
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;