| Finding Concurrent Program attached to a particular Concurrent manager [message #461068] |
Wed, 16 June 2010 06:27  |
Nshan
Messages: 62
Registered: February 2009
|
Member |
|
|
Hi All,
I just want to know how to find one particular concurrent program has been attached to which concurrent manager.
Ex:
CC pgm name - Autoconfig Item
I can open concurrent manager and check whether it is having "Autoconfig Item" program under it. I do not want to look in that way. Because i have to open each and every manager and i have to check whether that particular program has been attached or not.
Is there any table which contains these details?
Kindly provide inputs on this.
Thanks,
Nshan.
|
|
|
|
|
|
| Re: Finding Concurrent Program attached to a particular Concurrent manager [message #461288 is a reply to message #461095] |
Thu, 17 June 2010 05:44  |
Nshan
Messages: 62
Registered: February 2009
|
Member |
|
|
Thanks Vamsi.
SELECT DISTINCT fcpg.concurrent_program_id
,fcpg.user_concurrent_program_name concurrent_program_name
,fcpg.description
,fcps.concurrent_queue_id
,fcq.concurrent_queue_name
,fcqt.user_concurrent_queue_name
,fcqt.description concurrent_queue_description
FROM fnd_concurrent_requests freq,
fnd_concurrent_programs_tl fcpg,
fnd_concurrent_processes fcps,
fnd_concurrent_queues fcq,
fnd_concurrent_queues_tl fcqt
WHERE fcpg.concurrent_program_id = 36888-- Pass concurrent program id,
AND fcpg.concurrent_program_id = freq.concurrent_program_id
AND fcpg.application_id=freq.program_application_id
AND freq.controlling_manager=fcps.concurrent_process_id
AND fcps.concurrent_queue_id=fcq.concurrent_queue_id
AND fcps.queue_application_id = fcq.application_id
AND fcqt.concurrent_queue_id=fcq.concurrent_queue_id;
This was the query i have framed.
Could any one please validate.
Thanks in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
