CREATE VIEW dbo.STOK_DEVIR_2021
AS
SELECT   ST.STOCKREF, ISNULL(ST.AMOUNT, 0) AS AMOUNT, ISNULL(GNT.ONHAND, 0) AS ONHAND, ISNULL(TS.TOPLAM, 0) AS TOPLAM, CASE WHEN ISNULL(ST.AMOUNT, 0) 
                         + ISNULL(GNT.ONHAND, 0) = 0 THEN 0 ELSE ISNULL(TS .TOPLAM, 0) / ((ISNULL(ST.AMOUNT, 0) + ISNULL(GNT.ONHAND, 0)) / 2) END AS DEVIR
FROM         dbo.LG_011_04_STLINE AS ST LEFT OUTER JOIN
                         dbo.LV_011_04_GNTOTST AS GNT ON ST.STOCKREF = GNT.STOCKREF AND GNT.INVENNO = - 1 LEFT OUTER JOIN
                         dbo.TOPLAM_SATISLAR_04 AS TS ON TS.LOGICALREF = ST.STOCKREF
WHERE     (ST.TRCODE = 14)