Below query can be a handy one to find the list of responsibilities where the concurret program is attached.
select frg.request_group_name
,fcpt.user_concurrent_program_name CONC_PGM_NAME
from fnd_concurrent_programs_tl fcpt
,fnd_request_group_units frgu
,fnd_request_groups frg
,fnd_responsibility fr
,fnd_responsibility_tl frt
where 1 = 1
and frgu.request_unit_id = fcpt.concurrent_program_id
and frg.request_group_id = frgu.request_group_id
and fr.request_group_id = frg.request_group_id
and frt.responsibility_id = fr.responsibility_id
and frt.language = USERENV('LANG')
and fcpt.language = USERENV('LANG')
and frt.responsibility_name = 'Purchasing Super User' --'Application Developer'--'&RESPONSIBILITY_NAME'
order by fcpt.user_concurrent_program_name
select frg.request_group_name
,fcpt.user_concurrent_program_name CONC_PGM_NAME
from fnd_concurrent_programs_tl fcpt
,fnd_request_group_units frgu
,fnd_request_groups frg
,fnd_responsibility fr
,fnd_responsibility_tl frt
where 1 = 1
and frgu.request_unit_id = fcpt.concurrent_program_id
and frg.request_group_id = frgu.request_group_id
and fr.request_group_id = frg.request_group_id
and frt.responsibility_id = fr.responsibility_id
and frt.language = USERENV('LANG')
and fcpt.language = USERENV('LANG')
and frt.responsibility_name = 'Purchasing Super User' --'Application Developer'--'&RESPONSIBILITY_NAME'
order by fcpt.user_concurrent_program_name
No comments:
Post a Comment