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_BOOKS_SUMMARY_MRC_V

Line 302: from fa_books_summary_mrc_v bs

298: select bs.period_counter
299: , bs.calendar_period_close_date
300: , bs.fiscal_year
301: , bs.period_num
302: from fa_books_summary_mrc_v bs
303: where bs.asset_id = p_asset_hdr_rec.asset_id
304: and bs.book_type_code = p_asset_hdr_rec.book_type_code
305: order by period_counter desc;
306:

Line 453: INSERT INTO FA_BOOKS_SUMMARY_MRC_V(

449: -- Insert all necessary records from period where DPIS falls into
450: --
451: if p_mrc_sob_type_code = 'R' then
452: FORALL i in tbs_period_counter.FIRST..tbs_period_counter.LAST
453: INSERT INTO FA_BOOKS_SUMMARY_MRC_V(
454: ASSET_ID
455: , BOOK_TYPE_CODE
456: , PERIOD_COUNTER
457: , FISCAL_YEAR

Line 620: FROM FA_BOOKS_SUMMARY_MRC_V BS

616: , p_trans_rec.who_info.creation_date
617: , p_trans_rec.who_info.created_by
618: , p_trans_rec.who_info.last_update_date
619: , p_trans_rec.who_info.last_updated_by
620: FROM FA_BOOKS_SUMMARY_MRC_V BS
621: WHERE BS.ASSET_ID = p_asset_hdr_rec.asset_id
622: AND BS.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
623: AND BS.period_counter = l_last_period_counter;
624:

Line 803: UPDATE FA_BOOKS_SUMMARY_MRC_V

799:
800: if p_depreciate_flag_change then
801:
802: if p_mrc_sob_type_code = 'R' then
803: UPDATE FA_BOOKS_SUMMARY_MRC_V
804: SET DEPRECIATE_FLAG = p_asset_fin_rec_new.depreciate_flag
805: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
806: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
807: else

Line 817: UPDATE FA_BOOKS_SUMMARY_MRC_V

813:
814: elsif p_disabled_flag_change then
815:
816: if p_mrc_sob_type_code = 'R' then
817: UPDATE FA_BOOKS_SUMMARY_MRC_V
818: SET DISABLED_FLAG = p_asset_fin_rec_new.depreciate_flag
819: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
820: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
821: else

Line 1021: DELETE FROM FA_BOOKS_SUMMARY_MRC_V

1017: --
1018: -- Delete all records for this group asset to recreate them
1019: --
1020: if p_mrc_sob_type_code = 'R' then
1021: DELETE FROM FA_BOOKS_SUMMARY_MRC_V
1022: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
1023: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
1024: else
1025: DELETE FROM FA_BOOKS_SUMMARY

Line 1075: INSERT INTO FA_BOOKS_SUMMARY_MRC_V(

1071: -- Insert all necessary records from period where DPIS falls into
1072: --
1073: if p_mrc_sob_type_code = 'R' then
1074: FORALL i in tbs_period_counter.FIRST..tbs_period_counter.LAST
1075: INSERT INTO FA_BOOKS_SUMMARY_MRC_V(
1076: ASSET_ID
1077: , BOOK_TYPE_CODE
1078: , PERIOD_COUNTER
1079: , FISCAL_YEAR

Line 2653: from fa_books_summary_mrc_v bs

2649: and bs.period_counter = p_period_rec.period_counter;
2650:
2651: CURSOR c_check_mc_record_exists IS
2652: select bs.period_counter
2653: from fa_books_summary_mrc_v bs
2654: where bs.asset_id = p_asset_hdr_rec.asset_id
2655: and bs.book_type_code = p_asset_hdr_rec.book_type_code
2656: and bs.period_counter = p_period_rec.period_counter;
2657:

Line 2860: UPDATE FA_BOOKS_SUMMARY_MRC_V

2856: --tk_util.debug('l_reserve_amount: '||to_char(l_reserve_amount));
2857:
2858: if (p_mrc_sob_type_code = 'R') then
2859:
2860: UPDATE FA_BOOKS_SUMMARY_MRC_V
2861: SET RESET_ADJUSTED_COST_FLAG = 'Y'
2862: , SALVAGE_TYPE = px_asset_fin_rec_new.salvage_type
2863: , PERCENT_SALVAGE_VALUE = px_asset_fin_rec_new.percent_salvage_value
2864: , SALVAGE_VALUE = px_asset_fin_rec_new.salvage_value

Line 3024: UPDATE FA_BOOKS_SUMMARY_MRC_V

3020: --tk_util.debug('l_reserve_amount: '||to_char(l_reserve_amount));
3021:
3022: if (p_mrc_sob_type_code = 'R') then
3023:
3024: UPDATE FA_BOOKS_SUMMARY_MRC_V
3025: SET RESET_ADJUSTED_COST_FLAG = 'Y'
3026: , CHANGE_IN_COST = CHANGE_IN_COST + nvl(p_asset_fin_rec_adj.cost, 0)
3027: , CHANGE_IN_CIP_COST = CHANGE_IN_CIP_COST + nvl(p_asset_fin_rec_adj.cip_cost, 0)
3028: , COST = px_asset_fin_rec_new.cost

Line 3337: from fa_books_summary_mrc_v bs

3333: , deprn_adjustment_amount
3334: , bs.expense_adjustment_amount
3335: , bs.reserve_adjustment_amount
3336: , bs.change_in_eofy_reserve
3337: from fa_books_summary_mrc_v bs
3338: where bs.asset_id = p_asset_hdr_rec.asset_id
3339: and bs.book_type_code = p_asset_hdr_rec.book_type_code
3340: and bs.period_counter >= c_period_counter
3341: order by bs.period_counter;

Line 3357: from fa_books_summary_mrc_v

3353: CURSOR c_get_mc_eofy_amts(c_period_counter number) IS
3354: select recoverable_cost
3355: , salvage_value
3356: , deprn_reserve
3357: from fa_books_summary_mrc_v
3358: where asset_id = p_asset_hdr_rec.asset_id
3359: and book_type_code = p_asset_hdr_rec.book_type_code
3360: and period_counter = c_period_counter;
3361:

Line 3401: from fa_books_summary_mrc_v bs

3397: and bs.period_counter = p_period_rec.period_counter;
3398:
3399: CURSOR c_check_mc_record_exists IS
3400: select bs.period_counter
3401: from fa_books_summary_mrc_v bs
3402: where bs.asset_id = p_asset_hdr_rec.asset_id
3403: and bs.book_type_code = p_asset_hdr_rec.book_type_code
3404: and bs.period_counter = p_period_rec.period_counter;
3405:

Line 3589: from fa_books_summary_mrc_v

3585:
3586: --+ MRCsupport
3587: CURSOR c_chk_bs_row_exists_mrc IS
3588: select 'Y'
3589: from fa_books_summary_mrc_v
3590: where book_type_code = p_asset_hdr_rec.book_type_code
3591: and group_asset_id = p_asset_hdr_rec.asset_id
3592: and asset_id <> group_asset_id
3593: and period_counter = l_recalc_start_period_counter - 1;

Line 3597: from fa_books_summary_mrc_v

3593: and period_counter = l_recalc_start_period_counter - 1;
3594:
3595: CURSOR c_get_mem_bs_row_mrc IS
3596: select ytd_deprn,deprn_reserve,bonus_ytd_deprn,bonus_deprn_reserve,eofy_reserve
3597: from fa_books_summary_mrc_v
3598: where book_type_code = p_asset_hdr_rec.book_type_code
3599: and asset_id = p_reclassed_asset_id
3600: and group_asset_id = p_asset_hdr_rec.asset_id
3601: and period_counter = l_trx_period_rec.period_counter - 1;

Line 3927: update fa_books_summary_mrc_v

3923: p_trans_rec.who_info.last_update_date,
3924: p_trans_rec.who_info.last_updated_by);
3925: else -- Reporting
3926:
3927: update fa_books_summary_mrc_v
3928: set group_Asset_id = p_asset_hdr_rec.asset_id
3929: where asset_id=p_reclassed_asset_id
3930: and period_counter >= l_trx_period_rec.period_counter;
3931:

Line 3945: insert into fa_books_summary_mrc_v(book_type_code,

3941: g_mem_deprn_reserve := nvl(l_mem_deprn_reserve_addition,0);
3942: g_mem_eofy_reserve := g_mem_deprn_reserve - g_mem_ytd_deprn;
3943: end if;
3944:
3945: insert into fa_books_summary_mrc_v(book_type_code,
3946: asset_id,
3947: group_asset_id,
3948: period_counter,
3949: cost,

Line 6577: UPDATE FA_BOOKS_SUMMARY_MRC_V

6573: end loop;
6574: */
6575: if (p_mrc_sob_type_code = 'R') then
6576: FORALL i in l_temp_ind..fa_amort_pvt.t_cost.LAST
6577: UPDATE FA_BOOKS_SUMMARY_MRC_V
6578: SET RESET_ADJUSTED_COST_FLAG = fa_amort_pvt.t_reset_adjusted_cost_flag(i)
6579: , CHANGE_IN_COST = fa_amort_pvt.t_change_in_cost(i)
6580: , CHANGE_IN_CIP_COST = fa_amort_pvt.t_change_in_cip_cost(i)
6581: , COST = fa_amort_pvt.t_cost(i)