VIEW: APPS.ASO_I_ACCT_SITE_ADDR_V

Source

View Text - Preformatted

SELECT acct_site.CUST_ACCOUNT_ID ,acct_site.CUST_ACCT_SITE_ID ,site.site_use_id ,site.site_use_code ,loc.address1 ,loc.address2 ,loc.address3 ,loc.address4 ,loc.city ,loc.state ,loc.postal_code ,loc.province ,loc.county ,country.territory_short_name ,loc.country FROM FND_TERRITORIES_VL COUNTRY, HZ_CUST_SITE_USES_ALL SITE , HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE WHERE SITE.CUST_ACCT_SITE_ID = acct_site.CUST_ACCT_SITE_ID AND PARTY_SITE.PARTY_SITE_ID = ACCT_SITE.PARTY_SITE_ID AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND NVL ( ACCT_SITE.ORG_ID, -99 ) = NVL ( LOC_ASSIGN.ORG_ID, -99 ) AND loc.country = country.territory_code

View Text - HTML Formatted

SELECT ACCT_SITE.CUST_ACCOUNT_ID
, ACCT_SITE.CUST_ACCT_SITE_ID
, SITE.SITE_USE_ID
, SITE.SITE_USE_CODE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.STATE
, LOC.POSTAL_CODE
, LOC.PROVINCE
, LOC.COUNTY
, COUNTRY.TERRITORY_SHORT_NAME
, LOC.COUNTRY
FROM FND_TERRITORIES_VL COUNTRY
, HZ_CUST_SITE_USES_ALL SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOC_ASSIGNMENTS LOC_ASSIGN
, HZ_LOCATIONS LOC
, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
AND PARTY_SITE.PARTY_SITE_ID = ACCT_SITE.PARTY_SITE_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
AND NVL ( ACCT_SITE.ORG_ID
, -99 ) = NVL ( LOC_ASSIGN.ORG_ID
, -99 )
AND LOC.COUNTRY = COUNTRY.TERRITORY_CODE