FA Depreciation by period

➜ Back to Library
Description
Categories: Draft, Toolkit - Operations
Detail report with asset ID, depreciation run date, depreciation amount per period and depreciation YTD.
Run FA Depreciation by period and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
FA Adjusted Form 4626 - AMT Summary Report- Not Supported: Reserved For Future Use FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) FA Form 4626 - AMT Detail Report- Not Supported: Reserved For Future Use GL Account Analysis (Distributions) 11g FA Unplanned Depreciation - draft FA Asset Additions FA Additions By Source FA Tax Preference - draft FA Asset Additions - draft
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™