Finding concurrent program assigned to which responsibilities
Finding concurrent program assigned to which
responsibilities
SELECT cp.user_concurrent_program_name, rg.request_group_name,
rv.responsibility_name
FROM
fnd_concurrent_programs_vl cp,
fnd_request_group_units rgu,
fnd_request_groups rg,
fnd_responsibility_vl rv
WHERE rgu.request_unit_id = cp.concurrent_program_id
AND
rg.request_group_id = rgu.request_group_id
AND
rg.request_group_id = rv.request_group_id
--AND CP.CONCURRENT_PROGRAM_id=42419
AND
cp.user_concurrent_program_name LIKE 'XXCUST%NA%COGS%'
Comments
Post a Comment