VIEW: APPS.AR_REMIT_TO_ADDRESSES_V

Source

View Text - Preformatted

SELECT 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.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 , ARH_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.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.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.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID*/ , PARTY_SITE.PARTY_SITE_ID PARTY_SITE_ID , PARTY_SITE.PARTY_ID , LOC.LOCATION_ID , PARTY_SITE.PARTY_SITE_NUMBER SITE_NUMBER , PARTY_SITE.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG , ADDR.ATTRIBUTE16 ATTRIBUTE16 , ADDR.ATTRIBUTE17 ATTRIBUTE17 , ADDR.ATTRIBUTE18 ATTRIBUTE18 , ADDR.ATTRIBUTE19 ATTRIBUTE19 , ADDR.ATTRIBUTE20 ATTRIBUTE20 , PARTY_SITE.LAST_UPDATE_DATE PARTY_SITE_LAST_UPDATE_DATE , LOC.LAST_UPDATE_DATE LOC_LAST_UPDATE_DATE , 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 FND_TERRITORIES_VL TERR, HZ_CUST_ACCT_SITES ADDR, HZ_PARTY_SITES PARTY_SITE, HZ_LOCATIONS LOC WHERE ADDR.CUST_ACCOUNT_ID = -1 AND ADDR.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID AND LOC.COUNTRY = TERR.TERRITORY_CODE(+)

View Text - HTML Formatted

SELECT 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.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
, ARH_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.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.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.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID*/
, PARTY_SITE.PARTY_SITE_ID PARTY_SITE_ID
, PARTY_SITE.PARTY_ID
, LOC.LOCATION_ID
, PARTY_SITE.PARTY_SITE_NUMBER SITE_NUMBER
, PARTY_SITE.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG
, ADDR.ATTRIBUTE16 ATTRIBUTE16
, ADDR.ATTRIBUTE17 ATTRIBUTE17
, ADDR.ATTRIBUTE18 ATTRIBUTE18
, ADDR.ATTRIBUTE19 ATTRIBUTE19
, ADDR.ATTRIBUTE20 ATTRIBUTE20
, PARTY_SITE.LAST_UPDATE_DATE PARTY_SITE_LAST_UPDATE_DATE
, LOC.LAST_UPDATE_DATE LOC_LAST_UPDATE_DATE
, 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 FND_TERRITORIES_VL TERR
, HZ_CUST_ACCT_SITES ADDR
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
WHERE ADDR.CUST_ACCOUNT_ID = -1
AND ADDR.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.COUNTRY = TERR.TERRITORY_CODE(+)