IBY_XML_HZ_ADDR_1_0_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
ADDRESS LOCATION_ID

Query

SQL_Statement

SELECT XMLConcat( XMLElement("AddressInternalID", hz_loc.location_id), XMLElement("AddressLine1", hz_loc.address1), XMLElement("AddressLine2", hz_loc.address2), XMLElement("AddressLine3", hz_loc.address3), XMLElement("AddressLine4", hz_loc.address4), XMLElement("City", hz_loc.city), XMLElement("County", hz_loc.county), XMLElement("State", hz_loc.state), XMLElement("Province", hz_loc.province), XMLElement("Country", hz_loc.country), XMLElement("ISO3DigitCountry", trb.iso_territory_code), XMLElement("CountryName", trt.territory_short_name), XMLElement("PostalCode", hz_loc.postal_code), XMLElement("PreFormattedConcatenatedAddress", IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id)), XMLElement("PreFormattedMailingAddress", IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id, 'POSTAL_ADDR')) ), hz_loc.location_id FROM hz_locations hz_loc, fnd_territories_b trb, fnd_territories_tl trt WHERE hz_loc.country = trb.territory_code AND trb.territory_code = trt.territory_code AND trt.language = USERENV('LANG')