View: WSH_BOLS_RD_V

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

View Text

SELECT WDI.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.WAYBILL
, WND.ADDITIONAL_SHIPMENT_INFO
, WND.FOB_CODE
, WND.DOCK_CODE
, WT.SHIP_METHOD_CODE
, WT.VEHICLE_NUMBER
, WND.DELIVERY_ID
, WND.NAME
, WTS1.STOP_LOCATION_ID
, WSLOC1.LOCATION_CODE||':'||NVL(WSLOC1.CITY
, SUBSTRB(WSLOC1.ADDRESS1
, 1
, 60))
, WTS2.STOP_LOCATION_ID
, WSLOC2.LOCATION_CODE||':'||NVL(WSLOC2.CITY
, SUBSTRB(WSLOC2.ADDRESS1
, 1
, 60))
, WT.CARRIER_ID
, 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.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
, WSLOC1.LOCATION_CODE||':'||NVL(WSLOC1.CITY
, SUBSTRB(WSLOC1.ADDRESS1
, 1
, 60))
, HOU.NAME
, WSLOC1.LOCATION_CODE||':'||NVL(WSLOC1.CITY
, SUBSTRB(WSLOC1.ADDRESS1
, 1
, 60))
, WSLOC1.ADDRESS1
, WSLOC1.ADDRESS2
, WSLOC1.ADDRESS3
, WSLOC1.CITY
, NVL(NVL(WSLOC1.PROVINCE
, WSLOC1.STATE)
, WSLOC1.COUNTY)
, WSLOC1.POSTAL_CODE
, WSLOC1.COUNTRY
, NULL VENDOR_NAME
, NULL DESCRIPTION
, NULL ADDRESS_LINE_1
, NULL ADDRESS_LINE_2
, NULL ADDRESS_LINE_3
, NULL TOWN_OR_CITY
, NULL
, NULL POSTAL_CODE
, NULL COUNTRY
, SUBSTRB ( PARTY.PARTY_NAME
, 1
, 50 ) /* CUSTOMER_NAME */
, WSLOC2.LOCATION_CODE||':'||NVL(WSLOC2.CITY
, SUBSTRB(WSLOC2.ADDRESS1
, 1
, 60))
, WSLOC2.ADDRESS1
, WSLOC2.ADDRESS2
, WSLOC2.ADDRESS3
, WSLOC2.CITY
, NVL(NVL(WSLOC2.PROVINCE
, WSLOC2.STATE)
, WSLOC2.COUNTY)
, WSLOC2.POSTAL_CODE
, WSLOC2.COUNTRY
, WND.ORGANIZATION_ID
FROM WSH_DOCUMENT_INSTANCES WDI
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
, WSH_TRIP_STOPS WTS1
, WSH_TRIP_STOPS WTS2
, WSH_TRIPS WT
, HR_ORGANIZATION_UNITS HOU
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, WSH_LOCATIONS WSLOC1
, WSH_LOCATIONS WSLOC2
WHERE WDI.ENTITY_ID = WDL.DELIVERY_LEG_ID
AND WDI.ENTITY_NAME = 'WSH_DELIVERY_LEGS'
AND WDI.DOCUMENT_TYPE = 'BOL'
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 WTS1.TRIP_ID = WT.TRIP_ID
AND WTS1.STOP_LOCATION_ID = WSLOC1.WSH_LOCATION_ID(+)
AND WTS2.STOP_LOCATION_ID = WSLOC2.WSH_LOCATION_ID(+)
AND WND.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND WND.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)

Columns