Oracle Apps Knowledge Sharing

Query to get list of users having sensitive responsibilities in Oracle Apps R12

Test Instance: R12.2.5

Query:

   SELECT fu.user_id,
          fu.user_name,
          frt.responsibility_name,
          TO_CHAR(furg.start_date,'DD-MON-YYYY') start_date,
          furg.end_date
     FROM fnd_user fu ,
          fnd_user_resp_groups_direct furg ,
          fnd_responsibility_vl frt
    WHERE fu.user_id                 = furg.user_id
      AND frt.responsibility_id        = furg.responsibility_id
      AND frt.application_id           = furg.responsibility_application_id
      AND NVL(furg.end_date,sysdate+1) > sysdate
      AND NVL(frt.end_date,sysdate +1) > sysdate
      AND NVL(fu.end_date,sysdate  +1) > sysdate
      AND frt.responsibility_name      IN ( 'System Administrator'
                                           ,'Application Developer'
                                           ,'Application Developer Common Modules'
                                           ,'CRM HTML Administration'
                                           ,'Functional Administrator' 
                                           ,'Functional Developer'
                                           ,'Knowledge Administrator'    
                                           ,'Oracle Sales Administrator' 
                                           ,'Sales Administrator'    
                                           ,'TeleSales Administration'           
	                                      );