CREATE VIEW dbo.ONERI_SATIS_SIPARISI_LISTESI_TOPLAM
AS
SELECT        STOCKREF, SUM(AMOUNT - SHIPPEDAMOUNT) AS SIPARIS
FROM            dbo.LG_011_08_ORFLINE
WHERE        (TRCODE = 1) AND (CANCELLED = 0) AND (LINETYPE = 0) AND (STATUS = 1)
GROUP BY STOCKREF