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.

VIEW: APPS.XDP_READY_WORKITEM_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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