VIEW: APPS.WSH_CMSTPW_ORDERS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')