View: AR_XML_INVOICE_REMIT_TO_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_XML_INVOICE_REMIT_TO_V

View Text

SELECT RAA_REMIT.CUST_ACCT_SITE_ID
, RAA_REMIT_LOC.ADDRESS1
, RAA_REMIT_LOC.ADDRESS2
, RAA_REMIT_LOC.ADDRESS3
, RAA_REMIT_LOC.ADDRESS4
, DECODE( RAA_REMIT.CUST_ACCT_SITE_ID
, NULL
, NULL
, ARH_ADDR_PKG.ARXTW_FORMAT_ADDRESS(RAA_REMIT_LOC.ADDRESS_STYLE
, RAA_REMIT_LOC.ADDRESS1
, RAA_REMIT_LOC.ADDRESS2
, RAA_REMIT_LOC.ADDRESS3
, RAA_REMIT_LOC.ADDRESS4
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL)) ADDRESS
, RAA_REMIT_LOC.CITY
, RAA_REMIT_LOC.COUNTY
, RAA_REMIT_LOC.STATE
, RAA_REMIT_LOC.PROVINCE
, RAA_REMIT_LOC.POSTAL_CODE
, FT.TERRITORY_SHORT_NAME
, DECODE( RAA_REMIT.CUST_ACCT_SITE_ID
, NULL
, NULL
, ARH_ADDR_PKG.ARXTW_FORMAT_ADDRESS(RAA_REMIT_LOC.ADDRESS_STYLE
, RAA_REMIT_LOC.ADDRESS1
, RAA_REMIT_LOC.ADDRESS2
, RAA_REMIT_LOC.ADDRESS3
, RAA_REMIT_LOC.ADDRESS4
, RAA_REMIT_LOC.CITY
, RAA_REMIT_LOC.COUNTY
, RAA_REMIT_LOC.STATE
, RAA_REMIT_LOC.PROVINCE
, RAA_REMIT_LOC.POSTAL_CODE
, FT.TERRITORY_SHORT_NAME)) COMPLETE_ADDRESS
, AR_XML_VIEW_FUNCTIONS.RT_FUNCTION1(RAA_REMIT_PS.PARTY_SITE_ID) USER1
, AR_XML_VIEW_FUNCTIONS.RT_FUNCTION2(RAA_REMIT_PS.PARTY_SITE_ID) USER2
, AR_XML_VIEW_FUNCTIONS.RT_FUNCTION3(RAA_REMIT_PS.PARTY_SITE_ID) USER3
, AR_XML_VIEW_FUNCTIONS.RT_FUNCTION4(RAA_REMIT_PS.PARTY_SITE_ID) USER4
, AR_XML_VIEW_FUNCTIONS.RT_FUNCTION5(RAA_REMIT_PS.PARTY_SITE_ID) USER5
FROM HZ_CUST_ACCT_SITES RAA_REMIT
, HZ_PARTY_SITES RAA_REMIT_PS
, HZ_LOCATIONS RAA_REMIT_LOC
, FND_TERRITORIES_VL FT
WHERE RAA_REMIT.PARTY_SITE_ID = RAA_REMIT_PS.PARTY_SITE_ID(+)
AND RAA_REMIT_LOC.LOCATION_ID(+) = RAA_REMIT_PS.LOCATION_ID AND RAA_REMIT_LOC.COUNTRY = FT.TERRITORY_CODE(+)

Columns