VIEW: APPS.WSH_BOLS_DB_V

Source

View Text - Preformatted

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, wdl.parent_delivery_leg_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')

View Text - HTML Formatted

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
, WDL.PARENT_DELIVERY_LEG_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')