Finding concurrent program assigned to which responsibilities



Finding concurrent program assigned to which responsibilities 

SELECT cp.user_concurrent_program_name, rg.request_group_name,
       rv.responsibility_name
  FROM fnd_concurrent_programs_vl cp,
       fnd_request_group_units rgu,
       fnd_request_groups rg,
       fnd_responsibility_vl rv
 WHERE rgu.request_unit_id = cp.concurrent_program_id
   AND rg.request_group_id = rgu.request_group_id
   AND rg.request_group_id = rv.request_group_id
   --AND CP.CONCURRENT_PROGRAM_id=42419
   AND cp.user_concurrent_program_name LIKE 'XXCUST%NA%COGS%'

Comments

Popular posts from this blog

XML Publisher Bursting