Query to Get Organization Location Details

SELECT  ood.organization_code ,
        ood.organization_name,
        hou.name,
        hou.address_line_1,
        hou.country,
        hou.town_or_city
FROM org_organization_definitions ood,
     hr_organization_units_v hou
WHERE ood.disable_date IS NULL
AND ood.organization_id    = hou.organization_id;

Your's
Amar Alam