Product: | AR - Receivables |
---|---|
Description: | (Release 11.5 Only) |
Implementation/DBA Data: | APPS.AR_REMIT_TO_ADDRESSES_V |
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(+)