SQL Statement from editor:
   
   
    INSERT INTO ttremains
        (storeloc, article, quantity)
        (SELECT location, article, -sum(quantity) quantity
             FROM (SELECT 1 location, s.article, sum(s.quantity * decode(1, 
                          d.locationto, 1, d.locationfrom, -1, 0)) quantity
                       FROM smdocuments d, smspec s
                       WHERE d.doctype = s.doctype
                         AND d.id = s.docid
                         AND 1 IN (d.locationto, d.locationfrom)
                         AND d.docstate >= 2
                         AND d.createdat > to_date('26.11.2007', 'DD.MM.YYYY')
                         AND s.article IN (SELECT fdata
                                  FROM ttfilterstr
                                  WHERE ftype = 1)
                       GROUP BY 1, s.article
                       HAVING sum(s.quantity * decode(1, d.locationto, 1, 
                              d.locationfrom, -1, 0)) <> 0
                   UNION ALL
                   SELECT storeloc, article, -quantity
                       FROM smgoods
                       WHERE quantity <> 0
                         AND storeloc = 1
                         AND article IN (SELECT fdata
                                  FROM ttfilterstr
                                  WHERE ftype = 1))
             GROUP BY location, article
             HAVING sum(quantity) <> 0)
  ------------------------------------------------------------
    
  Statement Id=26   Type=NESTED LOOPS
  Cost=0  TimeStamp=11-12-07::17::24:30
  
    INSERT STATEMENT  RULE
    FILTER
           (29)  SORT GROUP BY
               (28)  VIEW (Embedded SQL)
                   (27)  UNION-ALL
                       (20)  FILTER
                           (19)  SORT GROUP BY
                               (18)  VIEW (Embedded SQL)
                                   (17)  SORT UNIQUE
                                       (16)  CONCATENATION
                                           (8)  NESTED LOOPS
                                               (6)  NESTED LOOPS
                                                   (3)  TABLE ACCESS BY INDEX ROWID SUPERMAG.SMDOCUMENTS  [Analyzed] 
                                                   (3)   Blocks: 21 372 Est. Rows: ?? of 1 742 022 
                                                        Tablespace: USERS
                                                       (2)  NON-UNIQUE INDEX RANGE SCAN SUPERMAG.SMDOCUMENTS_LOCFROM  [Analyzed]
                                                   (5)  TABLE ACCESS BY INDEX ROWID SUPERMAG.SMSPEC  [Analyzed] 
                                                   (5)   Blocks: 810 096 Est. Rows: ?? of 93 261 042 
                                                        Tablespace: USERS
                                                       (4)  NON-UNIQUE INDEX RANGE SCAN SUPERMAG.SMCSPEC_DISPLAYPOS  [Analyzed]
                                               (7)  UNIQUE INDEX UNIQUE SCAN SUPERMAG.TTFILTERSTR_PK  [Not Analyzed]
                                           (15)  NESTED LOOPS
                                               (13)  NESTED LOOPS
                                                   (10)  TABLE ACCESS BY INDEX ROWID SUPERMAG.SMDOCUMENTS  [Analyzed] 
                                                   (10)   Blocks: 21 372 Est. Rows: ?? of 1 742 022 
                                                        Tablespace: USERS
                                                       (9)  NON-UNIQUE INDEX RANGE SCAN SUPERMAG.SMDOCUMENTS_LOCTO  [Analyzed]
                                                   (12)  TABLE ACCESS BY INDEX ROWID SUPERMAG.SMSPEC  [Analyzed] 
                                                   (12)   Blocks: 810 096 Est. Rows: ?? of 93 261 042 
                                                        Tablespace: USERS
                                                       (11)  NON-UNIQUE INDEX RANGE SCAN SUPERMAG.SMCSPEC_DISPLAYPOS  [Analyzed]
                                               (14)  UNIQUE INDEX UNIQUE SCAN SUPERMAG.TTFILTERSTR_PK  [Not Analyzed]
                       (26)  VIEW (Embedded SQL)
                           (25)  SORT UNIQUE
                               (24)  NESTED LOOPS
                                   (22)  TABLE ACCESS BY INDEX ROWID SUPERMAG.SMGOODS  [Analyzed] 
                                   (22)   Blocks: 3 648 Est. Rows: ?? of 954 273 
                                        Tablespace: USERS
                                       (21)  UNIQUE INDEX RANGE SCAN SUPERMAG.SMCGOODS_LOC  [Analyzed]
                                   (23)  UNIQUE INDEX UNIQUE SCAN SUPERMAG.TTFILTERSTR_PK  [Not Analyzed]