How to get the latest date_retired from fa_retirement table in fixed assets?

Hi,

I need to show date_retired column in cost detail report customized version.

I am using the following join condition to fetch it;

AND  fr.asset_id = ad.asset_id

AND FR.book_type_code(+)    = 'TX TRN FED' 

AND  fr.status(+) = 'PROCESSED'

AND fr.DATE_EFFECTIVE(+) <= SYSDATE

AND  fr.TRANSACTION_HEADER_ID_OUT(+)  IS NULL

But still when compare the count of records with standard report count..Few records are coming extra.

Same asset id is having different transaction header id in and two different date retired columns are there. I want only the latest one .How to achieve this?