View: WSH_POD_DETAIL_V

View Text

SELECT WDI.SEQUENCE_NUMBER BILL_OF_LADING_NUMBER
, WDI.DOCUMENT_INSTANCE_ID DOCUMENT_INSTANCE_ID
, WDI.BOOKING_NUMBER BOOKING_NUMBER
, WDI.SERVICE_CONTRACT SERVICE_CONTRACT
, WDI.CARRIER_EXPORT_REF CARRIER_EXPORT_REF
, WDI.SHIPPER_EXPORT_REF SHIPPER_EXPORT_REF
, WDI.BOL_NOTIFY_PARTY NOTIFY_PARTY
, WDI.PROBLEM_CONTACT_REFERENCE PROBLEM_CONTACT_REF
, WDI.PORT_OF_LOADING PORT_OF_LOADING
, WDI.PORT_OF_DISCHARGE PORT_OF_DISCHARGE
, WDI.SUPPLIER_CODE SUPPLIER_CODE
, WDI.AETC_NUMBER AETC_NUMBER
, WDI.SHIPPER_SIGNED_BY SHIPPER_SIGNED_BY
, WDI.SHIPPER_DATE SHIPPER_SIGNED_DATE
, WDI.CARRIER_SIGNED_BY CARRIER_SIGNED_BY
, WDI.CARRIER_DATE CARRIER_SIGNED_DATE
, WDI.POD_BY POD_SIGNED_BY
, TO_CHAR(WDI.POD_DATE
, 'DD-MON-YYYY') POD_SIGNED_DATE
, TO_CHAR(WDI.POD_DATE
, 'HH12:MI') POD_SIGNED_TIME
, TO_CHAR(WDI.POD_DATE
, 'AM') POD_SIGNED_AM_PM
, WDI.BOOKING_OFFICE BOOKING_OFFICE
, WDI.BOL_ISSUE_OFFICE ISSUING_OFFICE
, WDI.BOL_ISSUED_BY ISSUING_PERSON
, WDI.BOL_DATE_ISSUED DATE_ISSUED
, WDI.DESCRIPTION POD_COMMENTS
, WDI.SHIPPER_HM_BY SHIPPER_SIGNED_HM_BY
, WDI.SHIPPER_HM_DATE SHIPPER_SIGNED_HM_DATE
, WDI.CARRIER_HM_BY CARRIER_SIGNED_HM_BY
, WDI.CARRIER_HM_DATE CARRIER_SIGNED_HM_DATE
, WND.DELIVERY_ID DELIVERY_ID
, WND.WAYBILL CARRIER_TRACKING_NUMBER
, WND.ADDITIONAL_SHIPMENT_INFO ADDITIONAL_SHIPMENT_INFO
, WND.FOB_CODE INCOTERMS
, WND.DOCK_CODE DOCK_CODE
, WT.SHIP_METHOD_CODE EXPORT_CARRIER
, WT.VEHICLE_NUMBER TRAILER_NUMBER
, HR1.TOWN_OR_CITY POOLED_LOCATION
, HOU.NAME SHIPPER_NAME
, HR2.ADDRESS_LINE_1 SHIPPER_ADDRESS_L1
, HR2.ADDRESS_LINE_2 SHIPPER_ADDRESS_L2
, HR2.ADDRESS_LINE_3 SHIPPER_ADDRESS_L3
, HR2.TOWN_OR_CITY SHIPPER_CITY
, HR2.REGION_3 SHIPPER_STATE
, HR2.POSTAL_CODE SHIPPER_POSTAL_CODE
, HR2.COUNTRY SHIPPER_COUNTRY
, HR2.ADDRESS_LINE_1||'
'||HR2.ADDRESS_LINE_2||'
'||HR2.ADDRESS_LINE_3||'
'||HR2.TOWN_OR_CITY||'
'||HR2.REGION_3||'
'||HR2.POSTAL_CODE||'
'||HR2.COUNTRY SHIPPER_ADDRESS
, OFV.FREIGHT_CODE CARRIER_NAME
, HR3.ADDRESS_LINE_1 CARRIER_ADDRESS_L1
, HR3.ADDRESS_LINE_2 CARRIER_ADDRESS_L2
, HR3.ADDRESS_LINE_3 CARRIER_ADDRESS_L3
, HR3.TOWN_OR_CITY CARRIER_CITY
, HR3.REGION_3 CARRIER_STATE
, HR3.POSTAL_CODE CARRIER_POSTAL_CODE
, HR3.COUNTRY CARRIER_COUNTRY
, HR3.ADDRESS_LINE_1||'
'||HR3.ADDRESS_LINE_2||'
'||HR3.ADDRESS_LINE_3||'
'||HR3.TOWN_OR_CITY||'
'||HR3.REGION_3||'
'||HR3.POSTAL_CODE||'
'||HR3.COUNTRY CARRIER_ADDRESS
, RC.CUSTOMER_NAME CUSTOMER_NAME
, HR4.ADDRESS_LINE_1 CUSTOMER_ADDRESS_L1
, HR4.ADDRESS_LINE_2 CUSTOMER_ADDRESS_L2
, HR4.ADDRESS_LINE_3 CUSTOMER_ADDRESS_L3
, HR4.TOWN_OR_CITY CUSTOMER_CITY
, HR4.REGION_3 CUSTOMER_STATE
, HR4.POSTAL_CODE CUSTOMER_POSTAL_CODE
, HR4.COUNTRY CUSTOMER_COUNTRY
, HR4.ADDRESS_LINE_1||'
'||HR4.ADDRESS_LINE_2||'
'||HR4.ADDRESS_LINE_3||'
'||HR4.TOWN_OR_CITY||'
'||HR4.REGION_3||'
'||HR4.POSTAL_CODE||'
'||HR4.COUNTRY CUSTOMER_ADDRESS
FROM WSH_DOCUMENT_INSTANCES WDI
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
, WSH_TRIP_STOPS WTS
, WSH_TRIPS WT
, HR_LOCATIONS HR1
, HR_LOCATIONS HR2
, HR_LOCATIONS HR3
, HR_LOCATIONS HR4
, PO_LOCATION_ASSOCIATIONS PLA
, ORG_FREIGHT_VL OFV
, RA_CUSTOMERS RC
, HR_ORGANIZATION_UNITS HOU
WHERE WDI.ENTITY_ID = WDL.DELIVERY_LEG_ID
AND WDI.ENTITY_NAME = 'WSH_DELIVERY_LEGS'
AND WDL.DELIVERY_ID = WND.DELIVERY_ID
AND WDL.PICK_UP_STOP_ID = WTS.STOP_ID
AND WTS.TRIP_ID = WT.TRIP_ID
AND WND.POOLED_SHIP_TO_LOCATION_ID = HR1.LOCATION_ID(+)
AND WND.INITIAL_PICKUP_LOCATION_ID = PLA.LOCATION_ID(+)
AND PLA.ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND WND.INITIAL_PICKUP_LOCATION_ID = HR2.LOCATION_ID(+)
AND WT.SHIP_METHOD_CODE = OFV.FREIGHT_CODE_TL(+)
AND OFV.ORGANIZATION_ID = HR3.INVENTORY_ORGANIZATION_ID(+)
AND WND.CUSTOMER_ID = RC.CUSTOMER_ID
AND WND.ULTIMATE_DROPOFF_LOCATION_ID = HR4.LOCATION_ID(+)

Columns