Scipt to Find the Concurrent Manager for a Concurrent Program

We can use the below query to find the Manager name for a Concurrent Program


Script

SELECT 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_VL fcq
 WHERE     type_id = fcp.concurrent_program_id
       AND fcp.concurrent_program_name = '&PROGRAM_SHORT_NAME'
       AND fcq.concurrent_queue_id = fcqc.concurrent_queue_id;
 

Thanks

Srini