ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A4E80B1C542452FBE053B46B6358D452 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' Y US FA Depreciation by period Detail report with asset ID, depreciation run date, depreciation amount per period and depreciation YTD. Draft 1=1 1 10 1=1 fdd.book_type_code=:book_type_code LOV custom Y select BOOK_TYPE_CODE value, BOOK_TYPE_NAME description from FA_BOOK_CONTROLS_SEC ORDER BY BOOK_TYPE_CODE US Book