View: WSHBV_DELIVERIES

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

View Text

SELECT WND.DELIVERY_ID
, WND.NAME
, WND.ORGANIZATION_ID
, WND. CREATION_DATE
, WND. CREATED_BY
, WND. LAST_UPDATE_DATE
, WND. LAST_UPDATED_BY
, WND. LAST_UPDATE_LOGIN
, '_LA:STATUS_CODE:WSH_LOOKUPS:DELIVERY_STATUS:MEANING'
, WND.CONFIRM_DATE
, WND. LOADING_SEQUENCE
, WND.CUSTOMER_ID
, LOC.SOURCE_LOCATION_ID
, LOC1.SOURCE_LOCATION_ID
, LOC2.SOURCE_LOCATION_ID
, WAYBILL
, GROSS_WEIGHT
, WEIGHT_UOM_CODE
, VOLUME
, VOLUME_UOM_CODE
, ULTIMATE_DROPOFF_DATE
, ASN_DATE_SENT
, ASN_SEQ_NUMBER
, LOADING_ORDER_FLAG
, FREIGHT_TERMS_CODE
, CURRENCY_CODE
, '_LA:PLANNED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, INITIAL_PICKUP_DATE
, LOC3.SOURCE_LOCATION_ID
, LOC4.SOURCE_LOCATION_ID
, '_LA:ACCEPTANCE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, ACCEPTED_BY
, ACCEPTED_DATE
, ACKNOWLEDGED_BY
, CONFIRMED_BY
, REASON_OF_TRANSPORT
, DESCRIPTION
, NET_WEIGHT
, PORT_OF_DISCHARGE
, PORT_OF_LOADING
, ADDITIONAL_SHIPMENT_INFO
, BOOKING_NUMBER
, COD_AMOUNT
, COD_CURRENCY_CODE
, SERVICE_CONTRACT
, COD_REMIT_TO
, COD_CHARGE_PAID_BY
, PROBLEM_CONTACT_REFERENCE
, BILL_FREIGHT_TO
, CARRIED_BY
, DOCK_CODE
, DELIVERY_TYPE
, CARRIER_ID
, NUMBER_OF_LPN
, '_LA:SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, '_LA:FOB_CODE:FND_LOOKUP_VALUES_VL:FOB:MEANING'
FROM WSH_NEW_DELIVERIES WND
, WSH_LOCATIONS LOC
, WSH_LOCATIONS LOC1
, WSH_LOCATIONS LOC2
, WSH_LOCATIONS LOC3
, WSH_LOCATIONS LOC4
WHERE WND.ULTIMATE_DROPOFF_LOCATION_ID = LOC.WSH_LOCATION_ID
AND WND.INTMED_SHIP_TO_LOCATION_ID = LOC1.WSH_LOCATION_ID(+)
AND WND.POOLED_SHIP_TO_LOCATION_ID = LOC2.WSH_LOCATION_ID(+)
AND WND.INITIAL_PICKUP_LOCATION_ID = LOC3.WSH_LOCATION_ID
AND WND.FOB_LOCATION_ID = LOC4.WSH_LOCATION_ID(+)
AND '_SEC:WND.ORGANIZATION_ID' IS NOT NULL
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY

Columns