Query to get concurrent Program Assignment with Concurrent Manager
As we all know, by default all programs assigned to the "Standard Manager" concurrent manager. We create specific queues for heavy or critical programs to avoid the normal queues and work in dedicated queues.
It's like VIP queue created for special programs :)
Following is the query, which we can use to get the program exclusion from the specific queue and assign it to the VIP queue.
select fcqc.queue_application_id,fcqc.concurrent_queue_id
,fcqv.user_concurrent_queue_name,fcqv.enabled_flag
,fcqc.include_flag,fcqc.type_application_id
,fcqc.type_id,fcpt.user_concurrent_program_name
from FND_CONCURRENT_QUEUE_CONTENT fcqc
, fnd_concurrent_programs_tl fcpt
, FND_CONCURRENT_QUEUES_VL fcqv
where fcqc.type_code = 'P'
and fcqc.type_application_id = fcpt.application_id
and fcqc.type_id = fcpt.concurrent_program_id
and fcpt.user_concurrent_program_name = 'Check Periodic Alert'
and fcqc.queue_application_id = fcqv.application_id
and fcqc.concurrent_queue_id = fcqv.concurrent_queue_id
and fcpt.language = 'US';
