Запрос по всем видам остатков : Супермаг Плюс (Супермаг 2000)

with operg as
  (select og.article art,
          og.locid lid,
          nvl(sum(og.salequantity), 0) - nvl(sum(og.returnquantity), 0) chk
     from smopergoods og
     group by og.article,og.locid) -- здесь вычисляются остатки по чекам
Select c.article,c.name,sum(g.awaitedquantity) as aq,sum(g.quantity) as q,sum(g.foundquantity) fq,sum(opg.chk) ch,lv.salerate,lv.mindays*lv.salerate,lv.showlevel
From smcard c,sacardclass cc,smgoods g,operg opg,smstocklevels lv
Where c.idclass = cc.id and c.article = g.article and g.article = opg.art(+) and g.storeloc = opg.lid(+)
and lv.storeloc = g.storeloc and lv.article = c.article
and (cc.tree like '99.16%' or cc.tree like '99.27%' or cc.tree like '99.28%' or cc.tree like '99.29%' or cc.tree like '99.15%' or cc.tree like '99.10%' or cc.tree like '99.7%') group by c.article,c.name,lv.salerate,lv.mindays*lv.salerate,lv.showlevel;