[Home] [Help]
View: 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
Name |
SHIPMENT_ID |
QUOTE_HEADER_ID |
QUOTE_LINE_ID |
QUANTITY |
SHIP_TO_ADDRESS1 |
SHIP_TO_CITY |
SHIP_TO_STATE |
SHIP_METHOD_CODE |
SHIP_QUOTE_PRICE |
CURRENCY_CODE |
SHPPPING_METHOD |