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 = '&RESPONSIBILITY_NAME' order by fcpt.user_concurrent_program_name
No comments:
Post a Comment