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;