Tuesday 13 March 2012

Concurrent Program Attached to a Responsibility

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

No comments:

Post a Comment