Find Concurrent Request picked up by which Concurrent Manager or Find the Manager Assignment for Concurrent Request

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='& Concurrent Program Name';

Get the Req-id from the user.
get the program name from Req-id