View: IBE_SHIP_DLVY_V

Product:	IBE - iStore
Description:	Stores information about Delivery header
Implementation/DBA Data:	APPS.IBE_SHIP_DLVY_V

View Text

SELECT DL.DELIVERY_ID
, DL.NAME
, DL.ORGANIZATION_ID
, DL.STATUS_CODE
, WL.MEANING STATUS_MEANING
, DL.FREIGHT_TERMS_CODE
, OL.MEANING FREIGHT_TERMS_MEANING
, DL.WAYBILL
, DL.GROSS_WEIGHT
, DL.NET_WEIGHT
, DL.WEIGHT_UOM_CODE
, MSIT.UNIT_OF_MEASURE_TL UOM_WEIGHT_DESC
, DL.VOLUME
, DL.VOLUME_UOM_CODE
, DL.SHIP_METHOD_CODE
, OES.MEANING SHIP_METHOD_MEANING
, DL.CARRIER_ID
, DL.INITIAL_PICKUP_DATE
, DL.INITIAL_PICKUP_LOCATION_ID
, DL.ULTIMATE_DROPOFF_DATE
, DL.ULTIMATE_DROPOFF_LOCATION_ID
, SHIPADDR.ADDRESS1
, SHIPADDR.ADDRESS2
, SHIPADDR.ADDRESS3
, SHIPADDR.CITY
, SHIPADDR.COUNTRY
, SHIPADDR.POSTAL_CODE
, SHIPADDR.ADDRESS_LINES_PHONETIC
, SHIPADDR.STATE
, SHIPADDR.COUNTY
, SHIPADDR.PROVINCE
FROM WSH_NEW_DELIVERIES DL
, WSH_LOOKUPS WL
, OE_LOOKUPS OL
, OE_SHIP_METHODS_V OES
, HZ_LOCATIONS SHIPADDR
, MTL_UNITS_OF_MEASURE_TL MSIT
WHERE DL.STATUS_CODE = WL.LOOKUP_CODE
AND WL.LOOKUP_TYPE = 'DELIVERY_STATUS'
AND DL.FREIGHT_TERMS_CODE = OL.LOOKUP_CODE(+)
AND OL.LOOKUP_TYPE(+) = 'FREIGHT_TERMS'
AND DL.SHIP_METHOD_CODE = OES.LOOKUP_CODE(+)
AND OES.LOOKUP_TYPE(+) = 'SHIP_METHOD'
AND DL.ULTIMATE_DROPOFF_LOCATION_ID = SHIPADDR.LOCATION_ID
AND DL.WEIGHT_UOM_CODE = MSIT.UOM_CODE
AND MSIT.LANGUAGE = USERENV('LANG')

Columns