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.JL_CO_FA_ACCOUNTING_PKG dependencies on FA_RETIREMENTS

Line 244: x_corp_retirement_id fa_retirements.retirement_id%TYPE;

240: x_corp_ytd_deprn fa_deprn_summary.ytd_deprn%TYPE;
241: x_corp_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
242: x_corp_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
243:
244: x_corp_retirement_id fa_retirements.retirement_id%TYPE;
245: x_date_retired fa_retirements.date_retired%TYPE;
246: x_corp_cost_retired fa_retirements.cost_retired%TYPE;
247: x_corp_units_retired fa_retirements.units%TYPE;
248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;

Line 245: x_date_retired fa_retirements.date_retired%TYPE;

241: x_corp_reval_deprn_expense fa_deprn_summary.reval_deprn_expense%TYPE;
242: x_corp_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
243:
244: x_corp_retirement_id fa_retirements.retirement_id%TYPE;
245: x_date_retired fa_retirements.date_retired%TYPE;
246: x_corp_cost_retired fa_retirements.cost_retired%TYPE;
247: x_corp_units_retired fa_retirements.units%TYPE;
248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;
249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;

Line 246: x_corp_cost_retired fa_retirements.cost_retired%TYPE;

242: x_corp_reval_reserve fa_deprn_summary.reval_reserve%TYPE;
243:
244: x_corp_retirement_id fa_retirements.retirement_id%TYPE;
245: x_date_retired fa_retirements.date_retired%TYPE;
246: x_corp_cost_retired fa_retirements.cost_retired%TYPE;
247: x_corp_units_retired fa_retirements.units%TYPE;
248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;
249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;

Line 247: x_corp_units_retired fa_retirements.units%TYPE;

243:
244: x_corp_retirement_id fa_retirements.retirement_id%TYPE;
245: x_date_retired fa_retirements.date_retired%TYPE;
246: x_corp_cost_retired fa_retirements.cost_retired%TYPE;
247: x_corp_units_retired fa_retirements.units%TYPE;
248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;
249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;

Line 248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;

244: x_corp_retirement_id fa_retirements.retirement_id%TYPE;
245: x_date_retired fa_retirements.date_retired%TYPE;
246: x_corp_cost_retired fa_retirements.cost_retired%TYPE;
247: x_corp_units_retired fa_retirements.units%TYPE;
248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;
249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;
252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;

Line 249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;

245: x_date_retired fa_retirements.date_retired%TYPE;
246: x_corp_cost_retired fa_retirements.cost_retired%TYPE;
247: x_corp_units_retired fa_retirements.units%TYPE;
248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;
249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;
252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;
253: x_adj_units_retired fa_retirements.units%TYPE;

Line 250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;

246: x_corp_cost_retired fa_retirements.cost_retired%TYPE;
247: x_corp_units_retired fa_retirements.units%TYPE;
248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;
249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;
252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;
253: x_adj_units_retired fa_retirements.units%TYPE;
254: x_adj_nbv_retired fa_retirements.nbv_retired%TYPE;

Line 251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;

247: x_corp_units_retired fa_retirements.units%TYPE;
248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;
249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;
252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;
253: x_adj_units_retired fa_retirements.units%TYPE;
254: x_adj_nbv_retired fa_retirements.nbv_retired%TYPE;
255: x_adj_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;

Line 252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;

248: x_corp_nbv_retired fa_retirements.nbv_retired%TYPE;
249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;
252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;
253: x_adj_units_retired fa_retirements.units%TYPE;
254: x_adj_nbv_retired fa_retirements.nbv_retired%TYPE;
255: x_adj_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
256: x_adj_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;

Line 253: x_adj_units_retired fa_retirements.units%TYPE;

249: x_corp_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;
252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;
253: x_adj_units_retired fa_retirements.units%TYPE;
254: x_adj_nbv_retired fa_retirements.nbv_retired%TYPE;
255: x_adj_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
256: x_adj_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
257:

Line 254: x_adj_nbv_retired fa_retirements.nbv_retired%TYPE;

250: x_corp_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;
252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;
253: x_adj_units_retired fa_retirements.units%TYPE;
254: x_adj_nbv_retired fa_retirements.nbv_retired%TYPE;
255: x_adj_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
256: x_adj_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
257:
258: x_retirement_type VARCHAR2 (1);

Line 255: x_adj_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;

251: x_adj_retirement_id fa_retirements.retirement_id%TYPE;
252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;
253: x_adj_units_retired fa_retirements.units%TYPE;
254: x_adj_nbv_retired fa_retirements.nbv_retired%TYPE;
255: x_adj_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
256: x_adj_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
257:
258: x_retirement_type VARCHAR2 (1);
259: x_retirement_type_code fa_transaction_headers.transaction_type_code%TYPE;

Line 256: x_adj_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;

252: x_adj_cost_retired fa_retirements.cost_retired%TYPE;
253: x_adj_units_retired fa_retirements.units%TYPE;
254: x_adj_nbv_retired fa_retirements.nbv_retired%TYPE;
255: x_adj_reval_reserve_retired fa_retirements.reval_reserve_retired%TYPE;
256: x_adj_gain_loss_amount fa_retirements.gain_loss_amount%TYPE;
257:
258: x_retirement_type VARCHAR2 (1);
259: x_retirement_type_code fa_transaction_headers.transaction_type_code%TYPE;
260: x_source_transaction_header_id fa_transaction_headers.transaction_header_id%TYPE;

Line 659: FROM fa_retirements

655: nvl (units,0),
656: nvl (nbv_retired,0),
657: nvl (reval_reserve_retired,0),
658: nvl (gain_loss_amount,0)
659: FROM fa_retirements
660: WHERE transaction_header_id_in = pc_transaction_header_id ;
661:
662: -----------------------------------------------------------------------------
663: -- Get the cost and depreciation retired in a retirement transaction --

Line 676: FROM fa_retirements rt,

672: nvl (rt.reval_reserve_retired,0),
673: nvl (rt.gain_loss_amount,0),
674: dp.period_counter,
675: th.transaction_type_code
676: FROM fa_retirements rt,
677: fa_deprn_periods dp,
678: fa_transaction_headers th
679: WHERE rt.transaction_header_id_out = pc_transaction_header_id
680: AND dp.book_type_code = rt.book_type_code

Line 693: FROM fa_retirements

689:
690: CURSOR c_source_retirement (pc_transaction_header_id IN NUMBER)
691: IS
692: SELECT transaction_header_id_in
693: FROM fa_retirements
694: WHERE retirement_id = (SELECT retirement_id
695: FROM fa_distribution_history
696: WHERE distribution_id = (SELECT distribution_id
697: FROM fa_distribution_history