View: OE_SHIP_TO_ADDRESSES_V

Product:	ONT - Order Management
Description:	No longer used
Implementation/DBA Data:	APPS.OE_SHIP_TO_ADDRESSES_V

View Text

SELECT AD.NAME
, AD.COMMENTS
, AD.ORGANIZATION_ID
, AD.BUSINESS_GROUP_ID
, AD.COST_ALLOCATION_KEYFLEX_ID
, AD.LOCATION_ID
, AD.STATUS
, AD.FOB_POINT_CODE
, AD.FREIGHT_TERMS_CODE
, AD.SHIP_PARTIAL_ALLOWED
, AD.SHIPPING_METHOD_CODE
, LC.LOCATION_CODE
, LC.ADDRESS_LINE_1
, LC.ADDRESS_LINE_2
, LC.ADDRESS_LINE_3
, LC.TOWN_OR_CITY
, LC.COUNTRY
, LC.TELEPHONE_NUMBER_1
, LC.TELEPHONE_NUMBER_2
, LC.TELEPHONE_NUMBER_3
FROM OE_SHIP_TO_ORGS_V AD
, HR_LOCATIONS LC
WHERE AD.LOCATION_ID = LC.LOCATION_ID (+)

Columns