[Home] [Help]
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
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
|
|
|
|