DBA Data[Home] [Help]

APPS.FA_BALREP_PKG dependencies on FA_ADJUSTMENTS_MRC_V

Line 205: fa_adjustments_mrc_v aj,

201: h_request_id
202: FROM fa_distribution_history dh,
203: fa_transaction_headers th,
204: fa_asset_history ah,
205: fa_adjustments_mrc_v aj,
206: fa_deprn_periods dp
207: WHERE dh.book_type_code = distribution_source_book
208: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
209: AND aj.asset_id = dh.asset_id

Line 247: fa_adjustments_mrc_v aj,

243: h_request_id
244: FROM fa_distribution_history dh,
245: fa_transaction_headers th,
246: fa_asset_history ah,
247: fa_adjustments_mrc_v aj,
248: fa_deprn_periods dp
249: /* SLA Changes */,
250: xla_ae_headers headers,
251: xla_ae_lines lines,

Line 434: fa_adjustments_mrc_v aj,

430: h_request_id
431: FROM fa_distribution_history dh,
432: fa_transaction_headers th,
433: fa_asset_history ah,
434: fa_adjustments_mrc_v aj,
435: fa_deprn_periods dp
436: WHERE dh.book_type_code = distribution_source_book
437: AND dh.asset_id BETWEEN start_range AND end_range --Anuj
438: AND aj.asset_id = dh.asset_id

Line 486: fa_adjustments_mrc_v aj,

482: h_request_id
483: FROM fa_distribution_history dh,
484: fa_transaction_headers th,
485: fa_asset_history ah,
486: fa_adjustments_mrc_v aj,
487: fa_deprn_periods dp
488: /* SLA Changes */,
489: xla_ae_headers headers,
490: xla_ae_lines lines,

Line 845: FROM fa_adjustments_mrc_v aj,

841: aj.source_type_code,
842: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
843: aj.adjustment_amount),
844: h_request_id
845: FROM fa_adjustments_mrc_v aj,
846: fa_books_mrc_v bk,
847: fa_group_asset_default gad,
848: fa_deprn_periods dp
849: WHERE bk.asset_id = aj.asset_id

Line 895: FROM fa_adjustments_mrc_v aj,

891: aj.source_type_code,
892: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
893: aj.adjustment_amount),
894: h_request_id
895: FROM fa_adjustments_mrc_v aj,
896: fa_books_mrc_v bk,
897: fa_group_asset_default gad,
898: fa_deprn_periods dp
899: /* SLA Changes */,

Line 2438: fa_adjustments_mrc_v adj

2434: fa_distribution_history dh,
2435: fa_asset_history ah,
2436: fa_deprn_detail_mrc_v dd,
2437: fa_deprn_periods_mrc_v dp,
2438: fa_adjustments_mrc_v adj
2439: WHERE dh.book_type_code = distribution_source_book
2440: AND ah.asset_id = dd.asset_id
2441: AND ah.asset_type IN ('CAPITALIZED', 'CIP')
2442: AND ah.date_effective < nvl(dh.date_ineffective, SYSDATE)