CREATE VIEW dbo.STOK_RAPOR_SIPARIS_VERILDI
AS
SELECT STOCKREF, USERID, SUM(CAST(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(AMOUNT, '?', ''), 'BEKLEMEDE', ''), 'ARIZALI', ''), 'YANLIS', ''), 'ÜRÜN DOGRU', ''), 'KONTROL EDILECEK', ''), 
                  'ÜRETIM HATASI', ''), 'UYUMSUZ', ''), 'dikkat', '') AS int)) AS AMOUNT, TYPE_
FROM     dbo.STOK_RAPOR_SIPARISLER
WHERE  (DEL_ = 0) AND (ORDERDATE IS NOT NULL) AND (ORDERDATE <> '') AND (STOCKREF IS NOT NULL) AND (STOCKREF <> 0) AND (STOCKREF NOT IN
                      (SELECT LOGICALREF
                       FROM      dbo.LG_011_ITEMS
                       WHERE   (ACTIVE = 1))) AND (STOCKREF IN
                      (SELECT CARDREF
                       FROM      dbo.LG_011_PRCLIST
                       WHERE   (PTYPE = 2))) AND (STOCKREF NOT IN
                      (SELECT CARDREF
                       FROM      dbo.LG_011_PRCLIST AS LG_011_PRCLIST_1
                       WHERE   (ACTIVE = 1))) AND (TYPE_ <> 2)
GROUP BY STOCKREF, USERID, TYPE_