Yardım Satınalma fiyatlarını sql ile çekmek istiyorum

SELECT
I.CODE AS [STOK_KODU],I.NAME AS [STOK_ADI],SA.CARI_KOD,SA.CARI_ADI,
SA.FIYAT AS SON_ALIS_FIYATI,
CONVERT(VARCHAR,SA.TARIH,104) AS SON_ALIS_TARIH
FROM LG_002_ITEMS AS I
LEFT JOIN
(SELECT STOCKREF, ROW_NUMBER() OVER (PARTITION BY STOCKREF ORDER BY DATE_ DESC) AS TAR,C.CODE AS CARI_KOD,C.DEFINITION_ AS CARI_ADI,
ROUND(ST.VATMATRAH/NULLIF(ST.AMOUNT,0),2) AS FIYAT,ST.DATE_ AS TARIH
FROM LG_002_02_STLINE AS ST
LEFT JOIN LG_002_CLCARD AS C ON ST.CLIENTREF=C.LOGICALREF
WHERE CANCELLED=0 AND BILLED=1 AND TRCODE=1) AS SA ON I.LOGICALREF=SA.STOCKREF AND TAR=1
WHERE ACTIVE=0 AND SA.CARI_KOD IS NOT NULL