FA Depreciation by period

Description
Categories: Draft
Detail report with asset ID, depreciation run date, depreciation amount per period and depreciation YTD.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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