How to find the concurrent program assigned to which concurrent manager using request ID

 

Use below query to find concurrent program assigned to which concurrent manager using concurrent request ID.

select b.USER_CONCURRENT_QUEUE_NAME from apps.fnd_concurrent_processes a,
fnd_concurrent_queues_vl b, fnd_concurrent_requests c
where a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID
and a.CONCURRENT_PROCESS_ID = c.controlling_manager
and c.request_id = <Request ID>;

Thanks for going through the post...........