Query to find the organization location

SELECT

    hou.organization_id,

    hou.name operating_unit,

    hl.location_code,

    hl.description,

    hl.address_line_1,

    hl.town_or_city,

    hl.region_1,

    hl.postal_code,

    hl.country

FROM

    hr_operating_units         hou,

    hr_all_organization_units  haou,

    hr_locations_all           hl

WHERE

        hou.organization_id = haou.organization_id

    AND haou.location_id = hl.location_id

    AND hou.organization_id IN ( 101)

ORDER BY

    hou.name;