query for various output of concurrent managers

PROMPT Programs and Managers

PROMPT Provide various output of concurrent managers related to a specific program.
PROMPT In this case using default of Item Supply/Demand program.

/* Formatted on 7/4/2014 1:40:47 PM (QP5 v5.115.810.9015) */
SELECT fcq.processor_application_id,
       fcp.concurrent_program_name,
       fr.responsibility_id,
       fr.responsibility_key,
       fr.data_group_id,
       fr.request_group_id,
       fr.application_id,
       fa.application_short_name,
       fcq.concurrent_queue_id,
       fcq.concurrent_queue_name,
       fcq.min_processes,
       fcq.target_processes,
       fcq.target_node,
       fcq.sleep_seconds,
       fcq.control_code,
       fcq.diagnostic_level,
       fcpr.*
FROM fnd_application fa,
     fnd_concurrent_programs fcp,
     fnd_conc_processor_programs fcpp,
     fnd_responsibility fr,
     fnd_concurrent_queues fcq,
     fnd_concurrent_processes fcpr
WHERE     fcq.processor_application_id = fcpp.processor_application_id
      AND fcq.concurrent_processor_id = fcpp.concurrent_processor_id
      AND fcpp.concurrent_program_id = fcp.concurrent_program_id
      AND fcpp.program_application_id = fcp.application_id
      AND fcp.application_id = fa.application_id
      AND fcp.concurrent_program_name =
            NVL ('&EnterProgramShortName', 'INXDSD')
      AND fr.application_id = 401
      AND fr.data_group_id = fcq.data_group_id
      AND fcq.manager_type = '3'
      AND fcpr.concurrent_queue_id = fcq.concurrent_queue_id
      AND fcpr.queue_application_id = fcq.application_id
      -- AND fcpr.process_status_code = 'A'
      AND fcpr.instance_number = USERENV ('instance')
ORDER BY DBMS_RANDOM.random;