Query to Find the Concurrent Manager for a Concurrent Program


Script:

SELECT distinct fcqc.INCLUDE_FLAG,
       fcqc.QUEUE_APPLICATION_ID,
       fcq.USER_CONCURRENT_QUEUE_NAME,
       fcp.CONCURRENT_PROGRAM_NAME
  FROM APPLSYS.FND_CONCURRENT_QUEUE_CONTENT fcqc,
       APPLSYS.FND_CONCURRENT_PROGRAMS fcp,
       APPS.FND_CONCURRENT_QUEUES_TL fcq
 WHERE     type_id = fcp.concurrent_program_id
AND fcp.concurrent_program_name = '&PROGRAM_SHORT_NAME'
  and fcqc.INCLUDE_FLAG='I'
       AND fcq.concurrent_queue_id = fcqc.concurrent_queue_id;