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_ADJUSTMENTS

Line 88: from fa_adjustments

84: Cursor c_get_deprn_rsv_out(c_period_counter_impaired number) is
85: select SUM(decode(ADJUSTMENT_TYPE,'RESERVE',adjustment_amount,0)),
86: sum(decode(ADJUSTMENT_TYPE,'EXPENSE',adjustment_amount,0)),
87: PERIOD_COUNTER_CREATED
88: from fa_adjustments
89: where asset_id = p_asset_id AND
90: book_type_code = p_book_type_code AND
91: PERIOD_COUNTER_CREATED >= c_period_counter_impaired and
92: SOURCE_TYPE_CODE='REVALUATION'

Line 2021: FA_ADJUSTMENTS adj,

2017: sum(adj.adjustment_amount),
2018: adj.period_counter_created,
2019: fbs.reval_loss_balance
2020: FROM
2021: FA_ADJUSTMENTS adj,
2022: fa_books_summary fbs,
2023: fa_transaction_headers fth
2024: WHERE adj.asset_id = p_asset_hdr_rec.asset_id
2025: AND adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 2092: FA_ADJUSTMENTS adj

2088:
2089: CURSOR c_get_sum_reval_losses is
2090: SELECT sum(adj.adjustment_amount)
2091: FROM
2092: FA_ADJUSTMENTS adj
2093: WHERE adj.asset_id = p_asset_hdr_rec.asset_id
2094: AND adj.book_type_code = p_asset_hdr_rec.book_type_code
2095: AND adj.adjustment_type = 'REVAL LOSS'
2096: AND adj.debit_credit_flag = 'DR'