Oracle Apps: List of Responsibilities attached with a Concurrent Program / Request Set

Some helpful queries to find the list of responsibilities to which a concurrent program  or a request set is attached. This helps to easily find out which responsibility can be used to submit a Concurrent Program / request Set.


#1. Query to find the list of responsibilities to which a Concurrent Program is attached.

 SELECT d.responsibility_name          responsibility  
       ,c.request_group_name           request_group  
       ,a.user_concurrent_program_name concurrent_program  
 FROM  apps.fnd_concurrent_programs_vl a  
      ,apps.fnd_request_group_units    b  
      ,apps.fnd_request_groups         c  
      ,apps.fnd_responsibility_vl      d  
 WHERE b.request_unit_id  = a.concurrent_program_id  
 AND   c.request_group_id = b.request_group_id  
 AND   d.request_group_id = b.request_group_id  
 AND   (a.user_concurrent_program_name LIKE 'User Concurrent Program Name'   
        OR  
        a.concurrent_program_name LIKE 'CONCURRENT_PROGRAM_NAME')  
 ORDER BY 1,2,3;

#2. Query to find the list of responsibilities to which a Request Set is attached.

 SELECT d.responsibility_name   responsibility  
       ,c.request_group_name    request_group  
       ,a.user_request_set_name request_set  
 FROM  apps.fnd_request_sets_vl     a  
      ,apps.fnd_request_group_units b  
      ,apps.fnd_request_groups      c  
      ,apps.fnd_responsibility_vl   d  
 WHERE b.request_unit_id  = a.request_set_id  
 AND   c.request_group_id = b.request_group_id  
 AND   d.request_group_id = b.request_group_id  
 AND   a.user_request_set_name LIKE 'Request Set Name'  
 ORDER BY 1,2,3;  

Feel free to point out if anything is missing/wrong in this blog.