CREATE VIEW dbo.EKSIYE_DUSEN_SIPARISLER
AS
SELECT        CC.CODE, CC.DEFINITION_, CC.CITY, ITM.CODE AS OEM1, ITM.PRODUCERCODE AS OEM2, { fn CONCAT({ fn CONCAT(ITM.NAME, ' ') }, ITM.NAME3) } AS [MALZEME AÇIKLAMASI], ITM.SPECODE4 AS MARKA, 
                         ISNULL(GNT.ONHAND, 0) - ISNULL(SUT.MIKTAR, 0) AS [ÖNCEKI STOK], ISNULL(GNT.ONHAND, 0) AS [STOK MIKTARI], ISNULL(SUT.MIKTAR, 0) AS [TOPLAM SATINALMA], ISNULL(SLT.SIPARIS, 0) AS [TOPLAM ONERI SATIS], 
                         ISNULL(GNT.ONHAND - SLT.SIPARIS, 0) AS EKSIK, ISNULL(OSS.BAKIYE, 0) AS [SATIS MIKTARI]
FROM            dbo.ONERI_SATIS_SIPARISI_LISTESI AS OSS LEFT OUTER JOIN
                         dbo.LG_011_ITEMS AS ITM ON ITM.LOGICALREF = OSS.STOCKREF LEFT OUTER JOIN
                         dbo.LG_011_CLCARD AS CC ON CC.LOGICALREF = OSS.CLIENTREF LEFT OUTER JOIN
                         dbo.SATINALINAN_URUN_TOPLAMLARI AS SUT ON SUT.STOCKREF = OSS.STOCKREF LEFT OUTER JOIN
                         dbo.LV_011_07_GNTOTST AS GNT ON GNT.STOCKREF = OSS.STOCKREF AND GNT.INVENNO = - 1 LEFT OUTER JOIN
                         dbo.ONERI_SATIS_SIPARISI_LISTESI_TOPLAM AS SLT ON SLT.STOCKREF = OSS.STOCKREF AND ISNULL(GNT.ONHAND, 0) < ISNULL(SLT.SIPARIS, 0)