[Home] [Help]
View: XDP_READY_WORKITEM_V
Product: | XDP - Provisioning |
Description: | This View shows all the Orders in the Ready Work Item Queue |
Implementation/DBA Data: |
APPS.XDP_READY_WORKITEM_V
|
View Text
SELECT FW.WORKITEM_INSTANCE_ID WORKITEM
, OH.EXTERNAL_ORDER_NUMBER EXTERNAL_ORDER_ID
, OH.EXTERNAL_ORDER_VERSION EXTERNAL_ORDER_VERSION
, FW.ORDER_ID INTERNAL_ORDER_ID
, WQ.ENQ_TIME QUEUED_ON
, FW.DUE_DATE DUE_DATE
, FW.PROVISIONING_DATE PROVISIONING_DATE
, WQ.PRIORITY PRIORITY
, XWVL.DISPLAY_NAME WORKITEM_DISPLAY
FROM XDP_WORKITEMS_VL XWVL
, XDP_ORDER_HEADERS OH
, XDP_FULFILL_WORKLIST FW
, XDP_WORKITEM_QTAB WQ
WHERE FW.WORKITEM_INSTANCE_ID =XDP_SYSCN_UTIL.GET_Q_DATA_NUM( WQ.USER_DATA
, 'WORKITEM_INSTANCE_ID' )
AND WQ.MSGID = FW.MSGID
AND OH.ORDER_ID = FW.ORDER_ID
AND XWVL.WORKITEM_ID = FW.WORKITEM_ID
Columns
Name |
WORKITEM |
EXTERNAL_ORDER_ID |
EXTERNAL_ORDER_VERSION |
INTERNAL_ORDER_ID |
QUEUED_ON |
DUE_DATE |
PROVISIONING_DATE |
PRIORITY |
WORKITEM_DISPLAY |