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_REVALUATION_PVT dependencies on FA_MC_BOOKS

Line 3510: update fa_mc_books_summary set reval_loss_balance = reval_loss_balance + ABS (l_reval_loss)

3506: where asset_id = p_asset_hdr_rec.asset_id
3507: and book_type_code = p_asset_hdr_rec.book_type_code
3508: and period_counter >= l_adj_in.period_counter_adjusted ;
3509: ELSE
3510: update fa_mc_books_summary set reval_loss_balance = reval_loss_balance + ABS (l_reval_loss)
3511: where asset_id = p_asset_hdr_rec.asset_id
3512: and book_type_code = p_asset_hdr_rec.book_type_code
3513: and set_of_books_id = p_asset_hdr_rec.set_of_books_id
3514: and period_counter >= l_adj_in.period_counter_adjusted ;

Line 3871: delete from fa_mc_books

3867: fa_debug_pkg.add(l_calling_fn,'ALC Deleting accounting entries of reval thid: '
3868: , p_thid,p_log_level_rec => p_log_level_rec);
3869: end if;
3870:
3871: delete from fa_mc_books
3872: where transaction_header_id_out is null
3873: and transaction_header_id_in = p_thid
3874: and book_type_code = p_asset_hdr_rec.book_type_code
3875: and asset_id = p_asset_hdr_rec.asset_id

Line 3885: update fa_mc_books

3881: and book_type_code = p_asset_hdr_rec.book_type_code
3882: and period_counter_created = l_period_rec.period_counter
3883: and set_of_books_id = p_asset_hdr_rec.set_of_books_id;
3884:
3885: update fa_mc_books
3886: set date_ineffective = null
3887: , transaction_header_id_out = null
3888: where asset_id = p_asset_hdr_rec.asset_id
3889: and book_type_code = p_asset_hdr_rec.book_type_code

Line 4513: UPDATE FA_MC_BOOKS

4509: and transaction_header_id = p_thid
4510: and set_of_books_id = p_asset_hdr_rec.set_of_books_id
4511: ;
4512:
4513: UPDATE FA_MC_BOOKS
4514: SET DATE_INEFFECTIVE = l_trans_rec.who_info.last_update_date
4515: , last_update_date = l_trans_rec.who_info.last_update_date
4516: , TRANSACTION_HEADER_ID_OUT = l_trans_rec.transaction_header_id
4517: WHERE ASSET_ID = p_asset_hdr_rec.asset_id

Line 4523: INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID

4519: AND set_of_books_id = p_asset_hdr_rec.set_of_books_id
4520: AND TRANSACTION_HEADER_ID_in = p_thid
4521: AND TRANSACTION_HEADER_ID_OUT is null;
4522:
4523: INSERT INTO FA_MC_BOOKS( SET_OF_BOOKS_ID
4524: , BOOK_TYPE_CODE
4525: , ASSET_ID
4526: , DATE_PLACED_IN_SERVICE
4527: , DATE_EFFECTIVE

Line 4755: FROM FA_MC_BOOKS

4751: , OVER_DEPRECIATE_OPTION
4752: , DISABLED_FLAG
4753: , CASH_GENERATING_UNIT_ID
4754: , RATE_IN_USE
4755: FROM FA_MC_BOOKS
4756: WHERE TRANSACTION_HEADER_ID_out = p_thid
4757: AND ASSET_ID = p_asset_hdr_rec.asset_id
4758: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4759: AND SET_OF_BOOKS_ID = p_asset_hdr_rec.set_of_books_id ;