org_inv_org links

SELECT
         hou.NAME            operating_unit_name
       , hou.short_code      operating_unit_short_code
       , hou.organization_id operating_unit_id
       , hou.set_of_books_id Ledger_Id
       , gl.name             LEDGER_NAME
       , hou.business_group_id
       , ood.organization_name inventory_organization_name
       , ood.organization_code Inv_organization_code
       , ood.organization_id   Inv_organization_id
       , ood.chart_of_accounts_id
FROM
         apps.hr_operating_units           hou
       , apps.org_organization_definitions ood
       , apps.gl_ledgers                   GL
WHERE
         1                       = 1
         AND hou.organization_id = ood.operating_unit
         AND GL.ledger_id        =ood.set_of_books_id
         -- AND ood.organization_id = 207
ORDER BY
         hou.NAME ASC
       , ood.organization_name
;