Product: | ONT - Order Management |
---|---|
Description: | No longer used |
Implementation/DBA Data: | APPS.OE_SOLD_TO_CUSTOMERS_V |
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 (+)