SQL to find all the Responsibilities to which a Concurrent Program is attached
SELECT resp_tl.responsibility_name,
rg.request_group_name
FROM fnd_concurrent_programs_tl prog_tl,
fnd_concurrent_programs prog,
fnd_request_group_units unit,
fnd_request_groups rg,
fnd_responsibility resp,
fnd_responsibility_tl resp_tl
WHERE prog_tl.user_concurrent_program_name = '&Program_Name'
AND unit.request_unit_id = prog.concurrent_program_id
AND prog_tl.concurrent_program_id = prog.concurrent_program_id
AND resp.request_group_id = unit.request_group_id
AND resp.request_group_id = rg.request_group_id
AND resp_tl.responsibility_id = resp.responsibility_id
ORDER BY 2,1;
No comments:
Post a Comment