select m.name as name,
mc.mc_sort,
sh.sh_org_id as orgid,
sum(sl.sl_ship_qty) as shipqty,
0 as receiptqty,
0 as quantqty
from wm_ship_header sh
join wm_ship_line sl
on sh.billid = sl.billid
join CP_VENDOR_CUSTOMER vc
on sh.sh_customer_id = vc.id
join cp_material m
on m.id = sl.sl_material_id
join CP_MATERIAL_CATEGORY mc
on mc.id = m.MAT_CATEGORY_ID
where 1 = 1
and mc.is_count = 1
and (sl.sl_lot_mstdata0 = 84345823 or
sl.sl_lot_mstdata0 = 228292)
and to_char(sh.makedate, 'yyyy-mm-dd') =to_char(sysdate, 'yyyy-mm-dd')
group by m.name, mc.mc_sort, sh.sh_org_id