Query to get list of responsibilities for a user in oracle apps

Query to get list of responsibilities for a user in oracle apps

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

Query to get list of responsibilities for a user in oracle apps

4 Important Table used by Query to get list of responsibilities for a user in oracle apps

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

Detail SQL Query to get list of responsibilities for a user in oracle apps

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 get list of responsibilities for a user in oracle apps

Query to get list of responsibilities for a user in oracle apps