View: ASO_I_ACCT_SITE_ADDR_V

Product:	ASO - Order Capture
Description:	view gives the address information of customers
Implementation/DBA Data:	APPS.ASO_I_ACCT_SITE_ADDR_V

View Text

SELECT ADDR.CUSTOMER_ID
, ADDR.ADDRESS_ID
, SITE.SITE_USE_ID
, SITE.SITE_USE_CODE
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, ADDR.CITY
, ADDR.STATE
, ADDR.POSTAL_CODE
, ADDR.PROVINCE
, ADDR.COUNTY
, COUNTRY.TERRITORY_SHORT_NAME
, ADDR.COUNTRY
FROM RA_ADDRESSES_MORG ADDR
, FND_TERRITORIES_VL COUNTRY
, RA_SITE_USES_MORG SITE
WHERE ADDR.ADDRESS_ID = SITE.ADDRESS_ID
AND ADDR.COUNTRY = COUNTRY.TERRITORY_CODE

Columns