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.

VIEW: APPS.AR_ACTIVE_REMIT_TO_ADDRESSES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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