CREATE VIEW dbo.STOK_RAPOR_SEPET_LISTESI
AS
SELECT        QQ.ORDERDATE, QQ.ISIM, QQ.TOPLAM_SATIR AS SATIR, CASE WHEN QQ.STATUS_ = 0 THEN 'ISLEM BEKLIYOR' ELSE 'ISLEME ALINDI' END AS STATUS_, dbo.orderNumber(ROW_NUMBER() OVER (ORDER BY QQ.ORDERDATE
                          ASC)) AS FIS, QQ.STATUS_ AS STA, QQ.USERID
FROM            ((SELECT        TT.ORDERDATE, KULL.ISIM, TT.TOPLAM_SATIR, TT.STATUS_, TT.USERID
                            FROM            (SELECT SPT.ORDERDATE, SPT.STATUS_, SPT.USERID, COUNT(DISTINCT SPT.STOCKREF) AS TOPLAM_SATIR
                                                      FROM            dbo.STOK_RAPOR_SIPARISLER AS SPT
                                                      WHERE        SPT.ORDERDATE IS NOT NULL AND SPT.ORDERDATE <> '' AND SPT.DEL_ = 0 AND SPT.STOCKREF IS NOT NULL AND SPT.STOCKREF <> 0 AND STOCKREF NOT IN (SELECT LOGICALREF FROM LG_011_ITEMS WHERE ACTIVE=1) AND
													  STOCKREF NOT IN (SELECT CARDREF FROM LG_011_PRCLIST WHERE ACTIVE=1) AND STOCKREF IN (SELECT CARDREF FROM LG_011_PRCLIST WHERE PTYPE=2)
                                                      GROUP BY SPT.ORDERDATE, SPT.STATUS_, SPT.USERID) TT LEFT OUTER JOIN
                                                     dbo.KULLANICILAR AS KULL ON KULL.REF = TT.USERID)) QQ