To Identify the manager for a given concurrent program

The script given below identifies which manager is going to execute a given Concurrent program:

SELECT user_concurrent_program_name, user_concurrent_queue_name
FROM apps.fnd_concurrent_programs_tl fcp,
apps.fnd_concurrent_queue_content fcqc,
apps.fnd_concurrent_queues_tl cq
WHERE
fcqc.type_application_id(+) = fcp.application_id
AND
fcqc.type_id(+) = fcp.concurrent_program_id
AND
fcqc.type_code(+) = ‘P’
AND
fcqc.include_flag(+) = ‘I’
AND
fcp.LANGUAGE = ‘US’
AND
fcp.user_concurrent_program_name = ‘&USER_CONCURRENT_PROGRAM_NAME’ AND
NVL (cqc.concurrent_queue_id, 0) = cq.concurrent_queue_id
AND
NVL (cqc.queue_application_id, 0) = cq.application_id
AND
cq.LANGUAGE = ‘US’

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.