Query : Lists all the organization units in the system as well as their addresses

select org.organization_id,
org.name,
loc.address_line_1,
loc.address_line_2,
loc.address_line_3,
loc.town_or_city,
loc.country,
loc.postal_code
from hr_all_organization_units org,
hr_locations_all loc
where org.location_id = loc.location_id