Query to find the responsibility attached to user in oracle apps

Query to find the responsibility attached to user in oracle apps.

 

This below query helps to extract the Oracle Applications User Responsibilities data. This query helps to find responsibility assigned to user in oracle apps r12. This query helps to find active users in oracle apps.

Query to find the responsibility attached to user in oracle apps

SELECT fu.user_name               ,

       frt.responsibility_name   ,

       furg.start_date           ,

       furg.end_date           ,      

       fr.responsibility_key      ,

       fa.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

   AND FU.END_DATE is null

   and furg.END_DATE is null

 ORDER BY fu.user_name,frt.responsibility_name;