Thursday, May 28, 2015

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: