eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AR_BILL_TO_ADDRESSES_ACTIVE_V

Product:	AR - Receivables
Description:	(Release 11.5 Only)
Implementation/DBA Data:	APPS.AR_BILL_TO_ADDRESSES_ACTIVE_V

View Text

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
, SU_BILL.SITE_USE_ID SITE_USE_ID
, SU_BILL.LOCATION LOCATION
, ADDR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADDR.TERRITORY_ID TERRITORY_ID
, LOC.ADDRESS_KEY ADDRESS_KEY
, ADDR.KEY_ACCOUNT_FLAG KEY_ACCOUNT_FLAG
, LOC.LANGUAGE LANGUAGE
, 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
FROM FND_TERRITORIES_VL TERR
, HZ_CUST_SITE_USES SU_BILL
, HZ_CUST_ACCT_SITES ADDR
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
WHERE ADDR.CUST_ACCT_SITE_ID = SU_BILL.CUST_ACCT_SITE_ID
AND ADDR.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND ADDR.STATUS = 'A'
AND SU_BILL.SITE_USE_CODE = 'BILL_TO'
AND SU_BILL.STATUS = 'A'
AND LOC.COUNTRY = TERR.TERRITORY_CODE(+)

Columns

Name
ROW_ID
ADDRESS_ID
CUSTOMER_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
STATUS
ORIG_SYSTEM_REFERENCE
COUNTRY
TERRITORY_SHORT_NAME
ADDRESS_STYLE
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
COUNTY
STATE
PROVINCE
POSTAL_CODE
CONCATENATED_ADDRESS
SITE_USE_ID
LOCATION
LAST_UPDATE_LOGIN
TERRITORY_ID
ADDRESS_KEY
KEY_ACCOUNT_FLAG
LANGUAGE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ADDRESS_LINES_PHONETIC
EDI_LOCATION