VIEW: APPS.IBE_SHIP_DLVY_V

Source

View Text - Preformatted

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, dl.FOB_CODE, arl.MEANING 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, AR_LOOKUPS arl 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') AND dl.FOB_CODE = arl.lookup_code(+) AND arl.LOOKUP_TYPE(+) = 'FOB'

View Text - HTML Formatted

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
, DL.FOB_CODE
, ARL.MEANING
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
, AR_LOOKUPS ARL
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')
AND DL.FOB_CODE = ARL.LOOKUP_CODE(+)
AND ARL.LOOKUP_TYPE(+) = 'FOB'