Oracle Fixed assets depreciation query

Oracle Fixed assets depreciation query

We will be discussing about the Oracle fixed assets depreciation query. When we run the deprecation for the month in Fixed assets then system automatically calculates the depreciation for fixed asset as per the depreciation rate mentioned while defining the assets. If we want to extract the detail information about the assets depreciation, then we can use this below query in oracle apps. This query will help to find out the complete depreciation information’s for the assets like Depreciation amount , YTP depreciation , Depreciation reserve , Depreciation run date and many other important fixed assets depreciation information. Here below I will share the detail oracle fixed assets depreciation query and the important table for the depreciation query.

4 Important Table for oracle fixed assets depreciation query

fa_deprn_detail

fa_deprn_summary

fa_deprn_periods

fa_additions

Detail Oracle Fixed assets depreciation query

Here below is the complete fixed asset depreciation query which help to extract the system calculated depreciation amount for the fixed assets for the period in oracle apps.  

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

  FROM fa_additions       fa,

       fa_deprn_periods   fdp,

       fa.fa_deprn_detail fdd

 WHERE 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_number = :P_ASSET_NO

   AND fdp.period_name = :P_PERIOD_NAME