Unit Retired of fully retired asset

Hi,

1.I just need to know from which table i can get the retired unit of an asset whether it is fully or partially retired.

2.How i will know that this data is fully retired.(I dont want to use the following query..)

select * from fa_transaction_headerswhere asset_id=input_asset_idand book_type_code=input_bookand transaction_type_code='FULL RETIREMENT'

because if we fully retired a data..then we can reinstate it and then retired it fully ..so it that case it will return two rows..

I have used the following query to identify whether its fully retired or not..