[Home] [Help]
View: XDP_PEND_ORDER_V
Product: | XDP - Provisioning |
Description: | This View shows all the Orders in the Pending Order Queue. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT OH.EXTERNAL_ORDER_NUMBER EXTERNAL_ORDER_ID
, OH.EXTERNAL_ORDER_VERSION EXTERNAL_ORDER_VERSION
, XDP_SYSCN_UTIL.GET_Q_DATA_NUM( PEOQ.USER_DATA
, 'ORDER_ID' ) INTERNAL_ORDER_ID
, LK.MEANING STATE
, PEOQ.ENQ_TIME QUEUED_ON
, OH.DUE_DATE DUE_DATE
, OH.PROVISIONING_DATE PROVISIONING_DATE
, PEOQ.PRIORITY PRIORITY
FROM FND_LOOKUPS LK
, XDP_ORDER_HEADERS OH
, XDP_PENDING_ORDER_QTAB PEOQ
WHERE OH.ORDER_ID = XDP_SYSCN_UTIL.GET_Q_DATA_NUM( PEOQ.USER_DATA
, 'ORDER_ID' )
AND OH.MSGID = PEOQ.MSGID
AND LK.LOOKUP_TYPE = 'XDP_PROCESS_STATE'
AND LK.LOOKUP_CODE = OH.STATE
Columns
Name |
EXTERNAL_ORDER_ID |
EXTERNAL_ORDER_VERSION |
INTERNAL_ORDER_ID |
STATE |
QUEUED_ON |
DUE_DATE |
PROVISIONING_DATE |
PRIORITY |