Query for Pending/Running Requests in Oracle Apps

Query for Pending/Running Requests in Oracle Apps, askhareesh blog for Oracle Apps

SELECT    request_id,
               phase_code,
               status_code,
               user_name,
               user_concurrent_queue_name
FROM       fnd_concurrent_worker_requests fcwr,
              fnd_concurrent_queues_tl fcqt,
              fnd_user fu
WHERE   (fcwr.phase_code = 'P' OR fcwr.phase_code = 'R')
AND        fcwr.hold_flag != 'Y'
AND        fcwr.requested_start_date <= SYSDATE
AND        fcwr.concurrent_queue_id = fcqt.concurrent_queue_id
AND        fcwr.queue_application_id = fcqt.application_id
AND        fcqt.LANGUAGE = 'US'
AND        fcwr.requested_by = fu.user_id
ORDER BY 5


*/