CREATE VIEW dbo.PLAS_SIRALI_TUMU
AS
SELECT *, ROW_NUMBER() OVER (ORDER BY TT.PLAS) AS SIRA FROM (SELECT        LOGICALREF, CASE WHEN CM.MANG IS NULL THEN CM2.MANG ELSE CM.MANG END AS MANG, 
CASE WHEN CM.PLAS IS NULL THEN CM2.PLAS ELSE CM.PLAS END AS PLAS
FROM            (SELECT DISTINCT LOGICALREF
                          FROM            dbo.PLAS_RAPOR_AYLIK_TOPLAM
                          WHERE        LOGICALREF IS NOT NULL) QQ LEFT OUTER JOIN
                         CITY_MANG AS CM ON CM.SALESMANREF = QQ.LOGICALREF LEFT OUTER JOIN
                         CITY_MANG AS CM2 ON CM2.SALESVEBREF = QQ.LOGICALREF)TT
						 WHERE TT.PLAS IS NOT NULL