FND Design Data [Home] [Help]

View: WSHBV_DELIVERY_LEGS

Product: WSH - Shipping Execution
Description:
Implementation/DBA Data: ViewAPPS.WSHBV_DELIVERY_LEGS
View Text

SELECT WDL.DELIVERY_LEG_ID
, WDL.DELIVERY_ID
, WDL.SEQUENCE_NUMBER
, WDL.LOADING_ORDER_FLAG
, WDL.PICK_UP_STOP_ID
, WDL.DROP_OFF_STOP_ID
, 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
WHERE WDL.DELIVERY_ID = WND.DELIVERY_ID
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY

Columns

Name
DELIVERY_LEG_ID
DELIVERY_ID
SEQUENCE_NUMBER
LOADING_ORDER_FLAG
PICK_UP_STOP_ID
DROP_OFF_STOP_ID
GROSS_WEIGHT
NET_WEIGHT
WEIGHT_UOM_CODE
VOLUME
VOLUME_UOM_CODE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
"_LA:LOAD_TENDER_STATUS"