Остатки SMGOODS отличаются от остатков по документам : Супермаг Плюс (Супермаг 2000)

select rest_doc.article, rest_doc.quantity, smgoods.quantity
  from (
select spc.article, nvl(sum(
                               decode(head.doctype,
                                      'WI', spc.quantity,
                                      'CR', spc.quantity,
                                      'CS', -spc.quantity,
                                      'WO', -spc.quantity,
                                      0
                                     )
                           ), 0
                       ) quantity
 
  from smdocuments head, smspec spc
 where head.doctype = spc.doctype
   and head.id = spc.docid
   and (head.location = 6 or head.locationfrom = 6 or head.locationto = 6)
 group by spc.article
       ) rest_doc, smgoods
 where rest_doc.article = smgoods.article
   and smgoods.storeloc = 6
   and rest_doc.quantity != smgoods.quantity 

select head.doctype, ap.appname, count(1)
  from smdocuments head, ssdoctypes dt, smclientapps ap
 where head.doctype = dt.doctype
   and dt.appmodule = ap.id
 group by head.doctype, ap.appname