FA : Query to fetch Asset Books - Cost History

Here is query to get the Cost History fotr particular asset
select
    fb.book_type_code               "Book",
    fa.asset_number                 "Asset Number",
    fb.transaction_header_id_in     "Reference Number",
    fth.transaction_type_code       "Transaction Type",
    fth.transaction_date_entered    "Transaction Date",
    fth.date_effective              "Date Effective",
    fb.cost                         "Cost",
   fa.asset_id
from
    fa_additions_b fa,
    fa_books fb,
    fa_transaction_headers fth
where
    1=1
and fb.asset_id = fa.asset_id
and fth.transaction_header_id (+) = fb.transaction_header_id_in
and fth.asset_id (+) = fb.asset_id
and fa.asset_number ='asset number'
order by
    1,2, fb.transaction_header_id_in desc