EBS QUERY TO GET THE INVENTORY ORGANIZATIONS UNDER OPERATING UNITS

SELECT hou.NAME operating_unit_name, hou.short_code,
hou.organization_id operating_unit_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
,ood.*
FROM hr_operating_units hou, org_organization_definitions ood
WHERE 1 = 1 AND hou.organization_id = ood.operating_unit
--and hou.NAME='HOLP_UK2_OU';
ORDER BY hou.organization_id ;