CREATE VIEW dbo.BARKOSUZ_SIRALI_URUN_LISTESI
AS
SELECT        LOGICALREF, ROW_NUMBER() OVER (ORDER BY LOGICALREF) AS SIRA
FROM            LG_011_ITEMS
WHERE        EXPCTGNO IS NULL OR
                         LEN(EXPCTGNO) < 8