View: OE_SOLD_TO_CUSTOMERS_V

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

View Text

SELECT ST.NAME
, ST.COMMENTS
, ST.ORGANIZATION_ID
, ST.BUSINESS_GROUP_ID
, ST.COST_ALLOCATION_KEYFLEX_ID
, ST.LOCATION_ID
, ST.CUSTOMER_NUMBER
, ST.STATUS
, ST.FOB_POINT_CODE
, ST.FREIGHT_TERMS_CODE
, ST.SHIP_PARTIAL_ALLOWED
, 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_SOLD_TO_ORGS_V ST
, HR_LOCATIONS LC
WHERE ST.LOCATION_ID = LC.LOCATION_ID (+)

Columns