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

Line 280: FROM FA_ADJUSTMENTS ADJ

276: SELECT NVL(SUM(DECODE(ADJ.DEBIT_CREDIT_FLAG,
277: 'DR', ADJ.ADJUSTMENT_AMOUNT,
278: 'CR', -1*ADJ.ADJUSTMENT_AMOUNT)), 0), 1
279: INTO h_deprn_expense_adjs, h_dummy
280: FROM FA_ADJUSTMENTS ADJ
281: WHERE ADJ.ASSET_ID = x_adj_drs.asset_id
282: AND ADJ.BOOK_TYPE_CODE = x_adj_drs.book
283: AND ADJ.PERIOD_COUNTER_CREATED = h_curr_period_counter
284: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'

Line 291: FROM FA_ADJUSTMENTS ADJ

287: SELECT NVL(SUM(DECODE(ADJ.DEBIT_CREDIT_FLAG,
288: 'DR', ADJ.ADJUSTMENT_AMOUNT,
289: 'CR', -1*ADJ.ADJUSTMENT_AMOUNT)), 0), 1
290: INTO h_deprn_expense_adjs, h_dummy
291: FROM FA_ADJUSTMENTS ADJ
292: WHERE ADJ.ASSET_ID = x_adj_drs.asset_id
293: AND ADJ.BOOK_TYPE_CODE = x_adj_drs.book
294: AND ADJ.PERIOD_COUNTER_CREATED = h_curr_period_counter
295: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'

Line 2108: FROM FA_ADJUSTMENTS ADJ

2104: h_cip_clearing_adjs,
2105: X_ADJ_ROW.capital_adjustment, --Bug 6666666
2106: X_ADJ_ROW.general_fund, --Bug 6666666
2107: h_num_adjs
2108: FROM FA_ADJUSTMENTS ADJ
2109: WHERE ADJ.ASSET_ID in (select bk.asset_id
2110: from fa_books bk
2111: where bk.book_type_code = x_adj_row.book
2112: and bk.transaction_header_id_out is null

Line 2412: FROM FA_ADJUSTMENTS ADJ

2408: X_ADJ_ROW.capital_adjustment, --Bug 6666666
2409: X_ADJ_ROW.general_fund, --Bug 6666666
2410: X_ADJ_ROW.reval_loss_balance,
2411: h_num_adjs
2412: FROM FA_ADJUSTMENTS ADJ
2413: WHERE ADJ.ASSET_ID = X_ADJ_ROW.asset_id AND
2414: ADJ.BOOK_TYPE_CODE = X_ADJ_ROW.book AND
2415: ADJ.PERIOD_COUNTER_CREATED > X_found_per_ctr AND
2416: DECODE(h_book_class,