I need a query to get the YTD depreciation for a register which includes assets fully depreciated in

Here is the code:  I'm getting all the assets which depreciated in the period selected, but if an asset if fully reserved in a prior period of the same fiscal year, it either is not showing or gives a ytd depreciation of 0.

SELECT  distinct

            fadb.asset_number Asset_Num,  fab.date_placed_in_service "Date Placed in Service",

            (fab.life_in_months/12) Life_Years,

             fab.period_counter_fully_reserved PCFR,

             fab.COST "Cost",

           

CASE

   WHEN fab.asset_id not in (SELECT fa.asset_id FROM fa.fa_additions_tl fa,fa.fa_deprn_periods fdp,fa.fa_deprn_summary fds