View: ASO_SHIPMENTS_BALI_V

Product:	ASO - Order Capture
Description:
Implementation/DBA Data:	APPS.ASO_SHIPMENTS_BALI_V

View Text

SELECT SHIP.SHIPMENT_ID
, SHIP.QUOTE_HEADER_ID
, SHIP.QUOTE_LINE_ID
, SHIP.QUANTITY
, HL.ADDRESS1 SHIP_TO_ADDRESS1
, HL.CITY SHIP_TO_CITY
, HL.STATE SHIP_TO_STATE
, SHIP.SHIP_METHOD_CODE
, SHIP.SHIP_QUOTE_PRICE
, QTE.CURRENCY_CODE
, SHIPM.SHIPPING_METHOD
FROM ASO_SHIPMENTS SHIP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, ASO_QUOTE_HEADERS_ALL QTE
, ASO_I_SHIPPING_METHODS_V SHIPM
WHERE SHIP.SHIP_TO_PARTY_SITE_ID = HPS.PARTY_SITE_ID(+)
AND HPS.LOCATION_ID = HL.LOCATION_ID (+)
AND QTE.QUOTE_HEADER_ID = SHIP.QUOTE_HEADER_ID
AND SHIPM.SHIPPING_METHOD_CODE(+) = SHIP.SHIP_METHOD_CODE

Columns