Saturday, August 7, 2010

Find Concurrent Program and Request Set 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 = '&RESPONSIBILITY_NAME'
 order by fcpt.user_concurrent_program_name

No comments:

Post a Comment