Oracle Apps - Query to list the responsibility to which the concurrent
program is assigned
Query to find the responsibilities to which
the concurrent program is assigned.
select frt.responsibility_name,
frg.request_group_name,
frgu.request_unit_type,
frgu.request_unit_id,
fcpt.user_concurrent_program_name
from fnd_Responsibility
fr,
fnd_responsibility_tl
frt,
fnd_request_groups
frg,
fnd_request_group_units
frgu,
fnd_concurrent_programs_tl
fcpt
where frt.responsibility_id
= fr.responsibility_id
and frg.request_group_id
= fr.request_group_id
and frgu.request_group_id
= frg.request_group_id
and fcpt.concurrent_program_id
= frgu.request_unit_id
and fcpt.user_concurrent_program_name
= :P_CONCURRENT_PROGRAM_NAME
order by 1,2,3,4
