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

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 1702: from fa_mc_books inbk,

1698: , inbk.deprn_limit_type
1699: , outbk.deprn_limit_type
1700: , inbk.allowed_deprn_limit
1701: , outbk.allowed_deprn_limit
1702: from fa_mc_books inbk,
1703: fa_mc_books outbk
1704: , fa_transaction_headers mth
1705: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1706: and inbk.asset_id = mth.asset_id

Line 1703: fa_mc_books outbk

1699: , outbk.deprn_limit_type
1700: , inbk.allowed_deprn_limit
1701: , outbk.allowed_deprn_limit
1702: from fa_mc_books inbk,
1703: fa_mc_books outbk
1704: , fa_transaction_headers mth
1705: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1706: and inbk.asset_id = mth.asset_id
1707: and outbk.asset_id(+) = inbk.asset_id

Line 2569: from fa_mc_books inbk,

2565: CURSOR c_get_mc_deltas IS
2566: select inbk.salvage_value - nvl(outbk.salvage_value, 0)
2567: , nvl(inbk.allowed_deprn_limit_amount, 0) -
2568: nvl(outbk.allowed_deprn_limit_amount, 0)
2569: from fa_mc_books inbk,
2570: fa_mc_books outbk
2571: where outbk.asset_id(+) = inbk.asset_id
2572: and outbk.book_type_code(+) = inbk.book_type_code
2573: and inbk.transaction_header_id_in = p_trans_rec.member_transaction_header_id

Line 2570: fa_mc_books outbk

2566: select inbk.salvage_value - nvl(outbk.salvage_value, 0)
2567: , nvl(inbk.allowed_deprn_limit_amount, 0) -
2568: nvl(outbk.allowed_deprn_limit_amount, 0)
2569: from fa_mc_books inbk,
2570: fa_mc_books outbk
2571: where outbk.asset_id(+) = inbk.asset_id
2572: and outbk.book_type_code(+) = inbk.book_type_code
2573: and inbk.transaction_header_id_in = p_trans_rec.member_transaction_header_id
2574: and outbk.transaction_header_id_out(+) = inbk.transaction_header_id_in

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)

Line 8664: fa_mc_books inbk,

8660: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
8661: nvl(outbk.allowed_deprn_limit_amount, 0))
8662: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.cip_cost, 0) - nvl(outbk.cip_cost, 0))
8663: from fa_transaction_headers th,
8664: fa_mc_books inbk,
8665: fa_mc_books outbk
8666: where inbk.asset_id = p_asset_hdr_rec.asset_id
8667: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
8668: and inbk.set_of_books_id = p_asset_hdr_rec.set_of_books_id

Line 8665: fa_mc_books outbk

8661: nvl(outbk.allowed_deprn_limit_amount, 0))
8662: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.cip_cost, 0) - nvl(outbk.cip_cost, 0))
8663: from fa_transaction_headers th,
8664: fa_mc_books inbk,
8665: fa_mc_books outbk
8666: where inbk.asset_id = p_asset_hdr_rec.asset_id
8667: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
8668: and inbk.set_of_books_id = p_asset_hdr_rec.set_of_books_id
8669: and outbk.asset_id(+) = p_asset_hdr_rec.asset_id

Line 9128: from fa_mc_books

9124: , global_attribute18
9125: , global_attribute19
9126: , global_attribute20
9127: , global_attribute_category
9128: from fa_mc_books
9129: where asset_id = p_asset_hdr_rec.asset_id
9130: and set_of_books_id = p_asset_hdr_rec.set_of_books_id
9131: and book_type_code = p_asset_hdr_rec.book_type_code
9132: and (transaction_header_id_out = p_trans_rec.transaction_header_id

Line 9241: from fa_mc_books

9237: , global_attribute18
9238: , global_attribute19
9239: , global_attribute20
9240: , global_attribute_category
9241: from fa_mc_books
9242: where set_of_books_id = p_asset_hdr_rec.set_of_books_id
9243: and asset_id = p_asset_hdr_rec.asset_id
9244: and book_type_code = p_asset_hdr_rec.book_type_code
9245: and (transaction_header_id_out = p_init_transaction_header_id

Line 9660: from fa_mc_books inbk,

9656: , inbk.global_attribute18
9657: , inbk.global_attribute19
9658: , inbk.global_attribute20
9659: , inbk.global_attribute_category
9660: from fa_mc_books inbk,
9661: fa_mc_books outbk
9662: where inbk.asset_id = c_asset_id
9663: and inbk.asset_id = outbk.asset_id(+)
9664: and inbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 9661: fa_mc_books outbk

9657: , inbk.global_attribute19
9658: , inbk.global_attribute20
9659: , inbk.global_attribute_category
9660: from fa_mc_books inbk,
9661: fa_mc_books outbk
9662: where inbk.asset_id = c_asset_id
9663: and inbk.asset_id = outbk.asset_id(+)
9664: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
9665: and inbk.book_type_code = outbk.book_type_code(+)

Line 9997: from fa_mc_books inbk,

9993: , inbk.global_attribute18
9994: , inbk.global_attribute19
9995: , inbk.global_attribute20
9996: , inbk.global_attribute_category
9997: from fa_mc_books inbk,
9998: fa_mc_books outbk
9999: where inbk.asset_id = c_asset_id
10000: and inbk.asset_id = outbk.asset_id(+)
10001: and inbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 9998: fa_mc_books outbk

9994: , inbk.global_attribute19
9995: , inbk.global_attribute20
9996: , inbk.global_attribute_category
9997: from fa_mc_books inbk,
9998: fa_mc_books outbk
9999: where inbk.asset_id = c_asset_id
10000: and inbk.asset_id = outbk.asset_id(+)
10001: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
10002: and inbk.book_type_code = outbk.book_type_code(+)

Line 15761: from fa_mc_books bk

15757: l_asset_fin_rec.rate_adjustment_factor,
15758: l_asset_fin_rec.prorate_date,
15759: l_asset_fin_rec.deprn_start_date,
15760: l_asset_fin_rec.date_placed_in_service
15761: from fa_mc_books bk
15762: where bk.book_type_code = p_asset_hdr_rec.book_type_code
15763: and bk.asset_id = p_asset_hdr_rec.asset_id
15764: and bk.transaction_header_id_in = p_add_txn_id
15765: and bk.set_of_books_id = p_asset_hdr_rec.set_of_books_id;