ytd depreciation oracle assets query

ytd depreciation oracle assets query

In this post , We will be discuss about the ytd depreciation oracle assets query. ytd depreciation is the total depreciated amount for the asset in a year. We do call the total depreciated amount for an year as as a ytd depreciation. This query will help to extract the complete asset details with Asset depreciation amount. We will get the YTD depreciation , depreciation reserve , depreciation for the month and other depreciation related informations in oracle apps. Here below is the complete ytd depreciation oracle assets query.

Important Tables Used By ytd depreciation oracle assets query

1.fa_additions

2.fa_deprn_periods

3.fa_deprn_detail

Detail ytd depreciation oracle assets query

Here below is the complete ytd depreciation oracle assets query. This query will be share the YTD depreciation amount with other depreciation details for an asset. This Query will give the detail level asset depreciation amount.

SELECT fa.asset_number,

       fa.asset_id,

       fdp.period_num,

       fdd.book_type_code,

       fdd.period_counter,

       fdp.period_name,

       fdp.fiscal_year,

       fdd.distribution_id,

       fdd.ytd_deprn,

       fdd.deprn_reserve,

       fdd.deprn_run_date,

       fdd.deprn_amount,

       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