List of Warehouses SQL Query

select W.WAREHOUSE_ID, 
       W.WAREHOUSE_NAME, 
       L.CITY, 
       L.STATE_PROVINCE, 
       C.COUNTRY_NAME
from   WAREHOUSES W, 
       HR.LOCATIONS L, 
       HR.COUNTRIES C
where ( W.LOCATION_ID = L.LOCATION_ID(+) )
  and ( L.COUNTRY_ID = c.COUNTRY_ID(+) )  
order by C.COUNTRY_NAME, W.WAREHOUSE_NAME
