Query to find Organization Structure Oracle Apps

Query to find Organization Structure in Oracle Apps


SELECT   ood.operating_unit, hou.NAME, ood.organization_id,       
         ood.organization_name,       
         (SELECT organization_code       
            FROM mtl_parameters mp       
           WHERE mp.organization_id = ood.organization_id) inventory_org_code       
    FROM hr_operating_units hou, org_organization_definitions ood       
   WHERE hou.organization_id = ood.operating_unit
ORDER BY ood.operating_unit, ood.organization_id;