View: WSHBV_DOCUMENT_BOL

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

View Text

SELECT WDI.DOCUMENT_INSTANCE_ID
, WDI.ENTITY_NAME
, WDI.ENTITY_ID
, '_LA:DOCUMENT_TYPE:WSH_LOOKUPS:DOCUMENT_TYPE:MEANING'
, WDI.SEQUENCE_NUMBER
, WDI.STATUS
, WDI.FINAL_PRINT_DATE
, WDI.DOC_SEQUENCE_CATEGORY_ID
, WDI.CREATION_DATE
, WDI.CREATED_BY
, WDI.LAST_UPDATE_DATE
, WDI.LAST_UPDATED_BY
, WDI.LAST_UPDATE_LOGIN
, WDL.POD_FLAG
, WDL.POD_BY
, WDL.POD_DATE
, WND.REASON_OF_TRANSPORT
, WND.DESCRIPTION
, WND.COD_AMOUNT
, WND.COD_CURRENCY_CODE
, WND.COD_REMIT_TO
, WND.COD_CHARGE_PAID_BY
, WND.PROBLEM_CONTACT_REFERENCE
, WDL.BILL_FREIGHT_TO
, WND.CARRIED_BY
, WDL.PORT_OF_LOADING
, WDL.PORT_OF_DISCHARGE
, WDL.BOOKING_OFFICE
, WDL.BOOKING_NUMBER
, WDL.SERVICE_CONTRACT
, 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.EXPECTED_POD_DATE
FROM WSH_DOCUMENT_INSTANCES WDI
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
WHERE WDL.DELIVERY_LEG_ID = WDI.ENTITY_ID
AND WDL.DELIVERY_ID = WND.DELIVERY_ID
AND WDI.DOCUMENT_TYPE = 'BOL'
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY

Columns