Thursday, April 10, 2008

Responsibilities that have Access to a Particular Program


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