Query to get Legal Entity, Operating Unit, Inventory Org details in Oracle Apps

 SELECT xep.name legal_entity_name

      ,gl.name  ledger_name

  ,hou.name operating_unit

  ,hou.short_code

  ,hou.organization_id org_id

  ,hou.set_of_books_id

  ,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 hr_operating_units hou

    ,org_organization_definitions ood

,gl_ledgers gl

,xle_entity_profiles xep

WHERE hou.organization_id(+) = ood.operating_unit

  AND ood.set_of_books_id = gl.ledger_id

  AND ood.legal_entity = xep.legal_entity_id

ORDER BY hou.organization_id;