View: WSHFV_DELIVERY_LEGS

Product:	WSH - Shipping Execution
Description:	Full BIS Business View for Delivery Legs
Implementation/DBA Data:	APPS.WSHFV_DELIVERY_LEGS

View Text

SELECT WDL.DELIVERY_LEG_ID
, WDL.DELIVERY_ID
, WND.NAME DELIVERY_NAME
, WDL.SEQUENCE_NUMBER
, WDL.LOADING_ORDER_FLAG
, WDL.PICK_UP_STOP_ID
, LOC.UI_LOCATION_CODE PICK_UP_STOP_LOCATION
, WDL.DROP_OFF_STOP_ID
, LOC1.UI_LOCATION_CODE DROP_OFF_STOP_LOCATION
, WDL.GROSS_WEIGHT
, WDL.NET_WEIGHT
, WDL.WEIGHT_UOM_CODE
, WDL.VOLUME
, WDL.VOLUME_UOM_CODE
, WDL.CREATION_DATE
, WDL.CREATED_BY
, WDL.LAST_UPDATE_DATE
, WDL.LAST_UPDATED_BY
, '_LA:WDL.LOAD_TENDER_STATUS:WSH_LOOKUPS:LOAD_TENDER_STATUS:MEANING'
FROM WSH_DELIVERY_LEGS WDL
, WSH_NEW_DELIVERIES WND
, WSH_TRIP_STOPS WTS1
, WSH_TRIP_STOPS WTS2
, WSH_LOCATIONS LOC
, WSH_LOCATIONS LOC1
WHERE WND.DELIVERY_ID=WDL.DELIVERY_ID
AND WDL.PICK_UP_STOP_ID=WTS1.STOP_ID
AND WDL.DROP_OFF_STOP_ID=WTS2.STOP_ID
AND WTS1.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID
AND WTS2.STOP_LOCATION_ID= LOC1.WSH_LOCATION_ID
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')
AND NVL(WTS1.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')
AND NVL(WTS2.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M') WITH READ ONLY

Columns