Tuesday, October 11, 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:

Post a Comment