Location data present in HR_LOCATIONS_ALL table does not have a reference/corresponding Organization

Summary:

Location data present in HR_LOCATIONS_ALL table does not have a reference/corresponding Organization detail in HR_ALL_ORGANIZATION_UNITS

We need the detail of the table which will hold organization detail for all locations present in HR_LOCATIONS_ALL

SELECT hla.location_code Location,

   hla.ADDRESS_LINE_1 ADDRESS_1,


   hla.ADDRESS_LINE_2 ADDRESS_2,


   hla.ADDRESS_LINE_3 ADDRESS_3,


   hla.ADDRESS_LINE_4 ADDRESS_4,


             hla.TOWN_OR_CITY City,


             hla.REGION_2 STATE,


             hla.COUNTRY,


             hla.POSTAL_CODE,


             NULL country_code,


   NULL state_code,


   NULL phone,


   hla.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID,


             NULL COA_LOCATION,


             hou.Organization_id ship_to_org_id,