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 267: FROM FA_ADJUSTMENTS_MRC_V ADJ

263: SELECT NVL(SUM(DECODE(ADJ.DEBIT_CREDIT_FLAG,
264: 'DR', ADJ.ADJUSTMENT_AMOUNT,
265: 'CR', -1*ADJ.ADJUSTMENT_AMOUNT)), 0), 1
266: INTO h_deprn_expense_adjs, h_dummy
267: FROM FA_ADJUSTMENTS_MRC_V ADJ
268: WHERE ADJ.ASSET_ID = x_adj_drs.asset_id
269: AND ADJ.BOOK_TYPE_CODE = x_adj_drs.book
270: AND ADJ.PERIOD_COUNTER_CREATED = h_curr_period_counter
271: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'

Line 278: FROM FA_ADJUSTMENTS_MRC_V ADJ

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

Line 292: FROM FA_ADJUSTMENTS ADJ

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

Line 303: FROM FA_ADJUSTMENTS ADJ

299: SELECT NVL(SUM(DECODE(ADJ.DEBIT_CREDIT_FLAG,
300: 'DR', ADJ.ADJUSTMENT_AMOUNT,
301: 'CR', -1*ADJ.ADJUSTMENT_AMOUNT)), 0), 1
302: INTO h_deprn_expense_adjs, h_dummy
303: FROM FA_ADJUSTMENTS ADJ
304: WHERE ADJ.ASSET_ID = x_adj_drs.asset_id
305: AND ADJ.BOOK_TYPE_CODE = x_adj_drs.book
306: AND ADJ.PERIOD_COUNTER_CREATED = h_curr_period_counter
307: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'

Line 1828: FROM FA_ADJUSTMENTS_MRC_V ADJ

1824: X_ADJ_ROW.reval_rsv,
1825: h_asset_clearing_adjs,
1826: h_cip_clearing_adjs,
1827: h_num_adjs
1828: FROM FA_ADJUSTMENTS_MRC_V ADJ
1829: WHERE ADJ.ASSET_ID in (select bk.asset_id
1830: from fa_books_mrc_v bk
1831: where bk.book_type_code = x_adj_row.book
1832: and bk.transaction_header_id_out is null

Line 1933: FROM FA_ADJUSTMENTS ADJ

1929: X_ADJ_ROW.reval_rsv,
1930: h_asset_clearing_adjs,
1931: h_cip_clearing_adjs,
1932: h_num_adjs
1933: FROM FA_ADJUSTMENTS ADJ
1934: WHERE ADJ.ASSET_ID in (select bk.asset_id
1935: from fa_books bk
1936: where bk.book_type_code = x_adj_row.book
1937: and bk.transaction_header_id_out is null

Line 2041: FROM FA_ADJUSTMENTS_MRC_V ADJ

2037: X_ADJ_ROW.reval_rsv,
2038: h_asset_clearing_adjs,
2039: h_cip_clearing_adjs,
2040: h_num_adjs
2041: FROM FA_ADJUSTMENTS_MRC_V ADJ
2042: WHERE ADJ.ASSET_ID = X_ADJ_ROW.asset_id AND
2043: ADJ.BOOK_TYPE_CODE = X_ADJ_ROW.book AND
2044: ADJ.PERIOD_COUNTER_CREATED > X_found_per_ctr AND
2045: DECODE(h_book_class,

Line 2142: FROM FA_ADJUSTMENTS ADJ

2138: X_ADJ_ROW.reval_rsv,
2139: h_asset_clearing_adjs,
2140: h_cip_clearing_adjs,
2141: h_num_adjs
2142: FROM FA_ADJUSTMENTS ADJ
2143: WHERE ADJ.ASSET_ID = X_ADJ_ROW.asset_id AND
2144: ADJ.BOOK_TYPE_CODE = X_ADJ_ROW.book AND
2145: ADJ.PERIOD_COUNTER_CREATED > X_found_per_ctr AND
2146: DECODE(h_book_class,