IBY_XML_HR_ADDR_1_0

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ADDRESS LOCATION_ID

Name

ADDRESS

LOCATION_ID

Query

SQL_Statement
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", decode(hr_loc.country, 'CA', null, hr_loc.region_1)), XMLElement("State", decode(hr_loc.country, 'CA', null, hr_loc.region_2)), XMLElement("Province", decode(hr_loc.country, 'CA', hr_loc.region_1, null)), XMLElement("Country", hr_loc.country), XMLElement("ISO3DigitCountry", trb.iso_territory_code), XMLElement("CountryName", trt.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')), XMLElement("AddressName", hr_loc.location_code) ), hr_loc.location_id FROM xle_locations_v hr_loc, fnd_territories_b trb, fnd_territories_tl trt WHERE hr_loc.country = trb.territory_code(+) AND trb.territory_code = trt.territory_code(+) AND trt.language(+) = USERENV('LANG')

SQL_Statement

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", decode(hr_loc.country, 'CA', null, hr_loc.region_1)), XMLElement("State", decode(hr_loc.country, 'CA', null, hr_loc.region_2)), XMLElement("Province", decode(hr_loc.country, 'CA', hr_loc.region_1, null)), XMLElement("Country", hr_loc.country), XMLElement("ISO3DigitCountry", trb.iso_territory_code), XMLElement("CountryName", trt.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')), XMLElement("AddressName", hr_loc.location_code) ), hr_loc.location_id

FROM xle_locations_v hr_loc, fnd_territories_b trb, fnd_territories_tl trt

WHERE hr_loc.country = trb.territory_code(+)

AND trb.territory_code = trt.territory_code(+)

AND trt.language(+) = USERENV('LANG')