View: XDP_READY_ORDER_V

Product:	XDP - Provisioning
Description:	This View shows all the Orders in the Order Ready Queue
Implementation/DBA Data:	APPS.XDP_READY_ORDER_V

View Text

SELECT OH.EXTERNAL_ORDER_NUMBER EXTERNAL_ORDER_ID
, OH.EXTERNAL_ORDER_VERSION EXTERNAL_ORDER_VERSION
, XDP_SYSCN_UTIL.GET_Q_DATA_NUM( OPQ.USER_DATA
, 'ORDER_ID' ) INTERNAL_ORDER_ID
, OPQ.ENQ_TIME QUEUED_ON
, OH.DUE_DATE DUE_DATE
, OH.PROVISIONING_DATE PROVISIONING_DATE
, OPQ.PRIORITY PRIORITY
FROM XDP_ORDER_HEADERS OH
, XDP_ORDER_PROCESSOR_QTAB OPQ
WHERE OH.ORDER_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM( OPQ.USER_DATA
, 'ORDER_ID' )
AND OH.MSGID = OPQ.MSGID

Columns