List Responsibilities That Can Run a Given Concurrent Program

set verify off

set pagesize 1000

column RN format A40 heading "Responsibility Name"

prompt

prompt &1 can be run by:

SELECT responsibility_name RN

FROM fnd_request_groups frg,

fnd_request_group_units frgu,

fnd_concurrent_programs_vl fcpv,

fnd_responsibility_vl frv

WHERE frgu.request_unit_type = 'P'

AND (UPPER(fcpv.concurrent_program_name) = UPPER('&1') OR

UPPER(fcpv.user_concurrent_program_name) = UPPER('&1'))

AND frgu.request_group_id = frg.request_group_id

AND frgu.request_unit_id = fcpv.concurrent_program_id

AND frv.request_group_id = frg.request_group_id

ORDER BY responsibility_name

/

Metalink note: 134036.1