Get OU and Org

SELECT ood.organization_code,
       ood.organization_id,
       ood.organization_name,
       ood.operating_unit,
       hou.NAME ou_name,
       ood.legal_entity,
       ood.set_of_books_id,
       ood.business_group_id
  FROM org_organization_definitions ood, hr_operating_units hou
 WHERE hou.organization_id = ood.operating_unit
   AND ood.organization_code IN ('XXX', 'YYY', 'ZZZ');