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