Below is a custom query to display con-current queue activities in Oracle Apps environment.
This query show a count of running request by queue name in in a descending order
SELECT concurrent_queue_name,
COUNT(phase_code) Running
FROM fnd_concurrent_worker_requests
WHERE phase_code = ‘R’
GROUP BY concurrent_queue_name
ORDER BY Running desc
count of Pending processes in queue