View: AR_ACTIVE_REMIT_TO_ADDRESSES_V

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

View Text

SELECT ACCT_SITE.CUST_ACCT_SITE_ID ADDRESS_ID
, DECODE( ACCT_SITE.CUST_ACCT_SITE_ID
, NULL
, NULL
, ARH_ADDR_PKG.ARXTW_FORMAT_ADDRESS(LOC.ADDRESS_STYLE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.COUNTY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, T.TERRITORY_SHORT_NAME) )
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.CITY ||CHR(44)|| CHR(32)|| NVL(LOC.STATE
, LOC.PROVINCE) ||' '|| LOC.POSTAL_CODE|| CHR(32) || T.TERRITORY_SHORT_NAME ADDRESS3
, LOC.CITY
, LOC.COUNTY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, NVL(LOC.STATE
, LOC.PROVINCE)
, T.TERRITORY_SHORT_NAME
FROM HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, FND_TERRITORIES_VL T
WHERE ACCT_SITE.CUST_ACCT_SITE_ID IN ( SELECT DISTINCT ADDRESS_ID
FROM RA_REMIT_TOS
WHERE STATUS = 'A' )
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND ACCT_SITE.STATUS = 'A'
AND LOC.COUNTRY = T.TERRITORY_CODE

Columns