[Home] [Help]
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
Name |
EXTERNAL_ORDER_ID |
EXTERNAL_ORDER_VERSION |
INTERNAL_ORDER_ID |
QUEUED_ON |
DUE_DATE |
PROVISIONING_DATE |
PRIORITY |