Query to find application short name and responsibility key in oracle apps

Query to find application short name and responsibility key in oracle apps

In this post , We will be discuss about Query to find application short name and responsibility key in oracle apps. This sql query will help to extract the complete details of Responsibility and application informations in oracle apps. This query will also help to extract the application short name and responsibility key information in oracle apps. Please find below the detail about Query to find application short name and responsibility key in oracle apps.

Query to find application short name and responsibility key in oracle apps

4 Important Table used by Query to find application short name and responsibility key in oracle apps

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

Detail SQL Query to find application short name and responsibility key 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 find application short name and responsibility key in oracle apps