[Home] [Help]
View: IBY_XML_HR_ADDR_1_0_V
View Text
SELECT XMLCONCAT( XMLELEMENT("ADDRESSINTERNALID"
, HR_LOC.LOCATION_ID)
, XMLELEMENT("ADDRESSLINE1"
, HR_LOC.ADDRESS_LINE_1)
, XMLELEMENT("ADDRESSLINE2"
, HR_LOC.ADDRESS_LINE_2)
, XMLELEMENT("ADDRESSLINE3"
, HR_LOC.ADDRESS_LINE_3)
, XMLELEMENT("CITY"
, HR_LOC.TOWN_OR_CITY)
, XMLELEMENT("COUNTY"
, HR_LOC.REGION_1)
, XMLELEMENT("STATE"
, HR_LOC.REGION_2)
, XMLELEMENT("COUNTRY"
, HR_LOC.COUNTRY)
, XMLELEMENT("COUNTRYNAME"
, TE.TERRITORY_SHORT_NAME)
, XMLELEMENT("POSTALCODE"
, HR_LOC.POSTAL_CODE)
, XMLELEMENT("PREFORMATTEDCONCATENATEDADDRESS"
, IBY_FD_EXTRACT_GEN_PVT.FORMAT_HR_ADDRESS(HR_LOC.LOCATION_ID))
, XMLELEMENT("PREFORMATTEDMAILINGADDRESS"
, IBY_FD_EXTRACT_GEN_PVT.FORMAT_HR_ADDRESS(HR_LOC.LOCATION_ID
, 'POSTAL_ADDR')) )
, HR_LOC.LOCATION_ID
FROM HR_LOCATIONS_ALL HR_LOC
, FND_TERRITORIES_VL TE
WHERE HR_LOC.COUNTRY = TE.TERRITORY_CODE(+)
Columns