OU wise Orgs

select o.ORGANIZATION_CODE, o.ORGANIZATION_ID, o.ORGANIZATION_NAME, 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')
order by o.ORGANIZATION_CODE