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
WHERE phase_code = ‘R’
GROUP BY concurrent_queue_name
ORDER BY Running desc
count of Pending processes in queue