View: AR_ADDRESSES_V

Product:	AR - Receivables
Description:	This view is used in the customer form address block
Implementation/DBA Data:	APPS.AR_ADDRESSES_V

View Text

SELECT /* PURPOSE: THE VIEW ARH_ADDRESSE_V IS FOR USE AS A BASE TABLE */ /* FOR ORACLE FORMS 4 PROGRAMS */ ADDR.ROWID ROW_ID
, ADDR.CUST_ACCT_SITE_ID ADDRESS_ID
, ADDR.CUST_ACCOUNT_ID CUSTOMER_ID
, ADDR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADDR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ADDR.LAST_UPDATED_BY LAST_UPDATED_BY
, ADDR.CREATION_DATE CREATION_DATE
, ADDR.CREATED_BY CREATED_BY
, ADDR.STATUS STATUS
, ADDR.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, LOC.COUNTRY COUNTRY
, TERR.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, TERR.ADDRESS_STYLE ADDRESS_STYLE
, LOC.ADDRESS1 ADDRESS1
, LOC.ADDRESS2 ADDRESS2
, LOC.ADDRESS3 ADDRESS3
, LOC.ADDRESS4 ADDRESS4
, LOC.CITY CITY
, LOC.COUNTY COUNTY
, LOC.STATE STATE
, LOC.PROVINCE PROVINCE
, LOC.POSTAL_CODE POSTAL_CODE
, ARP_ADDR_PKG.FORMAT_ADDRESS(LOC.ADDRESS_STYLE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.COUNTY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS
, ADDR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADDR.TERRITORY_ID TERRITORY_ID
, LOC.ADDRESS_KEY
, 'N'
, 0
, 'N'
, 0
, 'N'
, 0
, 'N'
, 0
, 'N'
, 0
, 'N'
, 0
, ADDR.KEY_ACCOUNT_FLAG KEY_ACCOUNT_FLAG
, LOC.LANGUAGE LANGUAGE
, LANG.DESCRIPTION LANGUAGE_DESCRIPTION
, ADDR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ADDR.ATTRIBUTE1 ATTRIBUTE1
, ADDR.ATTRIBUTE2 ATTRIBUTE2
, ADDR.ATTRIBUTE3 ATTRIBUTE3
, ADDR.ATTRIBUTE4 ATTRIBUTE4
, ADDR.ATTRIBUTE5 ATTRIBUTE5
, ADDR.ATTRIBUTE6 ATTRIBUTE6
, ADDR.ATTRIBUTE7 ATTRIBUTE7
, ADDR.ATTRIBUTE8 ATTRIBUTE8
, ADDR.ATTRIBUTE9 ATTRIBUTE9
, ADDR.ATTRIBUTE10 ATTRIBUTE10
, ADDR.ATTRIBUTE11 ATTRIBUTE11
, ADDR.ATTRIBUTE12 ATTRIBUTE12
, ADDR.ATTRIBUTE13 ATTRIBUTE13
, ADDR.ATTRIBUTE14 ATTRIBUTE14
, ADDR.ATTRIBUTE15 ATTRIBUTE15
, LOC.ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC
, ADDR.CUSTOMER_CATEGORY_CODE CUSTOMER_CATEGORY
, L_CAT.MEANING CUSTOMER_CATEGORY_MEANING
, ADDR.ECE_TP_LOCATION_CODE EDI_LOCATION
, ADDR.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, ADDR.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, ADDR.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, ADDR.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, ADDR.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, ADDR.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, ADDR.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, ADDR.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, ADDR.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, ADDR.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, ADDR.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, ADDR.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, ADDR.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, ADDR.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, ADDR.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, ADDR.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, ADDR.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, ADDR.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, ADDR.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, ADDR.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, ADDR.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, ADDR.TERRITORY TERRITORY
, ADDR.TRANSLATED_CUSTOMER_NAME TRANSLATED_CUSTOMER_NAME
, LOC.SALES_TAX_GEOCODE SALES_TAX_GEOCODE
, LOC.SALES_TAX_INSIDE_CITY_LIMITS SALES_TAX_INSIDE_CITY_LIMITS /*
, ADDR.CUST_ACCT_SITE_ID */
, PARTY_SITE.PARTY_SITE_ID
, PARTY_SITE.PARTY_ID
, LOC.LOCATION_ID
, PARTY_SITE.PARTY_SITE_NUMBER
, PARTY_SITE.IDENTIFYING_ADDRESS_FLAG
, ADDR.ATTRIBUTE16
, ADDR.ATTRIBUTE17
, ADDR.ATTRIBUTE18
, ADDR.ATTRIBUTE19
, ADDR.ATTRIBUTE20
, PARTY_SITE.LAST_UPDATE_DATE
, PARTY_SITE.OBJECT_VERSION_NUMBER
, LOC.LAST_UPDATE_DATE
, LOC.OBJECT_VERSION_NUMBER
, PARTY_SITE.ADDRESSEE
, LOC.DESCRIPTION
, LOC.SHORT_DESCRIPTION
, LOC.FLOOR
, LOC.HOUSE_NUMBER
, LOC.LOCATION_DIRECTIONS
, LOC.POSTAL_PLUS4_CODE
, LOC.PO_BOX_NUMBER
, LOC.STREET
, LOC.STREET_NUMBER
, LOC.STREET_SUFFIX
, LOC.SUITE
, ADDR.ORG_ID
FROM AR_LOOKUPS L_CAT
, FND_TERRITORIES_VL TERR
, FND_LANGUAGES_VL LANG
, HZ_CUST_ACCT_SITES ADDR
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_LOC_ASSIGNMENTS LOC_ASSIGN
WHERE ADDR.CUSTOMER_CATEGORY_CODE = L_CAT.LOOKUP_CODE(+)
AND L_CAT.LOOKUP_TYPE(+) = 'ADDRESS_CATEGORY'
AND LOC.COUNTRY = TERR.TERRITORY_CODE(+)
AND LOC.LANGUAGE = LANG.LANGUAGE_CODE(+)
AND ADDR.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
AND ADDR.ORG_ID = LOC_ASSIGN.ORG_ID

Columns