Order Status Count

select
org.name,
count(*),
oh.flow_status_code

from
oe_order_headers_all oh,
hr_all_organization_units org

where
oh.org_id=org.organization_id

group by
org.name,
oh.flow_status_code

order by
org.name,
oh.flow_status_code