Query to find responsibility assigned to user in oracle apps r12

Query to find responsibility assigned to user in oracle apps r12

In this post , We will be discuss about Query to find responsibility assigned to user in oracle apps r12. This query will help to extract the list of responsibility assigned to user in oracle apps r12. We will get the complete details of user assigned responsibility details in oracle apps r12. This is one of the important sql query to fetch the details of users and its responsibility in oracle apps. Here below is the complete detail about Query to find responsibility assigned to user in oracle apps r12.

4 Important Table used by Query to find responsibility assigned to user in oracle apps r12

1.fnd_user_resp_groups_direct
2.fnd_responsibility
3.fnd_application_tl
4.fnd_application

Detail SQL Query to find responsibility assigned to user in oracle apps r12

SELECT fu.user_name                "User Name",
       frt.responsibility_name     "Responsibility Name",
       furg.start_date             "Responsibility Start Date",
       furg.end_date               "Responsibility End Date",
       fr.responsibility_key       "Responsibility Key",
       fa.application_short_name   "Application Short Name"
  FROM fnd_user_resp_groups_direct        furg,
       applsys.fnd_user                   fu,
       applsys.fnd_responsibility_tl      frt,
       applsys.fnd_responsibility         fr,
       applsys.fnd_application_tl         fat,
       applsys.fnd_application            fa
 WHERE furg.user_id             =  fu.user_id
   AND furg.responsibility_id   =  frt.responsibility_id
   AND fr.responsibility_id     =  frt.responsibility_id
   AND fa.application_id        =  fat.application_id
   AND fr.application_id        =  fat.application_id
 ORDER BY fu.user_name,frt.responsibility_name; 

Query to find responsibility assigned to user in oracle apps r12