SELECT location_id, location_code, NAME, address_line_1, address_line_2,
address_line_3, telephone_number_1, postal_code, loc_information14,
loc_information15, loc_information16
FROM hr_organization_units_v
WHERE location_id is not null
address_line_3, telephone_number_1, postal_code, loc_information14,
loc_information15, loc_information16
FROM hr_organization_units_v
WHERE location_id is not null