View: XDP_SUMMARY_QUEUES_V

Product:	XDP - Provisioning
Description:	This View shows the State of all the Queues
Implementation/DBA Data:	APPS.XDP_SUMMARY_QUEUES_V

View Text

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

Columns