11 October 2011

How to check which concurrent program attached to which responsibility

Execute following select statement to know the responsibilities names to which your concurrent program is attached

 SELECT responsibility_name
  FROM fnd_responsibility_tl a,
       fnd_responsibility c,                       
       fnd_request_group_units d,
       fnd_concurrent_programs_tl b
 WHERE     a.responsibility_id = c.responsibility_id
       AND c.request_group_id = d.request_group_id
       AND b.concurrent_program_id = d.request_unit_id
       AND UPPER (b.USER_CONCURRENT_PROGRAM_NAME) =
              UPPER ('Enter your program Name');

Example:-
/* Formatted on 10/11/2011 5:27:36 PM (QP5 v5.163.1008.3004) */
SELECT responsibility_name
  FROM fnd_responsibility_tl a,
       fnd_responsibility c,                      
       fnd_request_group_units d,
       fnd_concurrent_programs_tl b
 WHERE     a.responsibility_id = c.responsibility_id
       AND c.request_group_id = d.request_group_id
       AND b.concurrent_program_id = d.request_unit_id
       AND UPPER (b.USER_CONCURRENT_PROGRAM_NAME) =
              UPPER ('Qtel CI TO IRB Interface Program');

No comments: