View: IBY_XML_HZ_ADDR_1_0_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_XML_HZ_ADDR_1_0_V

View Text

SELECT XMLCONCAT( XMLELEMENT("ADDRESSINTERNALID"
, HZ_LOC.LOCATION_ID)
, XMLELEMENT("ADDRESSLINE1"
, HZ_LOC.ADDRESS1)
, XMLELEMENT("ADDRESSLINE2"
, HZ_LOC.ADDRESS2)
, XMLELEMENT("ADDRESSLINE3"
, HZ_LOC.ADDRESS3)
, XMLELEMENT("CITY"
, HZ_LOC.CITY)
, XMLELEMENT("COUNTY"
, HZ_LOC.COUNTY)
, XMLELEMENT("STATE"
, HZ_LOC.STATE)
, XMLELEMENT("COUNTRY"
, HZ_LOC.COUNTRY)
, XMLELEMENT("COUNTRYNAME"
, TE.TERRITORY_SHORT_NAME)
, XMLELEMENT("POSTALCODE"
, HZ_LOC.POSTAL_CODE)
, XMLELEMENT("PREFORMATTEDCONCATENATEDADDRESS"
, HZ_FORMAT_PUB.FORMAT_ADDRESS(HZ_LOC.LOCATION_ID))
, XMLELEMENT("PREFORMATTEDMAILINGADDRESS"
, HZ_FORMAT_PUB.FORMAT_ADDRESS(HZ_LOC.LOCATION_ID
, 'POSTAL_ADDR')) )
, HZ_LOC.LOCATION_ID
FROM HZ_LOCATIONS HZ_LOC
, FND_TERRITORIES_VL TE
WHERE HZ_LOC.COUNTRY = TE.TERRITORY_CODE

Columns