ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 1D36E658A28107A7E06362FB0905790AY select count(*) count, oola.line_category_code, oola.open_flag, nvl2(oola.schedule_ship_date,'not null',null) schedule_ship_date, oola.flow_status_code from oe_order_lines_all oola group by oola.line_category_code, oola.open_flag, nvl2(oola.schedule_ship_date,'not null',null), oola.flow_status_code order by oola.line_category_code, oola.open_flag desc, count(*) desc US Open order lines