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

106: , deprn_amount
107: , ytd_deprn
108: , reserve_adjustment_amount
109: , deprn_reserve
110: from fa_books_summary
111: where asset_id = p_asset_id
112: and book_type_code = p_book_type_code
113: and period_counter >= nvl(p_period_counter, 1);
114:

Line 344: from fa_books_summary bs

340: select bs.period_counter
341: , bs.calendar_period_close_date
342: , bs.fiscal_year
343: , bs.period_num
344: from fa_books_summary bs
345: where bs.asset_id = p_asset_hdr_rec.asset_id
346: and bs.book_type_code = p_asset_hdr_rec.book_type_code
347: order by period_counter desc;
348:

Line 474: fa_debug_pkg.add(l_calling_fn, 'Insert into', 'FA_BOOKS_SUMMARY', p_log_level_rec => p_log_level_rec);

470: END LOOP; -- i in 1..(p_period_rec.period_counter - l_last_period_counter)
471:
472:
473: if (p_log_level_rec.statement_level) then
474: fa_debug_pkg.add(l_calling_fn, 'Insert into', 'FA_BOOKS_SUMMARY', p_log_level_rec => p_log_level_rec);
475: end if;
476: --
477: -- Insert all necessary records from period where DPIS falls into
478: --

Line 664: INSERT INTO FA_BOOKS_SUMMARY(

660: AND BS.set_of_books_id = p_asset_hdr_rec.set_of_books_id;
661:
662: else
663: FORALL i in tbs_period_counter.FIRST..tbs_period_counter.LAST
664: INSERT INTO FA_BOOKS_SUMMARY(
665: ASSET_ID
666: , BOOK_TYPE_CODE
667: , PERIOD_COUNTER
668: , FISCAL_YEAR

Line 837: FROM FA_BOOKS_SUMMARY BS

833: , p_trans_rec.who_info.creation_date
834: , p_trans_rec.who_info.created_by
835: , p_trans_rec.who_info.last_update_date
836: , p_trans_rec.who_info.last_updated_by
837: FROM FA_BOOKS_SUMMARY BS
838: WHERE BS.ASSET_ID = p_asset_hdr_rec.asset_id
839: AND BS.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
840: AND BS.period_counter = l_last_period_counter;
841: end if; --p_mrc_sob_type_code = 'R'

Line 852: UPDATE FA_BOOKS_SUMMARY

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;
851: else
852: UPDATE FA_BOOKS_SUMMARY
853: SET DEPRECIATE_FLAG = p_asset_fin_rec_new.depreciate_flag
854: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
855: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
856: end if;

Line 867: UPDATE FA_BOOKS_SUMMARY

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;
866: else
867: UPDATE FA_BOOKS_SUMMARY
868: SET DISABLED_FLAG = p_asset_fin_rec_new.disabled_flag
869: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
870: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
871: end if;

Line 1073: DELETE FROM FA_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
1073: DELETE FROM FA_BOOKS_SUMMARY
1074: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
1075: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code;
1076: end if;
1077:

Line 1114: fa_debug_pkg.add(l_calling_fn, 'Insert into', 'FA_BOOKS_SUMMARY', p_log_level_rec => p_log_level_rec);

1110: --
1111: tbs_reset_adjusted_cost_flag(1) := 'Y';
1112:
1113: if (p_log_level_rec.statement_level) then
1114: fa_debug_pkg.add(l_calling_fn, 'Insert into', 'FA_BOOKS_SUMMARY', p_log_level_rec => p_log_level_rec);
1115: end if;
1116: --
1117: -- Insert all necessary records from period where DPIS falls into
1118: --

Line 1300: INSERT INTO FA_BOOKS_SUMMARY(

1296:
1297: else
1298:
1299: FORALL i in tbs_period_counter.FIRST..tbs_period_counter.LAST
1300: INSERT INTO FA_BOOKS_SUMMARY(
1301: ASSET_ID
1302: , BOOK_TYPE_CODE
1303: , PERIOD_COUNTER
1304: , FISCAL_YEAR

Line 1531: from fa_books_summary

1527: CURSOR c_get_period_counters (c_date date,
1528: c_group_asset_id number) IS
1529: select period_counter,
1530: 0, 0, 0, 0, 0, null, 0, null, 0, 0, 0
1531: from fa_books_summary
1532: where asset_id = c_group_asset_id
1533: and book_type_code = p_asset_hdr_rec.book_type_code
1534: and calendar_period_close_date >= c_date
1535: order by period_counter;

Line 1545: , fa_books_summary bs

1541: , th.transaction_subtype
1542: , th.transaction_key
1543: , bs.period_counter
1544: from fa_transaction_headers th
1545: , fa_books_summary bs
1546: , fa_transaction_headers mth
1547: , fa_books bk
1548: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1549: and th.asset_id = mth.asset_id

Line 1576: from fa_books_summary bs

1572: , mth.transaction_type_code
1573: , mth.transaction_subtype
1574: , mth.transaction_key
1575: , bs.period_counter
1576: from fa_books_summary bs
1577: , fa_transaction_headers mth
1578: , fa_books bk
1579: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1580: and bs.asset_id = p_group_asset_id

Line 1628: from fa_books_summary bs

1624: --bug6912446
1625: -- Following cursors to get retirement period for reinstatement trx
1626: CURSOR c_get_ret_period (c_transaction_header_id number)IS
1627: select bs.period_counter
1628: from fa_books_summary bs
1629: , fa_retirements rt
1630: where bs.asset_id = p_group_asset_id
1631: and bs.book_type_code = p_asset_hdr_rec.book_type_code
1632: and rt.date_retired between bs.calendar_period_open_date and bs.calendar_period_close_date

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

1812: return TRUE;
1813:
1814: end if;
1815: --
1816: -- Construct member asset table using group's data in FA_BOOKS_SUMMARY
1817: --
1818: --tk_util.debug('c_date: '||to_char(p_date_placed_in_service, 'DD-MON-YYYY'));
1819: OPEN c_get_period_counters (p_date_placed_in_service,
1820: p_group_asset_id);

Line 2634: from fa_books_summary bs

2630: and ret.set_of_books_id = p_asset_hdr_rec.set_of_books_id;
2631:
2632: CURSOR c_check_record_exists IS
2633: select bs.period_counter
2634: from fa_books_summary bs
2635: where bs.asset_id = p_asset_hdr_rec.asset_id
2636: and bs.book_type_code = p_asset_hdr_rec.book_type_code
2637: and bs.period_counter = p_period_rec.period_counter;
2638:

Line 2735: /Bug#8205561 - To populate fa_books_summary in case of dpis change/

2731: end if;
2732:
2733: end if; -- (((px_asset_fin_rec_new.salvage_type = 'SUM') and
2734:
2735: /*Bug#8205561 - To populate fa_books_summary in case of dpis change*/
2736: if (p_trans_rec.transaction_type_code = 'GROUP ADJUSTMENT' and
2737: p_trans_rec.transaction_key = 'GJ' and
2738: p_asset_fin_rec_old.date_placed_in_service <> px_asset_fin_rec_new.date_placed_in_service) then
2739: -- Group adjustment in period of group addition before

Line 2914: UPDATE FA_BOOKS_SUMMARY

2910: AND SET_OF_BOOKS_ID = p_asset_hdr_rec.set_of_books_id;
2911:
2912: else
2913:
2914: UPDATE FA_BOOKS_SUMMARY
2915: SET RESET_ADJUSTED_COST_FLAG = 'Y'
2916: , SALVAGE_TYPE = px_asset_fin_rec_new.salvage_type
2917: , PERCENT_SALVAGE_VALUE = px_asset_fin_rec_new.percent_salvage_value
2918: , SALVAGE_VALUE = px_asset_fin_rec_new.salvage_value

Line 3068: UPDATE FA_BOOKS_SUMMARY

3064: AND SET_OF_BOOKS_ID = p_asset_hdr_rec.set_of_books_id;
3065:
3066: else
3067:
3068: UPDATE FA_BOOKS_SUMMARY
3069: SET RESET_ADJUSTED_COST_FLAG = 'Y'
3070: , CHANGE_IN_COST = CHANGE_IN_COST + nvl(p_asset_fin_rec_adj.cost, 0)
3071: , CHANGE_IN_CIP_COST = CHANGE_IN_CIP_COST + nvl(p_asset_fin_rec_adj.cip_cost, 0)
3072: , COST = COST + nvl(p_asset_fin_rec_adj.cost, 0)

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

3183: and outbk.book_type_code(+) = inbk.book_type_code;
3184:
3185:
3186: --
3187: -- This is to get period counter using FA_BOOKS_SUMMARY table
3188: --
3189: CURSOR c_get_books_summary(c_period_counter number) IS
3190: select
3191: bs.period_counter

Line 3269: from fa_books_summary bs

3265: , bs.change_in_eofy_reserve
3266: , 0 impairment_amount
3267: , 0 ytd_impairment
3268: , 0 impairment_reserve
3269: from fa_books_summary bs
3270: where bs.asset_id = p_asset_hdr_rec.asset_id
3271: and bs.book_type_code = p_asset_hdr_rec.book_type_code
3272: and bs.period_counter >= c_period_counter
3273: order by bs.period_counter;

Line 3367: from fa_books_summary

3363: CURSOR c_get_eofy_amts(c_period_counter number) IS
3364: select recoverable_cost
3365: , salvage_value
3366: , deprn_reserve
3367: from fa_books_summary
3368: where asset_id = p_asset_hdr_rec.asset_id
3369: and book_type_code = p_asset_hdr_rec.book_type_code
3370: and period_counter = c_period_counter;
3371:

Line 3419: from fa_books_summary bs

3415: and ret.set_of_books_id = p_asset_hdr_rec.set_of_books_id ;
3416:
3417: CURSOR c_check_record_exists IS
3418: select bs.period_counter
3419: from fa_books_summary bs
3420: where bs.asset_id = p_asset_hdr_rec.asset_id
3421: and bs.book_type_code = p_asset_hdr_rec.book_type_code
3422: and bs.period_counter = p_period_rec.period_counter;
3423:

Line 3462: l_temp_ind BINARY_INTEGER; -- Indicate where to start updating FA_BOOKS_SUMMARY

3458: -- the period where trx date
3459: -- falls into
3460:
3461: l_ind BINARY_INTEGER; -- Used to find delta amounts for each period
3462: l_temp_ind BINARY_INTEGER; -- Indicate where to start updating FA_BOOKS_SUMMARY
3463: l_old_reserve NUMBER;
3464:
3465: --
3466: -- Tables to store member delta information

Line 3593: from fa_books_summary

3589: l_chk_bs_row_exists VARCHAR2(1);
3590:
3591: CURSOR c_chk_bs_row_exists IS
3592: select 'Y'
3593: from fa_books_summary
3594: where book_type_code = p_asset_hdr_rec.book_type_code
3595: and group_asset_id = p_asset_hdr_rec.asset_id
3596: and asset_id <> group_asset_id
3597: and period_counter = l_recalc_start_period_counter - 1;

Line 3602: from fa_books_summary

3598:
3599: CURSOR c_get_mem_bs_row IS
3600: select ytd_deprn,deprn_reserve,bonus_ytd_deprn,bonus_deprn_reserve,
3601: eofy_reserve,ytd_impairment,impairment_reserve
3602: from fa_books_summary
3603: where book_type_code = p_asset_hdr_rec.book_type_code
3604: and asset_id = p_reclassed_asset_id
3605: and group_asset_id = p_asset_hdr_rec.asset_id
3606: and period_counter = l_trx_period_rec.period_counter - 1;

Line 3885: -- In case this is DESTINATION, group_asset_id in FA_BOOKS_SUMMARY must be updated before starting to

3881: -- if it is from between dpis and current, then build first row
3882: -- and apply it and then apply rest of records.
3883:
3884: -- HHIRAGA
3885: -- In case this is DESTINATION, group_asset_id in FA_BOOKS_SUMMARY must be updated before starting to
3886: -- processing
3887:
3888: if (p_reclass_src_dest = 'DESTINATION') and
3889: nvl(px_asset_fin_rec_new.tracking_method,'NULL') = 'ALLOCATE' then

Line 3920: update fa_books_summary

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
3922: where asset_id=p_reclassed_asset_id
3923: and period_counter >= l_trx_period_rec.period_counter;
3924:

Line 3938: insert into fa_books_summary(book_type_code,

3934: g_mem_deprn_reserve := nvl(l_mem_deprn_reserve_addition,0);
3935: g_mem_eofy_reserve := g_mem_deprn_reserve - g_mem_ytd_deprn;
3936: end if;
3937:
3938: insert into fa_books_summary(book_type_code,
3939: asset_id,
3940: group_asset_id,
3941: period_counter,
3942: cost,

Line 4278: -- is fa_books_summary records needed to be updated.

4274: This part of code will be removed by adding new column change_in_eofy_reserve
4275: *****************
4276: --
4277: -- Setting period counter which is used to determine from which period
4278: -- is fa_books_summary records needed to be updated.
4279: -- If there is eofy_reserve in fin_rec_adj, need to get record from
4280: -- previous eofy record to reflect the amount and recalculate.
4281: --
4282: --tk_util.debug('p_asset_fin_rec_adj.eofy_reserve: '||to_char(p_asset_fin_rec_adj.eofy_reserve));

Line 4502: -- Get eofy information from fa_books_summary_table

4498: end if;
4499:
4500: if (l_count = 1) then
4501: --
4502: -- Get eofy information from fa_books_summary_table
4503: --
4504: if (p_mrc_sob_type_code = 'R') then
4505: OPEN c_get_mc_eofy_amts(fa_amort_pvt.t_period_counter(1) - fa_amort_pvt.t_period_num(1));
4506: FETCH c_get_mc_eofy_amts INTO l_eofy_rec_cost

Line 4534: -- Get eofy information from fa_books_summary_table

4530: end if;
4531:
4532: else
4533: --
4534: -- Get eofy information from fa_books_summary_table
4535: --
4536: if (p_mrc_sob_type_code = 'R') then
4537: OPEN c_get_mc_eofy_amts(fa_amort_pvt.t_period_counter(2) - fa_amort_pvt.t_period_num(2));
4538: FETCH c_get_mc_eofy_amts INTO l_eofy_rec_cost

Line 4806: -- Update FA_BOOKS_SUMMARY

4802: );
4803: end loop;
4804: */
4805: --
4806: -- Update FA_BOOKS_SUMMARY
4807: --
4808:
4809: -- *********************** --
4810: -- Main Loop Starts Here --

Line 6667: -- Update FA_BOOKS_SUMMARY

6663: -- End of HHIRAGA
6664:
6665: if (p_update_books_summary) then
6666: --
6667: -- Update FA_BOOKS_SUMMARY
6668: --
6669: --tk_util.debug('period# : cost: chcost: msal: exp: ytd: rsv: rsv');
6670: --tk_util.debug('period# : cost: adjcost: exp: eofy: rsvaj: rsv: dlmt: arec');
6671: /*

Line 6774: UPDATE FA_BOOKS_SUMMARY

6770: AND SET_OF_BOOKS_ID = p_asset_hdr_rec.set_of_books_id;
6771:
6772: else
6773: FORALL i in l_temp_ind..fa_amort_pvt.t_cost.LAST
6774: UPDATE FA_BOOKS_SUMMARY
6775: SET RESET_ADJUSTED_COST_FLAG = fa_amort_pvt.t_reset_adjusted_cost_flag(i)
6776: , CHANGE_IN_COST = fa_amort_pvt.t_change_in_cost(i)
6777: , CHANGE_IN_CIP_COST = fa_amort_pvt.t_change_in_cip_cost(i)
6778: , COST = fa_amort_pvt.t_cost(i)

Line 7411: -- No Need to Maintain FA_BOOKS_SUMMARY Table

7407: l_call_bs := FALSE;
7408: end if;
7409:
7410: if (not l_call_bs) then
7411: -- No Need to Maintain FA_BOOKS_SUMMARY Table
7412: return true;
7413: end if;
7414: end if;
7415:

Line 16792: from fa_books_summary

16788:
16789:
16790: CURSOR c_chk_bs_row_exists IS
16791: select 'Y'
16792: from fa_books_summary
16793: where book_type_code = p_asset_hdr_rec.book_type_code
16794: and group_asset_id = p_asset_hdr_rec.asset_id
16795: and asset_id <> group_asset_id
16796: and period_counter = l_recalc_start_period_counter - 1;

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

17318: end if;
17319:
17320: --
17321: -- Purpose of calling CurrentPeriodAdj is to reflect the trx to
17322: -- FA_BOOKS_SUMMARY. Not for calculating a catch-up.
17323: -- Call CurrentPeriodAdj if:
17324: -- This is group asset.
17325: -- This is current period trx
17326: -- This is not member ret/rein, group reclass or group reclas with enter.

Line 17405: , fa_books_summary bs

17401: from fa_books inbk
17402: , fa_books outbk
17403: , fa_transaction_headers inth
17404: , fa_transaction_headers outth
17405: , fa_books_summary bs
17406: where inbk.transaction_header_id_in = p_transaction_header_id
17407: and outbk.asset_id = inbk.asset_id
17408: and outbk.book_type_code = p_book_type_code
17409: and outbk.transaction_header_id_out = p_transaction_header_id