View: WSH_CMSTPW_ORDERS_V

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

View Text

SELECT DISTINCT 'SR' DOCUMENT_TYPE
, SOURCE_HEADER_NUMBER
, 'OTH' SOURCE_TYPE
, CLIENT_ID
FROM WSH_DELIVERY_DETAILS
WHERE CONTAINER_FLAG = 'N'
AND RELEASED_STATUS IN ('X'
, 'Y'
, 'B'
, 'R')
AND SOURCE_CODE <> 'WSH'
AND LINE_DIRECTION IN ('O'
, 'IO') UNION ALL SELECT DISTINCT 'SA' DOCUMENT_TYPE
, SOURCE_HEADER_NUMBER
, 'OTH' SOURCE_TYPE
, WDD.CLIENT_ID
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES WND
, WSH_TRANSACTIONS_HISTORY WTH
WHERE WDD.CONTAINER_FLAG = 'N'
AND WDD.SOURCE_CODE = 'WSH'
AND WDD.LINE_DIRECTION IN ('O'
, 'IO')
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID = WND.DELIVERY_ID
AND WND.NAME = WTH. ENTITY_NUMBER
AND WND.STATUS_CODE IN ('CO'
, 'IT'
, 'CL')
AND WTH.ENTITY_TYPE = 'DLVY'
AND WTH.ACTION_TYPE = 'A'
AND WTH.DOCUMENT_DIRECTION = 'I'
AND WTH. DOCUMENT_TYPE = 'SR' UNION ALL SELECT DISTINCT 'SA' DOCUMENT_TYPE
, SOURCE_HEADER_NUMBER
, 'STND' SOURCE_TYPE
, WDD.CLIENT_ID
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES WND
WHERE WDD.CONTAINER_FLAG = 'N'
AND WDD.SOURCE_CODE = 'OE'
AND WDD.LINE_DIRECTION IN ('O'
, 'IO')
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID = WND.DELIVERY_ID
AND WND.STATUS_CODE IN ('IT'
, 'CL')

Columns