[Home] [Help]
98: select bks.rowid,
99: bks.asset_id,
100: bks.deprn_method_code,
101: bks.life_in_months
102: from fa_books_mrc_v bks,
103: fa_methods mt
104: where bks.asset_id = p_asset_hdr_rec.asset_id
105: and bks.book_type_code = p_asset_hdr_rec.book_type_code
106: and bks.transaction_header_id_out is null
409:
410: if (p_mrc_sob_type_code = 'R') then
411:
412: -- Bug:5701095
413: update fa_books_mrc_v bk
414: set (adjusted_cost, eofy_reserve, formula_factor, adjusted_capacity) =
415: (Select Decode(ds2.deprn_source_code,
416: 'BOOKS', ds2.adjusted_cost,
417: decode(p_period_rec.period_num - pers_per_yr,
450: bk2.eop_formula_factor)),
451: Decode(bk2.eop_adj_cost,
452: null, bk2.adjusted_capacity,
453: bk2.old_adjusted_capacity)
454: From fa_deprn_summary_mrc_v ds2, fa_deprn_summary_mrc_v ds1, fa_books_mrc_v bk2
455: where bk2.transaction_header_id_in = bk.transaction_header_id_in
456: and ds2.asset_id(+) = bk2.asset_id
457: and ds2.book_type_code(+) = bk2.book_type_code
458: and ds2.period_counter(+) = (p_period_rec.period_counter - 1)
1193: where asset_id = p_asset_hdr_rec.asset_id
1194: and book_type_code = p_asset_hdr_rec.book_type_code
1195: and transaction_header_id = l_thid;
1196:
1197: delete from fa_books_mrc_v
1198: where asset_id = p_asset_hdr_rec.asset_id
1199: and book_type_code = p_asset_hdr_rec.book_type_code
1200: and transaction_header_id_in = l_thid;
1201:
1198: where asset_id = p_asset_hdr_rec.asset_id
1199: and book_type_code = p_asset_hdr_rec.book_type_code
1200: and transaction_header_id_in = l_thid;
1201:
1202: update fa_books_mrc_v
1203: set transaction_header_id_out = null,
1204: date_ineffective = null
1205: where asset_id = p_asset_hdr_rec.asset_id
1206: and book_type_code = p_asset_hdr_rec.book_type_code