Product: | WSH - Shipping Execution |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_DELIVERY_LEGS_OB_GRP_V |
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
, WDL. LAST_UPDATE_LOGIN
, WDL. PROGRAM_APPLICATION_ID
, WDL. PROGRAM_ID
, WDL. PROGRAM_UPDATE_DATE
, WDL. REQUEST_ID
, WDL. LOAD_TENDER_STATUS
, WDL. SHIPPER_TITLE
, WDL. SHIPPER_PHONE
, WDL. POD_FLAG
, WDL. POD_BY
, WDL. POD_DATE
, WDL. EXPECTED_POD_DATE
, WDL. BOOKING_OFFICE
, WDL. SHIPPER_EXPORT_REF
, WDL. CARRIER_EXPORT_REF
, WDL. DOC_NOTIFY_PARTY
, WDL. AETC_NUMBER
, WDL. SHIPPER_SIGNED_BY
, WDL. SHIPPER_DATE
, WDL. CARRIER_SIGNED_BY
, WDL. CARRIER_DATE
, WDL. DOC_ISSUE_OFFICE
, WDL. DOC_ISSUED_BY
, WDL. DOC_DATE_ISSUED
, WDL. SHIPPER_HM_BY
, WDL. SHIPPER_HM_DATE
, WDL. CARRIER_HM_BY
, WDL. CARRIER_HM_DATE
, WDL. BOOKING_NUMBER
, WDL. PORT_OF_LOADING
, WDL. PORT_OF_DISCHARGE
, WDL. SERVICE_CONTRACT
, WDL. BILL_FREIGHT_TO
, WDL. FTE_TRIP_ID
, WDL. REPRICE_REQUIRED
, WDL. ACTUAL_ARRIVAL_DATE
, WDL. ACTUAL_DEPARTURE_DATE
, WDL. ACTUAL_RECEIPT_DATE
, WDL. TRACKING_DRILLDOWN_FLAG
, WDL. STATUS_CODE
, WDL. TRACKING_REMARKS
, WDL. CARRIER_EST_DEPARTURE_DATE
, WDL. CARRIER_EST_ARRIVAL_DATE
, WDL. LOADING_START_DATETIME
, WDL. LOADING_END_DATETIME
, WDL. UNLOADING_START_DATETIME
, WDL. UNLOADING_END_DATETIME
, WDL. DELIVERED_QUANTITY
, WDL. LOADED_QUANTITY
, WDL. RECEIVED_QUANTITY
, WDL. ORIGIN_STOP_ID
, WDL. DESTINATION_STOP_ID
, WDL.PARENT_DELIVERY_LEG_ID
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')