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_ORDER_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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