Query to see OS process id given to Concurrent Manager Fndlibr

Query to see OS process id given to Concurrent Manager (Fndlibr)

SELECT a.concurrent_queue_name, SUBSTR(b.os_process_id,0,10) "OS Proc", b.oracle_process_id "Oracle ID", b.process_status_code

FROM fnd_concurrent_queues a

,fnd_concurrent_processes b

WHERE a.concurrent_queue_id=b.concurrent_queue_id

AND b.process_status_code='A'

ORDER BY b.process_status_code;