VIEW: APPS.XDP_SUMMARY_QUEUES_V

Source

View Text - Preformatted

SELECT DQC.DISPLAY_NAME QTYPE ,DQC.STATE STATE ,DQC.INTERNAL_Q_NAME Q_NAME ,DQC.NUM_OF_DQER PROCESSORS_REGISTERED ,NVL(DQC.DISPLAY_SEQUENCE,ROWNUM) SEQ , (SELECT flk.meaning FROM fnd_lookups flk WHERE flk.lookup_type = 'XDP_AQ_STATE            AND flk.lookup_code = dqc.state') STATE_MEANING FROM XDP_DQ_CONFIGURATION_VL DQC

View Text - HTML Formatted

SELECT DQC.DISPLAY_NAME QTYPE
, DQC.STATE STATE
, DQC.INTERNAL_Q_NAME Q_NAME
, DQC.NUM_OF_DQER PROCESSORS_REGISTERED
, NVL(DQC.DISPLAY_SEQUENCE
, ROWNUM) SEQ
, (SELECT FLK.MEANING
FROM FND_LOOKUPS FLK
WHERE FLK.LOOKUP_TYPE = 'XDP_AQ_STATE
AND FLK.LOOKUP_CODE = DQC.STATE') STATE_MEANING
FROM XDP_DQ_CONFIGURATION_VL DQC