Thursday, 17 July 2014

Responsibilities that have Access to a Particular Program Query

/* 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;

No comments:

Post a Comment