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

Line 74: from fa_books_summary

70: , deprn_amount
71: , ytd_deprn
72: , reserve_adjustment_amount
73: , deprn_reserve
74: from fa_books_summary
75: where asset_id = p_asset_id
76: and book_type_code = p_book_type_code
77: and period_counter >= nvl(p_period_counter, 1);
78:

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 312: from fa_books_summary bs

308: select bs.period_counter
309: , bs.calendar_period_close_date
310: , bs.fiscal_year
311: , bs.period_num
312: from fa_books_summary bs
313: where bs.asset_id = p_asset_hdr_rec.asset_id
314: and bs.book_type_code = p_asset_hdr_rec.book_type_code
315: order by period_counter desc;
316:

Line 445: fa_debug_pkg.add(l_calling_fn, 'Insert into', 'FA_BOOKS_SUMMARY'

441: END LOOP; -- i in 1..(p_period_rec.period_counter - l_last_period_counter)
442:
443:
444: if (p_log_level_rec.statement_level) then
445: fa_debug_pkg.add(l_calling_fn, 'Insert into', 'FA_BOOKS_SUMMARY'
446: ,p_log_level_rec => p_log_level_rec);
447: end if;
448: --
449: -- Insert all necessary records from period where DPIS falls into

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 627: INSERT INTO FA_BOOKS_SUMMARY(

623: AND BS.period_counter = l_last_period_counter;
624:
625: else
626: FORALL i in tbs_period_counter.FIRST..tbs_period_counter.LAST
627: INSERT INTO FA_BOOKS_SUMMARY(
628: ASSET_ID
629: , BOOK_TYPE_CODE
630: , PERIOD_COUNTER
631: , FISCAL_YEAR

Line 794: FROM FA_BOOKS_SUMMARY BS

790: , p_trans_rec.who_info.creation_date
791: , p_trans_rec.who_info.created_by
792: , p_trans_rec.who_info.last_update_date
793: , p_trans_rec.who_info.last_updated_by
794: FROM FA_BOOKS_SUMMARY BS
795: WHERE BS.ASSET_ID = p_asset_hdr_rec.asset_id
796: AND BS.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
797: AND BS.period_counter = l_last_period_counter;
798: end if; --p_mrc_sob_type_code = 'R'

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 808: UPDATE FA_BOOKS_SUMMARY

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
808: UPDATE FA_BOOKS_SUMMARY
809: SET DEPRECIATE_FLAG = p_asset_fin_rec_new.depreciate_flag
810: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
811: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
812: end if;

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 822: UPDATE FA_BOOKS_SUMMARY

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
822: UPDATE FA_BOOKS_SUMMARY
823: SET DISABLED_FLAG = p_asset_fin_rec_new.depreciate_flag
824: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
825: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
826: end if;

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 1025: DELETE FROM FA_BOOKS_SUMMARY

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
1026: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
1027: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
1028: end if;
1029:

Line 1067: fa_debug_pkg.add(l_calling_fn, 'Insert into', 'FA_BOOKS_SUMMARY'

1063: --
1064: tbs_reset_adjusted_cost_flag(1) := 'Y';
1065:
1066: if (p_log_level_rec.statement_level) then
1067: fa_debug_pkg.add(l_calling_fn, 'Insert into', 'FA_BOOKS_SUMMARY'
1068: ,p_log_level_rec => p_log_level_rec);
1069: end if;
1070: --
1071: -- Insert all necessary records from period where DPIS falls into

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 1246: INSERT INTO FA_BOOKS_SUMMARY(

1242:
1243: else
1244:
1245: FORALL i in tbs_period_counter.FIRST..tbs_period_counter.LAST
1246: INSERT INTO FA_BOOKS_SUMMARY(
1247: ASSET_ID
1248: , BOOK_TYPE_CODE
1249: , PERIOD_COUNTER
1250: , FISCAL_YEAR

Line 1471: from fa_books_summary

1467: CURSOR c_get_period_counters (c_date date,
1468: c_group_asset_id number) IS
1469: select period_counter,
1470: 0, 0, 0, 0, 0, null, 0, null, 0, 0, 0
1471: from fa_books_summary
1472: where asset_id = c_group_asset_id
1473: and book_type_code = p_asset_hdr_rec.book_type_code
1474: and calendar_period_close_date >= c_date
1475: order by period_counter;

Line 1485: , fa_books_summary bs

1481: , th.transaction_subtype
1482: , th.transaction_key
1483: , bs.period_counter
1484: from fa_transaction_headers th
1485: , fa_books_summary bs
1486: , fa_transaction_headers mth
1487: , fa_books bk
1488: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1489: and th.asset_id = mth.asset_id

Line 1517: from fa_books_summary bs

1513: , mth.transaction_type_code
1514: , mth.transaction_subtype
1515: , mth.transaction_key
1516: , bs.period_counter
1517: from fa_books_summary bs
1518: , fa_transaction_headers mth
1519: , fa_books bk
1520: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1521: and bs.asset_id = p_group_asset_id

Line 1741: -- Construct member asset table using group's data in FA_BOOKS_SUMMARY

1737: return TRUE;
1738:
1739: end if;
1740: --
1741: -- Construct member asset table using group's data in FA_BOOKS_SUMMARY
1742: --
1743: --tk_util.debug('c_date: '||to_char(p_date_placed_in_service, 'DD-MON-YYYY'));
1744: OPEN c_get_period_counters (p_date_placed_in_service,
1745: p_group_asset_id);

Line 2646: from fa_books_summary bs

2642: and ret.transaction_header_id_out = c_transaction_header_id;
2643:
2644: CURSOR c_check_record_exists IS
2645: select bs.period_counter
2646: from fa_books_summary bs
2647: where bs.asset_id = p_asset_hdr_rec.asset_id
2648: and bs.book_type_code = p_asset_hdr_rec.book_type_code
2649: and bs.period_counter = p_period_rec.period_counter;
2650:

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 2907: UPDATE FA_BOOKS_SUMMARY

2903: AND PERIOD_COUNTER = p_period_rec.period_counter;
2904:
2905: else
2906:
2907: UPDATE FA_BOOKS_SUMMARY
2908: SET RESET_ADJUSTED_COST_FLAG = 'Y'
2909: , SALVAGE_TYPE = px_asset_fin_rec_new.salvage_type
2910: , PERCENT_SALVAGE_VALUE = px_asset_fin_rec_new.percent_salvage_value
2911: , 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 3060: UPDATE FA_BOOKS_SUMMARY

3056: AND PERIOD_COUNTER = p_period_rec.period_counter;
3057:
3058: else
3059:
3060: UPDATE FA_BOOKS_SUMMARY
3061: SET RESET_ADJUSTED_COST_FLAG = 'Y'
3062: , CHANGE_IN_COST = CHANGE_IN_COST + nvl(p_asset_fin_rec_adj.cost, 0)
3063: , CHANGE_IN_CIP_COST = CHANGE_IN_CIP_COST + nvl(p_asset_fin_rec_adj.cip_cost, 0)
3064: , COST = COST + nvl(p_asset_fin_rec_adj.cost, 0)

Line 3181: -- This is to get period counter using FA_BOOKS_SUMMARY table

3177: and outbk.asset_id(+) = inbk.asset_id
3178: and outbk.book_type_code(+) = inbk.book_type_code;
3179:
3180: --
3181: -- This is to get period counter using FA_BOOKS_SUMMARY table
3182: --
3183: CURSOR c_get_books_summary(c_period_counter number) IS
3184: select
3185: bs.period_counter

Line 3257: from fa_books_summary bs

3253: , bs.deprn_adjustment_amount
3254: , bs.expense_adjustment_amount
3255: , bs.reserve_adjustment_amount
3256: , bs.change_in_eofy_reserve
3257: from fa_books_summary bs
3258: where bs.asset_id = p_asset_hdr_rec.asset_id
3259: and bs.book_type_code = p_asset_hdr_rec.book_type_code
3260: and bs.period_counter >= c_period_counter
3261: order by bs.period_counter;

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 3348: from fa_books_summary

3344: CURSOR c_get_eofy_amts(c_period_counter number) IS
3345: select recoverable_cost
3346: , salvage_value
3347: , deprn_reserve
3348: from fa_books_summary
3349: where asset_id = p_asset_hdr_rec.asset_id
3350: and book_type_code = p_asset_hdr_rec.book_type_code
3351: and period_counter = c_period_counter;
3352:

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 3394: from fa_books_summary bs

3390: and ret.transaction_header_id_out = p_trans_rec.member_transaction_header_id;
3391:
3392: CURSOR c_check_record_exists IS
3393: select bs.period_counter
3394: from fa_books_summary bs
3395: where bs.asset_id = p_asset_hdr_rec.asset_id
3396: and bs.book_type_code = p_asset_hdr_rec.book_type_code
3397: and bs.period_counter = p_period_rec.period_counter;
3398:

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 3435: l_temp_ind BINARY_INTEGER; -- Indicate where to start updating FA_BOOKS_SUMMARY

3431: -- the period where trx date
3432: -- falls into
3433:
3434: l_ind BINARY_INTEGER; -- Used to find delta amounts for each period
3435: l_temp_ind BINARY_INTEGER; -- Indicate where to start updating FA_BOOKS_SUMMARY
3436: l_old_reserve NUMBER;
3437:
3438: --
3439: -- Tables to store member delta information

Line 3564: from fa_books_summary

3560: l_chk_bs_row_exists VARCHAR2(1);
3561:
3562: CURSOR c_chk_bs_row_exists IS
3563: select 'Y'
3564: from fa_books_summary
3565: where book_type_code = p_asset_hdr_rec.book_type_code
3566: and group_asset_id = p_asset_hdr_rec.asset_id
3567: and asset_id <> group_asset_id
3568: and period_counter = l_recalc_start_period_counter - 1;

Line 3572: from fa_books_summary

3568: and period_counter = l_recalc_start_period_counter - 1;
3569:
3570: CURSOR c_get_mem_bs_row IS
3571: select ytd_deprn,deprn_reserve,bonus_ytd_deprn,bonus_deprn_reserve,eofy_reserve
3572: from fa_books_summary
3573: where book_type_code = p_asset_hdr_rec.book_type_code
3574: and asset_id = p_reclassed_asset_id
3575: and group_asset_id = p_asset_hdr_rec.asset_id
3576: and period_counter = l_trx_period_rec.period_counter - 1;

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 3847: -- In case this is DESTINATION, group_asset_id in FA_BOOKS_SUMMARY must be updated before starting to

3843: -- if it is from between dpis and current, then build first row
3844: -- and apply it and then apply rest of records.
3845:
3846: -- HHIRAGA
3847: -- In case this is DESTINATION, group_asset_id in FA_BOOKS_SUMMARY must be updated before starting to
3848: -- processing
3849:
3850: if (p_reclass_src_dest = 'DESTINATION') and
3851: nvl(px_asset_fin_rec_new.tracking_method,'NULL') = 'ALLOCATE' then

Line 3874: update fa_books_summary

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
3876: where asset_id=p_reclassed_asset_id
3877: and period_counter >= l_trx_period_rec.period_counter;
3878:

Line 3892: insert into fa_books_summary(book_type_code,

3888: g_mem_deprn_reserve := nvl(l_mem_deprn_reserve_addition,0);
3889: g_mem_eofy_reserve := g_mem_deprn_reserve - g_mem_ytd_deprn;
3890: end if;
3891:
3892: insert into fa_books_summary(book_type_code,
3893: asset_id,
3894: group_asset_id,
3895: period_counter,
3896: cost,

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 4172: -- is fa_books_summary records needed to be updated.

4168: This part of code will be removed by adding new column change_in_eofy_reserve
4169: *****************
4170: --
4171: -- Setting period counter which is used to determine from which period
4172: -- is fa_books_summary records needed to be updated.
4173: -- If there is eofy_reserve in fin_rec_adj, need to get record from
4174: -- previous eofy record to reflect the amount and recalculate.
4175: --
4176: --tk_util.debug('p_asset_fin_rec_adj.eofy_reserve: '||to_char(p_asset_fin_rec_adj.eofy_reserve));

Line 4387: -- Get eofy information from fa_books_summary_table

4383: end if;
4384:
4385: if (l_count = 1) then
4386: --
4387: -- Get eofy information from fa_books_summary_table
4388: --
4389: if (p_mrc_sob_type_code = 'R') then
4390: OPEN c_get_mc_eofy_amts(fa_amort_pvt.t_period_counter(1) - fa_amort_pvt.t_period_num(1));
4391: FETCH c_get_mc_eofy_amts INTO l_eofy_rec_cost

Line 4419: -- Get eofy information from fa_books_summary_table

4415: end if;
4416:
4417: else
4418: --
4419: -- Get eofy information from fa_books_summary_table
4420: --
4421: if (p_mrc_sob_type_code = 'R') then
4422: OPEN c_get_mc_eofy_amts(fa_amort_pvt.t_period_counter(2) - fa_amort_pvt.t_period_num(2));
4423: FETCH c_get_mc_eofy_amts INTO l_eofy_rec_cost

Line 4695: -- Update FA_BOOKS_SUMMARY

4691: );
4692: end loop;
4693: */
4694: --
4695: -- Update FA_BOOKS_SUMMARY
4696: --
4697:
4698: -- *********************** --
4699: -- Main Loop Starts Here --

Line 6550: -- Update FA_BOOKS_SUMMARY

6546: -- End of HHIRAGA
6547:
6548: if (p_update_books_summary) then
6549: --
6550: -- Update FA_BOOKS_SUMMARY
6551: --
6552: --tk_util.debug('period# : cost: chcost: msal: exp: ytd: rsv: rsv');
6553: --tk_util.debug('period# : cost: adjcost: exp: eofy: rsvaj: rsv: dlmt: arec');
6554: /*

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)

Line 6653: UPDATE FA_BOOKS_SUMMARY

6649: AND PERIOD_COUNTER = fa_amort_pvt.t_period_counter(i);
6650:
6651: else
6652: FORALL i in l_temp_ind..fa_amort_pvt.t_cost.LAST
6653: UPDATE FA_BOOKS_SUMMARY
6654: SET RESET_ADJUSTED_COST_FLAG = fa_amort_pvt.t_reset_adjusted_cost_flag(i)
6655: , CHANGE_IN_COST = fa_amort_pvt.t_change_in_cost(i)
6656: , CHANGE_IN_CIP_COST = fa_amort_pvt.t_change_in_cip_cost(i)
6657: , COST = fa_amort_pvt.t_cost(i)

Line 7301: -- No Need to Maintain FA_BOOKS_SUMMARY Table

7297: l_call_bs := FALSE;
7298: end if;
7299:
7300: if (not l_call_bs) then
7301: -- No Need to Maintain FA_BOOKS_SUMMARY Table
7302: return true;
7303: end if;
7304: end if;
7305:

Line 15689: from fa_books_summary

15685: l_chk_bs_row_exists VARCHAR2(1);
15686:
15687: CURSOR c_chk_bs_row_exists IS
15688: select 'Y'
15689: from fa_books_summary
15690: where book_type_code = p_asset_hdr_rec.book_type_code
15691: and group_asset_id = p_asset_hdr_rec.asset_id
15692: and asset_id <> group_asset_id
15693: and period_counter = l_recalc_start_period_counter - 1;

Line 16136: -- FA_BOOKS_SUMMARY. Not for calculating a catch-up.

16132: end if;
16133:
16134: --
16135: -- Purpose of calling CurrentPeriodAdj is to reflect the trx to
16136: -- FA_BOOKS_SUMMARY. Not for calculating a catch-up.
16137: -- Call CurrentPeriodAdj if:
16138: -- This is group asset.
16139: -- This is current period trx
16140: -- This is not member ret/rein, group reclass or group reclas with enter.

Line 16223: , fa_books_summary bs

16219: from fa_books inbk
16220: , fa_books outbk
16221: , fa_transaction_headers inth
16222: , fa_transaction_headers outth
16223: , fa_books_summary bs
16224: where inbk.transaction_header_id_in = p_transaction_header_id
16225: and outbk.asset_id = inbk.asset_id
16226: and outbk.book_type_code = p_book_type_code
16227: and outbk.transaction_header_id_out = p_transaction_header_id