/* Formatted on 7/17/2014 5:38:54 PM (QP5 v5.115.810.9015) */
SELECT prog.concurrent_program_id,
prog.concurrent_program_name,
prog.user_concurrent_program_name,
exe.executable_name,
exe.execution_file_name,
exe.execution_method_code,
grp.request_group_name,
resp.responsibility_name
FROM apps.fnd_concurrent_programs_vl prog,
apps.fnd_executables exe,
apps.fnd_request_group_units prog_unit,
apps.fnd_request_groups grp,
apps.fnd_responsibility_vl resp
WHERE (prog.user_concurrent_program_name LIKE '%'
OR prog.concurrent_program_name LIKE '%')
AND prog.executable_application_id = exe.application_id
AND prog.executable_id = exe.executable_id
AND prog.concurrent_program_id = prog_unit.request_unit_id
AND prog.application_id = prog_unit.unit_application_id
AND prog_unit.request_group_id = grp.request_group_id
AND prog_unit.application_id = grp.application_id
AND resp.request_group_id = grp.request_group_id
AND resp.group_application_id = grp.application_id
ORDER BY prog.user_concurrent_program_name,
grp.request_group_name,
resp.responsibility_name;
SELECT prog.concurrent_program_id,
prog.concurrent_program_name,
prog.user_concurrent_program_name,
exe.executable_name,
exe.execution_file_name,
exe.execution_method_code,
grp.request_group_name,
resp.responsibility_name
FROM apps.fnd_concurrent_programs_vl prog,
apps.fnd_executables exe,
apps.fnd_request_group_units prog_unit,
apps.fnd_request_groups grp,
apps.fnd_responsibility_vl resp
WHERE (prog.user_concurrent_program_name LIKE '%'
OR prog.concurrent_program_name LIKE '%')
AND prog.executable_application_id = exe.application_id
AND prog.executable_id = exe.executable_id
AND prog.concurrent_program_id = prog_unit.request_unit_id
AND prog.application_id = prog_unit.unit_application_id
AND prog_unit.request_group_id = grp.request_group_id
AND prog_unit.application_id = grp.application_id
AND resp.request_group_id = grp.request_group_id
AND resp.group_application_id = grp.application_id
ORDER BY prog.user_concurrent_program_name,
grp.request_group_name,
resp.responsibility_name;
No comments:
Post a Comment