CREATE VIEW dbo.GUNLUK_SATIS_LISTESI
AS
SELECT   ITM.CODE AS ICODE, ITM.NAME AS INAME, ITM.SPECODE4 AS MARKA, ITM.SPECODE AS RAF, ISNULL(ESK.ONHAND, 0) AS OSTOCK, ISNULL(BSS.ONHAND, 0) AS BSTOCK, 
                         ISNULL(GNT.ONHAND, 0) AS STOK, SUM(STL.AMOUNT) AS SAT, ISNULL(SKV.SECIM, 0) AS SECIM, ITM.LOGICALREF AS REF, ITM.SPECODE5 AS BLOK, ISNULL(SKV.HATA, 0) AS HATA, 
                         ISNULL(SKV.DUZELTME, '') AS DUZELTME, ISNULL(SKV.REF, 0) AS SKVREF
FROM         dbo.LG_011_08_STLINE AS STL LEFT OUTER JOIN
                         dbo.LG_011_08_STFICHE AS STF ON STF.LOGICALREF = STL.STFICHEREF LEFT OUTER JOIN
                         dbo.LG_011_ITEMS AS ITM ON ITM.LOGICALREF = STL.STOCKREF LEFT OUTER JOIN
                         dbo.LV_011_08_GNTOTST AS GNT ON GNT.STOCKREF = STL.STOCKREF AND GNT.INVENNO = - 1 LEFT OUTER JOIN
                         dbo.STOK_KONTROL AS SKV ON SKV.ITEMREF = STL.STOCKREF AND SKV.DATE_ = CAST(GETDATE() AS DATE) LEFT OUTER JOIN
                         dbo.ESKI_STOK AS ESK ON ESK.STOCKREF = STL.STOCKREF LEFT OUTER JOIN
                         dbo.BU_SABAH_STOK AS BSS ON BSS.STOCKREF = STL.STOCKREF
WHERE     (STL.LINETYPE = 0) AND (STL.CANCELLED = 0) AND (STL.TRCODE = 8) AND (STF.DATE_ = DATEADD(DAY, - 1, CAST(GETDATE() AS DATE)))
GROUP BY ITM.CODE, ITM.NAME, ITM.SPECODE, ITM.SPECODE4, GNT.ONHAND, SKV.SECIM, ITM.LOGICALREF, ESK.ONHAND, BSS.ONHAND, ITM.SPECODE5, SKV.HATA, SKV.DUZELTME, 
                         SKV.REF