[Home] [Help]
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
Name |
CUST_ACCT_ID |
ADDRESS_ID |
SITE_USE_ID |
SITE_USE_CODE |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
ADDRESS4 |
CITY |
STATE |
POSTAL_CODE |
PROVINCE |
COUNTY |
COUNTRY |
COUNTRY_CODE |