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');
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