CREATE VIEW dbo.DEPO_MALZEME_LISTESI_BARKODLU
AS
SELECT        ITM.CODE, CASE WHEN LEN(LTRIM(RTRIM(ITM.NAME)) + ' ' + LTRIM(RTRIM(ITM.NAME3))) <= 80 THEN LTRIM(RTRIM(ITM.NAME)) + ' ' + LTRIM(RTRIM(ITM.NAME3)) WHEN CHARINDEX(' ', 
                         REVERSE(LEFT(LTRIM(RTRIM(ITM.NAME)) + ' ' + LTRIM(RTRIM(ITM.NAME3)), 80))) = 0 THEN LEFT(LTRIM(RTRIM(ITM.NAME)) + ' ' + LTRIM(RTRIM(ITM.NAME3)), 80) ELSE LEFT(LTRIM(RTRIM(ITM.NAME)) 
                         + ' ' + LTRIM(RTRIM(ITM.NAME3)), 80 - CHARINDEX(' ', REVERSE(LEFT(LTRIM(RTRIM(ITM.NAME)) + ' ' + LTRIM(RTRIM(ITM.NAME3)), 80)))) END AS ITEMNAME, ISNULL(GNT.ONHAND, 0) AS STOCK, ITM.SPECODE4 AS MARKA, 
                         ITM.STGRPCODE AS TIP, ITM.SPECODE AS RAF, ITM.SPECODE5 AS BLOK, ITM.GROUPNR AS BCOLOR, ITM.LOGICALREF AS REF, ITM.EXPCTGNO AS BARKOD, CAST(0 AS BIT) AS SECIM
FROM            dbo.LG_011_ITEMS AS ITM LEFT OUTER JOIN
                         dbo.LV_011_08_GNTOTST AS GNT ON ITM.LOGICALREF = GNT.STOCKREF AND GNT.INVENNO = - 1
WHERE        (ITM.ACTIVE = 0) AND (ITM.CARDTYPE = 1)