select fcq.application_id "Application Id",
fcq.concurrent_queue_name, fcq.user_concurrent_queue_name "Service",
fa.application_short_name, fcq.target_node "Node",
fcq.max_processes "Target",
fcq.node_name "Primary", fcq.node_name2 "Secondary",fcq.cache_size "Cache Size",
fcp.concurrent_processor_name "Program Library",
sleep_seconds
from apps.fnd_concurrent_queues_vl fcq, apps.fnd_application fa, apps.fnd_concurrent_processors fcp
where fcq.application_id = fa.application_id
and fcq.processor_application_id = fcp.application_id
and fcq.concurrent_processor_id = fcp.concurrent_processor_id and fcq.enabled_flag='Y';