eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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