View: WSH_BOLS_DB_V

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

View Text

SELECT WDL.ROWID
, WDI.SEQUENCE_NUMBER
, WDI.DOCUMENT_INSTANCE_ID
, WDL.BOOKING_NUMBER
, WDL.SERVICE_CONTRACT
, WDL.CARRIER_EXPORT_REF
, WDL.SHIPPER_EXPORT_REF
, WDL.DOC_NOTIFY_PARTY
, WND.PROBLEM_CONTACT_REFERENCE
, WDL.PORT_OF_LOADING
, WDL.PORT_OF_DISCHARGE
, WDL.AETC_NUMBER
, WDL.SHIPPER_SIGNED_BY
, WDL.SHIPPER_DATE
, WDL.CARRIER_SIGNED_BY
, WDL.CARRIER_DATE
, WDL.POD_BY
, WDL.POD_DATE
, WDL.BOOKING_OFFICE
, WDL.DOC_ISSUE_OFFICE
, WDL.DOC_ISSUED_BY
, WDL.DOC_DATE_ISSUED
, WND.DESCRIPTION
, WDL.SHIPPER_HM_BY
, WDL.SHIPPER_HM_DATE
, WDL.CARRIER_HM_BY
, WDL.CARRIER_HM_DATE
, WND.DELIVERY_ID
, WND.NAME
, WTS1.STOP_LOCATION_ID
, WTS2.STOP_LOCATION_ID
, WT.CARRIER_ID
, POV.VENDOR_NAME
, WT.SHIP_METHOD_CODE
, WT.TRIP_ID
, WT.NAME
, WDI.DOCUMENT_TYPE
, WDI.STATUS
, WDI.FINAL_PRINT_DATE
, WDI.ENTITY_NAME
, WDI.ENTITY_ID
, WDI.DOC_SEQUENCE_CATEGORY_ID
, WDL.POD_FLAG
, WND.REASON_OF_TRANSPORT
, WND.COD_AMOUNT
, WND.COD_CURRENCY_CODE
, WND.COD_REMIT_TO
, WND.COD_CHARGE_PAID_BY
, WDL.BILL_FREIGHT_TO
, WND.CARRIED_BY
, WDL.CREATED_BY
, WDL.CREATION_DATE
, WDL.LAST_UPDATED_BY
, WDL.LAST_UPDATE_DATE
, WDL.LAST_UPDATE_LOGIN
, WDL.PROGRAM_APPLICATION_ID
, WDL.PROGRAM_ID
, WDL.PROGRAM_UPDATE_DATE
, WDL.REQUEST_ID
, WDI.ATTRIBUTE_CATEGORY
, WDI.ATTRIBUTE1
, WDI.ATTRIBUTE2
, WDI.ATTRIBUTE3
, WDI.ATTRIBUTE4
, WDI.ATTRIBUTE5
, WDI.ATTRIBUTE6
, WDI.ATTRIBUTE7
, WDI.ATTRIBUTE8
, WDI.ATTRIBUTE9
, WDI.ATTRIBUTE10
, WDI.ATTRIBUTE11
, WDI.ATTRIBUTE12
, WDI.ATTRIBUTE13
, WDI.ATTRIBUTE14
, WDI.ATTRIBUTE15
, WDL.DELIVERY_LEG_ID
, WDL.SEQUENCE_NUMBER
, WDL.LOADING_ORDER_FLAG
, WDL.GROSS_WEIGHT
, WDL.NET_WEIGHT
, WDL.WEIGHT_UOM_CODE
, WDL.VOLUME
, WDL.VOLUME_UOM_CODE
, WDL.LOAD_TENDER_STATUS
, WL.MEANING
, WDL.SHIPPER_TITLE
, WDL.SHIPPER_PHONE
, WDL.PICK_UP_STOP_ID
, WDL.DROP_OFF_STOP_ID
, WDL.EXPECTED_POD_DATE
, 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
FROM WSH_DOCUMENT_INSTANCES WDI
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
, WSH_TRIP_STOPS WTS1
, WSH_TRIP_STOPS WTS2
, PO_VENDORS POV
, WSH_TRIPS WT
, WSH_LOOKUPS WL
WHERE WDI.ENTITY_ID(+) = WDL.DELIVERY_LEG_ID
AND WDI.ENTITY_NAME(+) = 'WSH_DELIVERY_LEGS'
AND WDI.STATUS(+) <> 'CANCELLED'
AND 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 WT.CARRIER_ID = POV.VENDOR_ID(+)
AND WTS1.TRIP_ID = WT.TRIP_ID
AND WDL.LOAD_TENDER_STATUS = WL.LOOKUP_CODE(+)
AND WL.LOOKUP_TYPE(+) = 'LOAD_TENDER_STATUS'
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')

Columns