Monday, 11 May 2015

Oracle Apps How to Find the Concurrent Request



Hi Folks

Below is the query to find out the Concurrent Name.

select a.user_concurrent_queue_name
from fnd_concurrent_queues_vl a,
FND_CONCURRENT_QUEUE_CONTENT b,
fnd_concurrent_programs_vl c
where a.concurrent_queue_id=b.concurrent_queue_id
and b.type_id = c.concurrent_program_id

and c.user_concurrent_program_name=:RequestName

No comments:

Post a Comment