Ücretli İstek Son Alış Tarihi Gelebilir mi?

SELECT

I.CODE 'MALZEME KODU',
I.NAME 'MALZEME AÇIKLAMA',
U.CODE 'BİRİM',

ISNULL(ALIS.AMOUNT,0) [Son Alış Miktar],
ISNULL(ALIS.[Kdv Hariç Adet Fiyatı] ,0) [Son Alış Kdv Hariç],
ISNULL(ALIS.[Kdv Dahil Adet Fiyatı] ,0) [Son Alış Kdv Dahil],
ISNULL(SATIS.AMOUNT,0) [Son Satış Miktar],
ISNULL(SATIS.[Kdv Hariç Adet Fiyatı] ,0) [Son Satış Kdv Hariç],
ISNULL(SATIS.[Kdv Dahil Adet Fiyatı] ,0) [Son Satış Kdv Dahil]


FROM
LG_159_ITEMS I LEFT OUTER JOIN
LG_159_UNITSETL U ON U.UNITSETREF=I.UNITSETREF
AND U.MAINUNIT=1

OUTER APPLY

(SELECT TOP 1 S.STOCKREF, AMOUNT*
CASE WHEN
ISNULL(UINFO2,0)=0 THEN 1 ELSE UINFO2 END / CASE WHEN
ISNULL(UINFO1,0)=0 THEN 1 ELSE UINFO1 END AMOUNT,
ISNULL(S.VATMATRAH/NULLIF(AMOUNT,0),0)*  CASE WHEN
ISNULL(UINFO2,0)=0 THEN 1 ELSE UINFO2 END / CASE WHEN
ISNULL(UINFO1,0)=0 THEN 1 ELSE UINFO1 END AS 'Kdv Hariç Adet Fiyatı',

ISNULL((S.VATMATRAH+S.VATAMNT)/NULLIF(AMOUNT,0),0) * CASE WHEN
ISNULL(UINFO1,0)=0 THEN 1 ELSE UINFO1 END/CASE WHEN
ISNULL(UINFO2,0)=0 THEN 1 ELSE UINFO2 END AS 'Kdv Dahil Adet Fiyatı'

FROM 
LG_159_01_STLINE S

WHERE S.STOCKREF = I.LOGICALREF 

AND S.LINETYPE=0
AND S.TRCODE IN (1,14)
AND S.STFICHEREF<>0
AND S.CANCELLED=0
AND S.VATMATRAH>0

ORDER BY S.DATE_ DESC,S.FTIME DESC) AS ALIS

OUTER APPLY

(SELECT TOP 1
S.STOCKREF, AMOUNT*
CASE WHEN
ISNULL(UINFO2,0)=0 THEN 1 ELSE UINFO2 END/CASE WHEN
ISNULL(UINFO1,0)=0 THEN 1 ELSE UINFO1 END AMOUNT,
ISNULL(S.VATMATRAH/NULLIF(AMOUNT,0),0)* CASE WHEN
ISNULL(UINFO2,0)=0 THEN 1 ELSE UINFO2 END/CASE WHEN
ISNULL(UINFO1,0)=0 THEN 1 ELSE UINFO1 END AS 'Kdv Hariç Adet Fiyatı',

ISNULL((S.VATMATRAH+S.VATAMNT)/NULLIF(AMOUNT,0),0) * CASE WHEN
ISNULL(UINFO1,0)=0 THEN 1 ELSE UINFO1 END/CASE WHEN
ISNULL(UINFO2,0)=0 THEN 1 ELSE UINFO2 END AS 'Kdv Dahil Adet Fiyatı'

FROM 
LG_159_01_STLINE S WHERE S.STOCKREF = I.LOGICALREF 

AND S.LINETYPE=0
AND S.TRCODE IN (7,8)
AND S.STFICHEREF<>0
AND S.CANCELLED=0
AND S.VATMATRAH>0

ORDER BY S.DATE_ DESC,S.FTIME DESC) AS SATIS