CREATE VIEW dbo.EKISKONTO_ORANINA_GORE_SIRALI_CARI_LISTE
AS
SELECT        CC.LOGICALREF, CC.DISCRATE, XT.TURU AS TURU, ROW_NUMBER() OVER (ORDER BY LOGICALREF) AS SIRA
FROM            LG_011_CLCARD AS CC LEFT OUTER JOIN
                         LG_XT1015_011 AS XT ON XT.PARLOGREF = CC.LOGICALREF
WHERE        ACTIVE = 0 AND XT.TURU IS NOT NULL