CREATE VIEW dbo.KARA_LISTE_SIRALI
AS
SELECT   ITM.LOGICALREF, ISNULL(GNT.ONHAND, 0) AS ONHAND, ROW_NUMBER() OVER (ORDER BY ITM.LOGICALREF) AS SIRA
FROM         LG_011_ITEMS AS ITM LEFT OUTER JOIN
                         LV_011_08_GNTOTST AS GNT ON GNT.STOCKREF = ITM.LOGICALREF AND GNT.INVENNO = - 1
WHERE     ITM.LOSTFACTOR = 1 AND (ITM.ACTIVE = 0) AND (ITM.LOGICALREF IN
                             (SELECT   CARDREF
                                FROM         dbo.LG_011_PRCLIST
                                WHERE     (PTYPE = 2) AND (ACTIVE = 0)))