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 3610: from fa_deprn_summary

3606: and period_counter = l_trx_period_rec.period_counter - 1;
3607:
3608: CURSOR c_get_ytd_deprn IS
3609: select ytd_deprn,deprn_reserve
3610: from fa_deprn_summary
3611: where book_type_code = p_asset_hdr_rec.book_type_code
3612: and asset_id = p_reclassed_asset_id
3613: and period_counter = l_mem_period_counter
3614: and deprn_source_code = 'BOOKS';

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

3913: fa_debug_pkg.add(l_calling_fn, 'Insert row',
3914: g_mem_bonus_ytd_deprn||':'||g_mem_bonus_deprn_reserve||':'||g_mem_eofy_reserve, p_log_level_rec => p_log_level_rec);
3915: end if;
3916:
3917: -- Query YTD and Reserve from FA_DEPRN_SUMMARY for addition
3918: if p_mrc_sob_type_Code <> 'R' then
3919:
3920: update fa_books_summary
3921: set group_Asset_id = p_asset_hdr_rec.asset_id

Line 7633: from fa_deprn_summary

7629: p_unplanned_exp IN OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
7630:
7631: CURSOR c_check_period IS
7632: select 'Y'
7633: from fa_deprn_summary
7634: where asset_id = p_asset_hdr_rec.asset_id
7635: and book_type_code = p_asset_hdr_rec.book_type_code
7636: and period_counter <= p_period_rec.period_counter;
7637: /*

Line 7651: , fa_deprn_summary ds

7647: , ds.impairment_reserve - ds.ytd_impairment
7648: , ds.ltd_production - ds.ytd_production
7649: , ds.reval_reserve - ds.ytd_reval_deprn_expense
7650: from fa_fiscal_year fy
7651: , fa_deprn_summary ds
7652: , fa_deprn_periods dp
7653: where ds.asset_id = p_asset_hdr_rec.asset_id
7654: and ds.book_type_code = p_asset_hdr_rec.book_type_code
7655: and ds.deprn_source_code = 'BOOKS'

Line 7669: from fa_deprn_summary ds, fa_deprn_periods dp

7665: , ds.bonus_deprn_reserve
7666: , ds.impairment_reserve
7667: , ds.ltd_production
7668: , ds.reval_reserve
7669: from fa_deprn_summary ds, fa_deprn_periods dp
7670: ,
7671: (select (fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
7672: add_amort_period
7673: from fa_calendar_periods cp,

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

8182: -- Find transaction which is
8183: -- Entered in the same fiscal year as given transaction date
8184: -- The transaction has transaction_date ealier than the fiscal year start date
8185: -- In this case, Recalculation needs to go back more to recalculate because
8186: -- it is impossible to find eofy_reserve from fa_deprn_summary
8187: -- Bug 5654286 Excluded ADDITION/VOID transaction
8188: CURSOR c_get_other_trx IS
8189: select th.transaction_header_id transaction_header_id,
8190: nvl(th.amortization_start_date, th.transaction_date_entered) transaction_date_entered,

Line 8215: from fa_deprn_summary ds

8211: G_TRX_TYPE_TFR, G_TRX_TYPE_TFR_VOID,
8212: G_TRX_TYPE_REC, G_TRX_TYPE_UNIT_ADJ,
8213: G_TRX_TYPE_TFR_VOID)
8214: and not exists (select 1
8215: from fa_deprn_summary ds
8216: , fa_deprn_periods dp2
8217: where ds.asset_id = p_asset_hdr_rec.asset_id
8218: and ds.book_type_code = p_asset_hdr_rec.book_type_code
8219: and dp.book_type_code = p_asset_hdr_rec.book_type_code

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

11585: p_period_rec FA_API_TYPES.period_rec_type,
11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11588: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11589: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11590: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11591: x_impairment_expense OUT NOCOPY FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,
11592: p_running_mode IN NUMBER,
11593: p_used_by_revaluation IN NUMBER,

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

11586: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11588: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11589: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11590: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11591: x_impairment_expense OUT NOCOPY FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,
11592: p_running_mode IN NUMBER,
11593: p_used_by_revaluation IN NUMBER,
11594: p_reclassed_asset_id NUMBER,

Line 11591: x_impairment_expense OUT NOCOPY FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,

11587: p_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type,
11588: p_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type default null,
11589: x_deprn_expense OUT NOCOPY FA_DEPRN_SUMMARY.DEPRN_AMOUNT%TYPE,
11590: x_bonus_expense OUT NOCOPY FA_DEPRN_SUMMARY.BONUS_DEPRN_AMOUNT%TYPE,
11591: x_impairment_expense OUT NOCOPY FA_DEPRN_SUMMARY.IMPAIRMENT_AMOUNT%TYPE,
11592: p_running_mode IN NUMBER,
11593: p_used_by_revaluation IN NUMBER,
11594: p_reclassed_asset_id NUMBER,
11595: p_reclass_src_dest VARCHAR2,

Line 11623: from fa_deprn_summary ds

11619: select dp.calendar_period_open_date
11620: ,dp.fiscal_year
11621: ,ds.ytd_deprn
11622: ,ds.deprn_reserve
11623: from fa_deprn_summary ds
11624: , fa_deprn_periods dp
11625: where dp.book_type_code = p_asset_hdr_rec.book_type_code
11626: and ds.book_type_code = p_asset_hdr_rec.book_type_code
11627: and ds.asset_id = p_asset_hdr_rec.asset_id

Line 11860: , fa_deprn_summary ds

11856: '1st SELECT in c_get_ths_adj'
11857: from fa_transaction_headers th,
11858: fa_books bk
11859: , fa_books outbk
11860: , fa_deprn_summary ds
11861: where th.asset_id = p_asset_hdr_rec.asset_id
11862: and th.book_type_code = p_asset_hdr_rec.book_type_code
11863: and bk.asset_id = p_asset_hdr_rec.asset_id
11864: and bk.book_type_code = p_asset_hdr_rec.book_type_code

Line 12370: from fa_deprn_summary

12366:
12367: -- bug 4428646, modified from 'B' to 'BOOKS'.
12368: CURSOR c_get_brow IS
12369: select ytd_deprn, deprn_reserve
12370: from fa_deprn_summary
12371: where asset_id = p_asset_hdr_rec.asset_id
12372: and book_type_code = p_asset_hdr_rec.book_type_code
12373: and deprn_source_code = 'BOOKS';
12374:

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

15085: end if;
15086:
15087: if l_trans_rec.transaction_type_code = 'ADDITION' and l_entered_reserve <> 0 then
15088:
15089: -- reset deprn_reserve to the deprn_reserve in fa_deprn_summary
15090: select deprn_reserve
15091: into l_temp_reserve
15092: from fa_deprn_summary ds1
15093: where ds1.asset_id = p_asset_hdr_rec.asset_id

Line 15092: from fa_deprn_summary ds1

15088:
15089: -- reset deprn_reserve to the deprn_reserve in fa_deprn_summary
15090: select deprn_reserve
15091: into l_temp_reserve
15092: from fa_deprn_summary ds1
15093: where ds1.asset_id = p_asset_hdr_rec.asset_id
15094: and ds1.book_type_code = p_asset_hdr_rec.book_type_code
15095: and ds1.period_counter =
15096: (select ds2.period_counter + 1

Line 15097: from fa_deprn_summary ds2

15093: where ds1.asset_id = p_asset_hdr_rec.asset_id
15094: and ds1.book_type_code = p_asset_hdr_rec.book_type_code
15095: and ds1.period_counter =
15096: (select ds2.period_counter + 1
15097: from fa_deprn_summary ds2
15098: where ds2.asset_id = p_asset_hdr_rec.asset_id
15099: and ds2.book_type_code = p_asset_hdr_rec.book_type_code
15100: and ds2.deprn_source_code = 'BOOKS');
15101:

Line 16441: from fa_deprn_summary

16437: into l_deprn_summary.deprn_rsv,
16438: l_deprn_summary.bonus_deprn_rsv,
16439: l_deprn_summary.ytd_deprn,
16440: l_deprn_summary.impairment_rsv
16441: from fa_deprn_summary
16442: where asset_id = p_asset_hdr_rec.asset_id
16443: and book_type_code = p_asset_hdr_rec.book_type_code
16444: and deprn_source_code = 'BOOKS';
16445: end if;

Line 16821: fa_deprn_summary fads

16817: from
16818: fa_deprn_periods fadp,
16819: fa_deprn_periods fadp1,
16820: fa_transaction_headers fatr,
16821: fa_deprn_summary fads
16822: where fadp.book_type_code = p_asset_hdr_rec.book_type_code
16823: and p_trans_rec.amortization_start_date between fadp.calendar_period_open_date and fadp.calendar_period_close_date
16824: and fatr.book_type_code = p_asset_hdr_rec.book_type_code
16825: and fatr.asset_id = p_asset_hdr_rec.asset_id