OU wise Orgs Lists

select  u.SHORT_CODE, u.NAME, count(o.ORGANIZATION_CODE) --over (partition by u.SHORT_CODE)
orgs_per_ou
from org_organization_definitions o, hr_operating_units u
where o.OPERATING_UNIT=u.ORGANIZATION_ID and o.ORGANIZATION_CODE not in ('FMO')
group by  u.SHORT_CODE, u.NAME
order by u.SHORT_CODE