Query to Find the Concurrent Manager for a Concurrent Program

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;