FA Depreciation by period

Description
Categories: Draft, Toolkit - Operations
Columns: Asset Number, Asset Id, Period Counter, Period Name, Fiscal Year, Period Num, Book Type Code, Distribution Id, Deprn Run Date, Deprn Amount ...
Detail report with asset ID, depreciation run date, depreciation amount per period and depreciation YTD.
SELECT fa.asset_number,
       fa.asset_id,
       fdd.period_counter,
       fdp.period_name,
       fdp.fiscal_year,
       fdp.period_num,
       fdd.book_type_code,
       fdd.distribution_id,
       fdd.deprn_run_date,
       fdd.deprn_amount,
       fdd.ytd_deprn,
       fdd.deprn_reserve,
       fdd.cost,
       fdd.deprn_adjustment_amount,
       fdd.event_id,
       fdd.deprn_run_id
  FROM fa_additions       fa,
       fa_deprn_periods   fdp,
       fa.fa_deprn_detail fdd
 WHERE 1=1
   AND fa.asset_id = fdd.asset_id
   AND fdp.period_counter = fdd.period_counter
   AND fdp.book_type_code = fdd.book_type_code
  -- AND fa.asset_id = 432178
 --  AND fdp.period_name = '04-14'
Parameter Name SQL text Validation
Book
fdd.book_type_code=:book_type_code
LOV