VIEW: APPS.WSH_CMSTPW_ORDERS_V

Source

View Text - Preformatted

SELECT distinct 'SR' dcument_type, source_header_number 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 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'

View Text - HTML Formatted

SELECT DISTINCT 'SR' DCUMENT_TYPE
, SOURCE_HEADER_NUMBER
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
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'