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

select  distinct c.article ||' '||0 
from    smcard c
inner join smcardsecuritylog clog on  c.article = clog.article and clog.actioncode = 1 and (clog.eventtime < TRUNC(SYSDATE - 2))
where   c.datatype = 0
    and c.accepted <> 2 
    and c.article not in (
        select  distinct smg.article
        from    smgoods smg                                                  
        where   smg.quantity <> 0
    
        union 

        select  spec.article
        from    smspec spec, smdocuments docs, smgoods smg
        where   spec.doctype = docs.doctype
            and spec.docid = docs.id
            and docs.doctype in ('WI','CR', 'WO', 'CS')
            and docs.docstate in (1, 2, 3)
            and docs.createdat between TRUNC(SYSDATE - 180, 'MON') and SYSDATE -- ïîë-ãîäà
            and spec.article = smg.article
        group by spec.article
        having  sum(abs(smg.quantity)) = 0 );