CM

SET LINESIZE 220

SET PAGESIZE 200

COLUMN concurrent_queue_name      FORMAT A35

COLUMN user_concurrent_queue_name FORMAT A50

COLUMN node_name                  FORMAT A25

COLUMN target_node                FORMAT A25

SELECT concurrent_queue_name,

       user_concurrent_queue_name,

       enabled_flag,

       node_name,

       target_node,

       max_processes,

       running_processes

FROM apps.fnd_concurrent_queues_vl

WHERE manager_type = '0'

ORDER BY user_concurrent_queue_name;