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

Line 2051: fa_mc_books_summary fbs,

2047: adj.period_counter_created,
2048: fbs.reval_loss_balance
2049: FROM
2050: FA_MC_ADJUSTMENTS adj,
2051: fa_mc_books_summary fbs,
2052: fa_transaction_headers fth
2053: WHERE adj.asset_id = p_asset_hdr_rec.asset_id
2054: AND adj.book_type_code = p_asset_hdr_rec.book_type_code
2055: AND adj.adjustment_type in ('REVAL LOSS','REVAL RESERVE')

Line 2279: update fa_mc_books_summary set reval_loss_balance = reval_loss_balance - (l_net_reval_loss + l_deprn_exp)

2275: where asset_id = p_asset_hdr_rec.asset_id
2276: and book_type_code = p_asset_hdr_rec.book_type_code
2277: and period_counter >= c_loss_period_counter ;
2278: ELSE
2279: update fa_mc_books_summary set reval_loss_balance = reval_loss_balance - (l_net_reval_loss + l_deprn_exp)
2280: where asset_id = p_asset_hdr_rec.asset_id
2281: and book_type_code = p_asset_hdr_rec.book_type_code
2282: and set_of_books_id = p_set_of_books_id
2283: and period_counter >= c_loss_period_counter ;

Line 2337: FROM FA_MC_BOOKS

2333: SELECT book_type_code,asset_id,recoverable_cost,salvage_value,adjusted_recoverable_cost,adjusted_cost,old_adjusted_cost,
2334: formula_factor,rate_Adjustment_factor,eofy_reserve,deprn_method_code,life_in_months,adjusted_rate,production_capacity,
2335: adjusted_capacity,bonus_rule,ceiling_name,reval_amortization_basis,date_placed_in_service,prorate_date,original_deprn_start_date,
2336: tracking_method,period_counter_life_complete,annual_deprn_rounding_flag
2337: FROM FA_MC_BOOKS
2338: WHERE TRANSACTION_HEADER_ID_OUT = p_th_id
2339: AND SET_OF_BOOKS_ID = p_set_of_books_id;
2340:
2341: CURSOR c_get_asset_rec Is

Line 2354: FROM FA_MC_BOOKS

2350: SELECT book_type_code,asset_id,recoverable_cost,salvage_value,adjusted_recoverable_cost,adjusted_cost,old_adjusted_cost,
2351: formula_factor,rate_Adjustment_factor,eofy_reserve,deprn_method_code,life_in_months,adjusted_rate,production_capacity,
2352: adjusted_capacity,bonus_rule,ceiling_name,reval_amortization_basis,date_placed_in_service,prorate_date,ORIGINAL_DEPRN_START_DATE,
2353: tracking_method,period_counter_life_complete,annual_deprn_rounding_flag
2354: FROM FA_MC_BOOKS
2355: WHERE TRANSACTION_HEADER_ID_IN = p_th_id
2356: AND SET_OF_BOOKS_ID = p_set_of_books_id;
2357:
2358: cursor c_get_fiscal_name is