APPS.FA_QUERY_BALANCES_PKG dependencies on FA_ADJUSTMENTS_MRC_V

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 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 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,