CREATE VIEW dbo.MALZEMELER_SON_FIYATLAR
AS
SELECT        ITEMREF, REF, LINEEXP1, LINEEXP2, IHRSAT, IHRCURRENCY, SIRA,COMPANYREF
FROM            ((SELECT        ITEMREF, REF, LINEEXP1, LINEEXP2, IHRSAT, IHRCURRENCY, SIRA,COMPANYREF
                            FROM            ((SELECT        ITEMREF, REF, LINEEXP1, LINEEXP2, IHRSAT, IHRCURRENCY, ROW_NUMBER() OVER (PARTITION BY ITEMREF
                                                        ORDER BY ORDER_ DESC) AS SIRA,COMPANYREF
                            FROM            [IHR].[dbo].[PRCLIST])) QQ
WHERE        QQ.SIRA IN (1))) KK