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: WSH_ITM_REFERENCE_NUMBERS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_ITM_REFERENCE_NUMBERS_V

View Text

SELECT DISTINCT APPLICATION_ID
, ORIGINAL_SYSTEM_REFERENCE REFERENCE_ID
, WRC.ORDER_TYPE
, OH.ORDER_NUMBER REFERENCE_NUMBER
, OH.FLOW_STATUS_CODE STATUS_CODE
, WRC.PROCESS_FLAG
FROM WSH_ITM_REQUEST_CONTROL WRC
, OE_ORDER_HEADERS_ALL OH
WHERE WRC.ORIGINAL_SYSTEM_REFERENCE = OH.HEADER_ID
AND WRC.APPLICATION_ID = 660 UNION SELECT WRC.APPLICATION_ID
, NE.DELIVERY_ID
, DEF.ORGANIZATION_NAME
, NE.DELIVERY_ID
, NE.STATUS_CODE STATUS_CODE
, WRC.PROCESS_FLAG
FROM WSH_ITM_REQUEST_CONTROL WRC
, WSH_NEW_DELIVERIES NE
, ORG_ORGANIZATION_DEFINITIONS DEF
WHERE WRC.ORIGINAL_SYSTEM_REFERENCE=NE.DELIVERY_ID
AND DEF.ORGANIZATION_ID=NE.ORGANIZATION_ID
AND WRC.APPLICATION_ID=665
AND NE.DELIVERY_TYPE='STANDARD'

Columns

Name
APPLICATION_ID
REFERENCE_ID
ORDER_TYPE_NAME
REFERENCE_NUMBER
STATUS_CODE
PROCESS_FLAG