Select fa.asset_number, x.asset_id,
fa.asset_id,fa.asset_category_id, fa.attribute_category_code, fb.book_type_code,
 fb.deprn_method_code,fb.life_in_months,fb.original_cost, fb.eofy_reserve,
 fb.cost, x.D_AMOUNT YTD_DEP, fb.eofy_reserve + x.D_AMOUNT AS ACC_DEP
from FA_ADDITIONS_b fa,
apps. FA_BOOKS_V fb,
(
Select asset_id, SUM(DEPRN_AMOUNT) AS D_AMOUNT
from fa_deprn_detail
where deprn_source_code='D' and book_type_code =:book_type_code
Group By asset_id
) x
where fa.asset_id=x.asset_id
AND fa.asset_id=fb.asset_id