DBA Data[Home] [Help]

APPS.FA_BALREP_PKG dependencies on FA_TRANSACTION_HEADERS

Line 203: fa_transaction_headers th,

199: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
200: aj.adjustment_amount),
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

Line 245: fa_transaction_headers th,

241: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
242: aj.adjustment_amount),
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 */,

Line 314: fa_transaction_headers th,

310: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
311: aj.adjustment_amount),
312: h_request_id
313: FROM fa_distribution_history dh,
314: fa_transaction_headers th,
315: fa_asset_history ah,
316: fa_adjustments aj,
317: fa_deprn_periods dp
318: WHERE dh.book_type_code = distribution_source_book

Line 358: fa_transaction_headers th,

354: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
355: aj.adjustment_amount),
356: h_request_id
357: FROM fa_distribution_history dh,
358: fa_transaction_headers th,
359: fa_asset_history ah,
360: fa_adjustments aj,
361: fa_deprn_periods dp
362: /* SLA Changes */,

Line 432: fa_transaction_headers th,

428: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
429: aj.adjustment_amount),
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

Line 484: fa_transaction_headers th,

480: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
481: aj.adjustment_amount),
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 */,

Line 562: fa_transaction_headers th,

558: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
559: aj.adjustment_amount),
560: h_request_id
561: FROM fa_distribution_history dh,
562: fa_transaction_headers th,
563: fa_asset_history ah,
564: fa_adjustments aj,
565: fa_deprn_periods dp
566:

Line 615: fa_transaction_headers th,

611: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
612: aj.adjustment_amount),
613: h_request_id
614: FROM fa_distribution_history dh,
615: fa_transaction_headers th,
616: fa_asset_history ah,
617: fa_adjustments aj,
618: fa_deprn_periods dp
619: /* SLA Changes */,