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: