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_MC_BOOKS_SUMMARY

Line 333: from fa_mc_books_summary bs

329: select bs.period_counter
330: , bs.calendar_period_close_date
331: , bs.fiscal_year
332: , bs.period_num
333: from fa_mc_books_summary bs
334: where bs.asset_id = p_asset_hdr_rec.asset_id
335: and bs.book_type_code = p_asset_hdr_rec.book_type_code
336: and bs.set_of_books_id = p_asset_hdr_rec.set_of_books_id
337: order by period_counter desc;

Line 481: INSERT INTO FA_MC_BOOKS_SUMMARY(

477: -- Insert all necessary records from period where DPIS falls into
478: --
479: if p_mrc_sob_type_code = 'R' then
480: FORALL i in tbs_period_counter.FIRST..tbs_period_counter.LAST
481: INSERT INTO FA_MC_BOOKS_SUMMARY(
482: SET_OF_BOOKS_ID
483: , ASSET_ID
484: , BOOK_TYPE_CODE
485: , PERIOD_COUNTER

Line 656: FROM FA_MC_BOOKS_SUMMARY BS

652: , p_trans_rec.who_info.creation_date
653: , p_trans_rec.who_info.created_by
654: , p_trans_rec.who_info.last_update_date
655: , p_trans_rec.who_info.last_updated_by
656: FROM FA_MC_BOOKS_SUMMARY BS
657: WHERE BS.ASSET_ID = p_asset_hdr_rec.asset_id
658: AND BS.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
659: AND BS.period_counter = l_last_period_counter
660: AND BS.set_of_books_id = p_asset_hdr_rec.set_of_books_id;

Line 846: UPDATE FA_MC_BOOKS_SUMMARY

842:
843: if p_depreciate_flag_change then
844:
845: if p_mrc_sob_type_code = 'R' then
846: UPDATE FA_MC_BOOKS_SUMMARY
847: SET DEPRECIATE_FLAG = p_asset_fin_rec_new.depreciate_flag
848: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
849: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
850: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;

Line 861: UPDATE FA_MC_BOOKS_SUMMARY

857:
858: elsif p_disabled_flag_change then
859:
860: if p_mrc_sob_type_code = 'R' then
861: UPDATE FA_MC_BOOKS_SUMMARY
862: SET DISABLED_FLAG = p_asset_fin_rec_new.disabled_flag
863: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
864: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
865: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;

Line 1068: DELETE FROM FA_MC_BOOKS_SUMMARY

1064: --
1065: -- Delete all records for this group asset to recreate them
1066: --
1067: if p_mrc_sob_type_code = 'R' then
1068: DELETE FROM FA_MC_BOOKS_SUMMARY
1069: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
1070: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
1071: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id;
1072: else

Line 1121: INSERT INTO FA_MC_BOOKS_SUMMARY(

1117: -- Insert all necessary records from period where DPIS falls into
1118: --
1119: if p_mrc_sob_type_code = 'R' then
1120: FORALL i in tbs_period_counter.FIRST..tbs_period_counter.LAST
1121: INSERT INTO FA_MC_BOOKS_SUMMARY(
1122: SET_OF_BOOKS_ID
1123: , ASSET_ID
1124: , BOOK_TYPE_CODE
1125: , PERIOD_COUNTER

Line 1637: from fa_mc_books_summary bs

1633: and rt.transaction_header_id_out = c_transaction_header_id;
1634:
1635: CURSOR c_get_mc_ret_period (c_transaction_header_id number)IS
1636: select bs.period_counter
1637: from fa_mc_books_summary bs
1638: , fa_mc_retirements rt
1639: where bs.asset_id = p_group_asset_id
1640: and bs.book_type_code = p_asset_hdr_rec.book_type_code
1641: and bs.set_of_books_id = p_asset_hdr_rec.set_of_books_id

Line 2641: from fa_mc_books_summary bs

2637: and bs.period_counter = p_period_rec.period_counter;
2638:
2639: CURSOR c_check_mc_record_exists IS
2640: select bs.period_counter
2641: from fa_mc_books_summary bs
2642: where bs.asset_id = p_asset_hdr_rec.asset_id
2643: and bs.book_type_code = p_asset_hdr_rec.book_type_code
2644: and bs.period_counter = p_period_rec.period_counter
2645: and bs.set_of_books_id = p_asset_hdr_rec.set_of_books_id ;

Line 2866: UPDATE FA_MC_BOOKS_SUMMARY

2862: --tk_util.debug('l_reserve_amount: '||to_char(l_reserve_amount));
2863:
2864: if (p_mrc_sob_type_code = 'R') then
2865:
2866: UPDATE FA_MC_BOOKS_SUMMARY
2867: SET RESET_ADJUSTED_COST_FLAG = 'Y'
2868: , SALVAGE_TYPE = px_asset_fin_rec_new.salvage_type
2869: , PERCENT_SALVAGE_VALUE = px_asset_fin_rec_new.percent_salvage_value
2870: , SALVAGE_VALUE = px_asset_fin_rec_new.salvage_value

Line 3031: UPDATE FA_MC_BOOKS_SUMMARY

3027: --tk_util.debug('l_reserve_amount: '||to_char(l_reserve_amount));
3028:
3029: if (p_mrc_sob_type_code = 'R') then
3030:
3031: UPDATE FA_MC_BOOKS_SUMMARY
3032: SET RESET_ADJUSTED_COST_FLAG = 'Y'
3033: , CHANGE_IN_COST = CHANGE_IN_COST + nvl(p_asset_fin_rec_adj.cost, 0)
3034: , CHANGE_IN_CIP_COST = CHANGE_IN_CIP_COST + nvl(p_asset_fin_rec_adj.cip_cost, 0)
3035: , COST = px_asset_fin_rec_new.cost

Line 3355: from fa_mc_books_summary bs

3351: , bs.change_in_eofy_reserve
3352: , 0 impairment_amount
3353: , 0 ytd_impairment
3354: , 0 impairment_reserve
3355: from fa_mc_books_summary bs
3356: where bs.asset_id = p_asset_hdr_rec.asset_id
3357: and bs.book_type_code = p_asset_hdr_rec.book_type_code
3358: and bs.period_counter >= c_period_counter
3359: and bs.set_of_books_id = p_asset_hdr_rec.set_of_books_id

Line 3376: from fa_mc_books_summary

3372: CURSOR c_get_mc_eofy_amts(c_period_counter number) IS
3373: select recoverable_cost
3374: , salvage_value
3375: , deprn_reserve
3376: from fa_mc_books_summary
3377: where asset_id = p_asset_hdr_rec.asset_id
3378: and book_type_code = p_asset_hdr_rec.book_type_code
3379: and period_counter = c_period_counter
3380: and set_of_books_id = p_asset_hdr_rec.set_of_books_id ;

Line 3426: from fa_mc_books_summary bs

3422: and bs.period_counter = p_period_rec.period_counter;
3423:
3424: CURSOR c_check_mc_record_exists IS
3425: select bs.period_counter
3426: from fa_mc_books_summary bs
3427: where bs.asset_id = p_asset_hdr_rec.asset_id
3428: and bs.book_type_code = p_asset_hdr_rec.book_type_code
3429: and bs.period_counter = p_period_rec.period_counter
3430: and bs.set_of_books_id = p_asset_hdr_rec.set_of_books_id;

Line 3619: from fa_mc_books_summary

3615:
3616: --+ MRCsupport
3617: CURSOR c_chk_bs_row_exists_mrc IS
3618: select 'Y'
3619: from fa_mc_books_summary
3620: where book_type_code = p_asset_hdr_rec.book_type_code
3621: and group_asset_id = p_asset_hdr_rec.asset_id
3622: and asset_id <> group_asset_id
3623: and period_counter = l_recalc_start_period_counter - 1

Line 3629: from fa_mc_books_summary

3625:
3626: CURSOR c_get_mem_bs_row_mrc IS
3627: select ytd_deprn,deprn_reserve,bonus_ytd_deprn,bonus_deprn_reserve,
3628: eofy_reserve, ytd_impairment, impairment_reserve
3629: from fa_mc_books_summary
3630: where book_type_code = p_asset_hdr_rec.book_type_code
3631: and asset_id = p_reclassed_asset_id
3632: and group_asset_id = p_asset_hdr_rec.asset_id
3633: and period_counter = l_trx_period_rec.period_counter - 1

Line 3977: update fa_mc_books_summary

3973: p_trans_rec.who_info.last_update_date,
3974: p_trans_rec.who_info.last_updated_by);
3975: else -- Reporting
3976:
3977: update fa_mc_books_summary
3978: set group_Asset_id = p_asset_hdr_rec.asset_id
3979: where asset_id=p_reclassed_asset_id
3980: and period_counter >= l_trx_period_rec.period_counter
3981: and set_of_books_id = p_asset_hdr_rec.set_of_books_id;

Line 3996: insert into fa_mc_books_summary(set_of_books_id,

3992: g_mem_deprn_reserve := nvl(l_mem_deprn_reserve_addition,0);
3993: g_mem_eofy_reserve := g_mem_deprn_reserve - g_mem_ytd_deprn;
3994: end if;
3995:
3996: insert into fa_mc_books_summary(set_of_books_id,
3997: book_type_code,
3998: asset_id,
3999: group_asset_id,
4000: period_counter,

Line 6694: UPDATE FA_MC_BOOKS_SUMMARY

6690: end loop;
6691: */
6692: if (p_mrc_sob_type_code = 'R') then
6693: FORALL i in l_temp_ind..fa_amort_pvt.t_cost.LAST
6694: UPDATE FA_MC_BOOKS_SUMMARY
6695: SET RESET_ADJUSTED_COST_FLAG = fa_amort_pvt.t_reset_adjusted_cost_flag(i)
6696: , CHANGE_IN_COST = fa_amort_pvt.t_change_in_cost(i)
6697: , CHANGE_IN_CIP_COST = fa_amort_pvt.t_change_in_cip_cost(i)
6698: , COST = fa_amort_pvt.t_cost(i)