eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_AMORT_PVT dependencies on FA_DEPRN_SUMMARY

Line 3580: from fa_deprn_summary

3576: and period_counter = l_trx_period_rec.period_counter - 1;
3577:
3578: CURSOR c_get_ytd_deprn IS
3579: select ytd_deprn,deprn_reserve
3580: from fa_deprn_summary
3581: where book_type_code = p_asset_hdr_rec.book_type_code
3582: and asset_id = p_reclassed_asset_id
3583: and period_counter = l_mem_period_counter
3584: and deprn_source_code = 'BOOKS';

Line 3605: from fa_deprn_summary_mrc_v

3601: and period_counter = l_trx_period_rec.period_counter - 1;
3602:
3603: CURSOR c_get_ytd_deprn_mrc IS
3604: select ytd_deprn,deprn_reserve
3605: from fa_deprn_summary_mrc_v
3606: where book_type_code = p_asset_hdr_rec.book_type_code
3607: and asset_id = p_reclassed_asset_id
3608: and period_counter = l_mem_period_counter
3609: and deprn_source_code = 'BOOKS';

Line 3871: -- Query YTD and Reserve from FA_DEPRN_SUMMARY for addition

3867: g_mem_bonus_ytd_deprn||':'||g_mem_bonus_deprn_reserve||':'||g_mem_eofy_reserve
3868: ,p_log_level_rec => p_log_level_rec);
3869: end if;
3870:
3871: -- Query YTD and Reserve from FA_DEPRN_SUMMARY for addition
3872: if p_mrc_sob_type_Code <> 'R' then
3873:
3874: update fa_books_summary
3875: set group_Asset_id = p_asset_hdr_rec.asset_id

Line 7530: from fa_deprn_summary

7526: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
7527:
7528: CURSOR c_check_period IS
7529: select 'Y'
7530: from fa_deprn_summary
7531: where asset_id = p_asset_hdr_rec.asset_id
7532: and book_type_code = p_asset_hdr_rec.book_type_code
7533: and period_counter <= p_period_rec.period_counter;
7534: /*

Line 7547: , fa_deprn_summary ds

7543: , ds.bonus_deprn_reserve - ds.bonus_ytd_deprn
7544: , ds.ltd_production - ds.ytd_production
7545: , ds.reval_reserve - ds.ytd_reval_deprn_expense
7546: from fa_fiscal_year fy
7547: , fa_deprn_summary ds
7548: , fa_deprn_periods dp
7549: where ds.asset_id = p_asset_hdr_rec.asset_id
7550: and ds.book_type_code = p_asset_hdr_rec.book_type_code
7551: and ds.deprn_source_code = 'BOOKS'

Line 7976: -- it is impossible to find eofy_reserve from fa_deprn_summary

7972: -- Find transaction which is
7973: -- Entered in the same fiscal year as given transaction date
7974: -- The transaction has transaction_date ealier than the fiscal year start date
7975: -- In this case, Recalculation needs to go back more to recalculate because
7976: -- it is impossible to find eofy_reserve from fa_deprn_summary
7977: CURSOR c_get_other_trx IS
7978: select th.transaction_header_id transaction_header_id,
7979: nvl(th.amortization_start_date, th.transaction_date_entered) transaction_date_entered,
7980: th.date_effective date_effective,

Line 8004: from fa_deprn_summary ds

8000: G_TRX_TYPE_TFR, G_TRX_TYPE_TFR_VOID,
8001: G_TRX_TYPE_REC, G_TRX_TYPE_UNIT_ADJ,
8002: G_TRX_TYPE_TFR_VOID)
8003: and not exists (select 1
8004: from fa_deprn_summary ds
8005: , fa_deprn_periods dp2
8006: where ds.asset_id = p_asset_hdr_rec.asset_id
8007: and ds.book_type_code = p_asset_hdr_rec.book_type_code
8008: and dp.book_type_code = p_asset_hdr_rec.book_type_code

Line 11180: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,

11176: p_period_rec FA_API_TYPES.period_rec_type,
11177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11178: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11179: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11180: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11181: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11182: p_running_mode IN NUMBER,
11183: p_used_by_revaluation IN NUMBER,
11184: p_reclassed_asset_id NUMBER,

Line 11181: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,

11177: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11178: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11179: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11180: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11181: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11182: p_running_mode IN NUMBER,
11183: p_used_by_revaluation IN NUMBER,
11184: p_reclassed_asset_id NUMBER,
11185: p_reclass_src_dest VARCHAR2,

Line 11203: from fa_deprn_summary ds

11199: l_entered_ytd NUMBER;
11200:
11201: CURSOR c_get_deprn_period_date IS
11202: select dp.calendar_period_open_date
11203: from fa_deprn_summary ds
11204: , fa_deprn_periods dp
11205: where dp.book_type_code = p_asset_hdr_rec.book_type_code
11206: and ds.book_type_code = p_asset_hdr_rec.book_type_code
11207: and ds.asset_id = p_asset_hdr_rec.asset_id

Line 11409: , fa_deprn_summary ds

11405: '1st SELECT in c_get_ths_adj'
11406: from fa_transaction_headers th,
11407: fa_books bk
11408: , fa_books outbk
11409: , fa_deprn_summary ds
11410: where th.asset_id = p_asset_hdr_rec.asset_id
11411: and th.book_type_code = p_asset_hdr_rec.book_type_code
11412: and bk.asset_id = p_asset_hdr_rec.asset_id
11413: and bk.book_type_code = p_asset_hdr_rec.book_type_code

Line 11801: from fa_deprn_summary

11797:
11798: -- bug 4428646, changed deprn_source_code to 'BOOKS, was 'B'.
11799: CURSOR c_get_brow IS
11800: select ytd_deprn, deprn_reserve
11801: from fa_deprn_summary
11802: where asset_id = p_asset_hdr_rec.asset_id
11803: and book_type_code = p_asset_hdr_rec.book_type_code
11804: and deprn_source_code = 'BOOKS';
11805:

Line 11808: from fa_deprn_summary_mrc_v

11804: and deprn_source_code = 'BOOKS';
11805:
11806: CURSOR c_get_mc_brow IS
11807: select ytd_deprn, deprn_reserve
11808: from fa_deprn_summary_mrc_v
11809: where asset_id = p_asset_hdr_rec.asset_id
11810: and book_type_code = p_asset_hdr_rec.book_type_code
11811: and deprn_source_code = 'BOOKS';
11812:

Line 14033: -- reset deprn_reserve to the deprn_reserve in fa_deprn_summary

14029:
14030: if l_trans_rec.transaction_type_code = 'ADDITION' and
14031: l_entered_reserve <> 0 then
14032:
14033: -- reset deprn_reserve to the deprn_reserve in fa_deprn_summary
14034: select deprn_reserve
14035: into l_temp_reserve
14036: from fa_deprn_summary ds1
14037: where ds1.asset_id = p_asset_hdr_rec.asset_id

Line 14036: from fa_deprn_summary ds1

14032:
14033: -- reset deprn_reserve to the deprn_reserve in fa_deprn_summary
14034: select deprn_reserve
14035: into l_temp_reserve
14036: from fa_deprn_summary ds1
14037: where ds1.asset_id = p_asset_hdr_rec.asset_id
14038: and ds1.book_type_code = p_asset_hdr_rec.book_type_code
14039: and ds1.period_counter =
14040: (select ds2.period_counter + 1

Line 14041: from fa_deprn_summary ds2

14037: where ds1.asset_id = p_asset_hdr_rec.asset_id
14038: and ds1.book_type_code = p_asset_hdr_rec.book_type_code
14039: and ds1.period_counter =
14040: (select ds2.period_counter + 1
14041: from fa_deprn_summary ds2
14042: where ds2.asset_id = p_asset_hdr_rec.asset_id
14043: and ds2.book_type_code =
14044: p_asset_hdr_rec.book_type_code
14045: and ds2.deprn_source_code = 'BOOKS');

Line 15322: from fa_deprn_summary_mrc_v

15318: ytd_deprn
15319: into l_deprn_summary.deprn_rsv,
15320: l_deprn_summary.bonus_deprn_rsv,
15321: l_deprn_summary.ytd_deprn
15322: from fa_deprn_summary_mrc_v
15323: where asset_id = p_asset_hdr_rec.asset_id
15324: and book_type_code = p_asset_hdr_rec.book_type_code
15325: and deprn_source_code = 'BOOKS';
15326: else

Line 15333: from fa_deprn_summary

15329: ytd_deprn
15330: into l_deprn_summary.deprn_rsv,
15331: l_deprn_summary.bonus_deprn_rsv,
15332: l_deprn_summary.ytd_deprn
15333: from fa_deprn_summary
15334: where asset_id = p_asset_hdr_rec.asset_id
15335: and book_type_code = p_asset_hdr_rec.book_type_code
15336: and deprn_source_code = 'BOOKS';
15337: end if;