View: WSH_DELIVERY_DETAILS_OE_V

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

View Text

SELECT WDA.DELIVERY_ID
, WND.NAME DELIVERY_NAME
, WDD.SOURCE_HEADER_ID SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID SOURCE_LINE_ID
, WDD.DELIVERY_DETAIL_ID
, WDD.SOURCE_CODE
, WDD.ORGANIZATION_ID
, WDD.REQUESTED_QUANTITY
, WDD.OE_INTERFACED_FLAG
, WDD.INV_INTERFACED_FLAG
, WDD.MOVE_ORDER_LINE_ID
, WDD.SHIP_METHOD_CODE LINE_SHIP_METHOD
, WND.SHIP_METHOD_CODE DELIVERY_SHIP_METHOD
, WDD.TRACKING_NUMBER
, WND.WAYBILL
, WDD.RELEASED_STATUS
, LK.MEANING ORIGINAL_LINE_STATUS
, WDD.REQUESTED_QUANTITY2
, WND.DELIVERED_DATE
, WDD.REPLENISHMENT_STATUS
FROM OE_ORDER_LINES_ALL OE
, WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, WSH_NEW_DELIVERIES WND
, WSH_LOOKUPS LK
WHERE OE.HEADER_ID = WDD.SOURCE_HEADER_ID
AND OE.LINE_ID = WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDD.SOURCE_CODE = 'OE'
AND WND.DELIVERY_ID = WDA.DELIVERY_ID
AND LK.LOOKUP_TYPE = 'PICK_STATUS'
AND LK.LOOKUP_CODE = WDD.RELEASED_STATUS
AND WND.DELIVERY_TYPE = 'STANDARD'

Columns