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_UPG_PKG dependencies on FA_ADJUSTMENTS

Line 142: fa_adjustments adj,

138: from
139: fa_itf_impairments itf,
140: fa_impairments imp,
141: fa_transaction_headers th,
142: fa_adjustments adj,
143: fa_deprn_detail det
144: where itf.impairment_id = imp.impairment_id
145: and itf.impairment_id = th.mass_transaction_id
146: and th.transaction_header_id = adj.transaction_header_id

Line 171: fa_adjustments adj,

167: from
168: fa_itf_impairments itf,
169: fa_impairments imp,
170: fa_transaction_headers th,
171: fa_adjustments adj,
172: fa_deprn_summary su
173: where itf.impairment_id = imp.impairment_id
174: and itf.impairment_id = th.mass_transaction_id
175: and th.transaction_header_id = adj.transaction_header_id

Line 256: fa_adjustments adj,

252: from
253: FA_MC_ITF_IMPAIRMENTS itf,
254: FA_MC_IMPAIRMENTS imp,
255: fa_transaction_headers th,
256: fa_adjustments adj,
257: FA_MC_DEPRN_DETAIL det
258: where itf.impairment_id = imp.impairment_id
259: and itf.impairment_id = th.mass_transaction_id
260: and th.transaction_header_id = adj.transaction_header_id

Line 286: fa_adjustments adj,

282: from
283: FA_MC_ITF_IMPAIRMENTS itf,
284: FA_MC_IMPAIRMENTS imp,
285: fa_transaction_headers th,
286: fa_adjustments adj,
287: FA_MC_DEPRN_SUMMARY su
288: where itf.impairment_id = imp.impairment_id
289: and itf.impairment_id = th.mass_transaction_id
290: and th.transaction_header_id = adj.transaction_header_id

Line 375: from fa_adjustments

371: l_old_dist_gf := 0;
372: BEGIN
373: select NVL(SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',-1 * ADJUSTMENT_AMOUNT,ADJUSTMENT_AMOUNT)),0)
374: into l_reval_reserve_ca
375: from fa_adjustments
376: where asset_id = p_asset_id
377: and distribution_id = nvl(p_dist_id,distribution_id)
378: and period_counter_created = p_period_counter
379: and book_type_code = p_book_type_code

Line 395: from fa_adjustments

391:
392: BEGIN
393: select NVL(SUM(DECODE(DEBIT_CREDIT_FLAG,'DR',ADJUSTMENT_AMOUNT,-1 * ADJUSTMENT_AMOUNT)),0)
394: into l_nbv_retired_ca
395: from fa_adjustments
396: where asset_id = p_asset_id
397: and distribution_id = nvl(p_dist_id,distribution_id)
398: and period_counter_created = p_period_counter
399: and book_type_code = p_book_type_code