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
, OT.NAME ORDER_TYPE_NAME
, OH.ORDER_NUMBER REFERENCE_NUMBER
, OH.FLOW_STATUS_CODE STATUS_CODE
FROM WSH_ITM_REQUEST_CONTROL WRC
, OE_TRANSACTION_TYPES_VL OT
, OE_ORDER_HEADERS_ALL OH
WHERE WRC.ORIGINAL_SYSTEM_REFERENCE = OH.HEADER_ID
AND WRC.APPLICATION_ID = 660
AND OH.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID UNION SELECT WRC.APPLICATION_ID
, NE.DELIVERY_ID
, DEF.ORGANIZATION_NAME
, NE.DELIVERY_ID
, NE.STATUS_CODE STATUS_CODE
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

Columns