View: WSH_INV_DELIVERY_DETAILS_V

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

View Text

SELECT WDD.SOURCE_HEADER_ID OE_HEADER_ID
, WTS.STOP_ID TRIP_STOP_ID
, WDD.SOURCE_LINE_ID OE_LINE_ID
, WDA.DELIVERY_ID SHIPPING_DELIVERY_ID
, WDD.CUSTOMER_ID CUSTOMER_ID
, CUST_ACCT.ACCOUNT_NUMBER /* CUSTOMER NUMBER */
, WLT.SOURCE_LOCATION_ID SHIP_TO_LOCATION
, WLF.SOURCE_LOCATION_ID SHIP_FROM_LOCATION
, WDD.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, OL.SHIPMENT_NUMBER SHIPMENT_NUMBER
, WDD.SHIP_METHOD_CODE FREIGHT_CODE
, WDD.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, WDD.RELEASED_STATUS
, WDD.DELIVERY_DETAIL_ID
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, HZ_CUST_ACCOUNTS CUST_ACCT
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WLG
, WSH_TRIP_STOPS WTS
, OE_ORDER_LINES_ALL OL
, WSH_LOCATIONS WLT
, WSH_LOCATIONS WLF
WHERE WDD.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID
AND WND.DELIVERY_ID(+) = WDA.DELIVERY_ID
AND WLG.DELIVERY_ID(+) = WND.DELIVERY_ID
AND WTS.STOP_ID(+) = WLG.PICK_UP_STOP_ID
AND NVL(WLG.SEQUENCE_NUMBER
, -1) = ( SELECT NVL(MIN(G.SEQUENCE_NUMBER)
, -1) FROM WSH_DELIVERY_LEGS G WHERE G.DELIVERY_ID(+) = WND.DELIVERY_ID )
AND OL.LINE_ID = WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID AND WDD.SHIP_FROM_LOCATION_ID = WLF.WSH_LOCATION_ID (+) AND WDD.SHIP_TO_LOCATION_ID = WLT.WSH_LOCATION_ID (+) AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO')
AND NVL(WND.DELIVERY_TYPE
, 'STANDARD') = 'STANDARD'

Columns