DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_UTIL_PKG dependencies on FA_TRANSACTION_HEADERS

Line 443: fa_transaction_headers th,

439: 'TRANSACTIONS',
440: bc.book_type_code
441: from xla_transaction_entities te,
442: xla_events ev,
443: fa_transaction_headers th,
444: fa_book_controls bc
445: where te.application_id = l_appl_id
446: and te.ledger_id = p_ledger_id
447: and te.entity_code = 'TRANSACTIONS'

Line 467: fa_transaction_headers th2

463: and nvl(adj.track_member_flag, 'N') <> 'Y')
464: and not exists
465: (select /*+ no_unnest leading(th2) index(adj FA_ADJUSTMENTS_U1) */ 1
466: from fa_adjustments adj,
467: fa_transaction_headers th2
468: where th2.member_transaction_header_id = th.transaction_header_id
469: and adj.transaction_header_id = th2.transaction_header_id
470: and adj.book_type_code = bc.book_type_code
471: and adj.adjustment_amount <> 0

Line 492: fa_transaction_headers th,

488: 'TRANSACTIONS',
489: bc.book_type_code
490: from xla_transaction_entities te,
491: xla_events ev,
492: fa_transaction_headers th,
493: fa_book_controls bc
494: where te.application_id = l_appl_id
495: and te.ledger_id = p_ledger_id
496: and te.entity_code = 'TRANSACTIONS'

Line 563: fa_transaction_headers th2

559: and nvl(adj.track_member_flag, 'N') <> 'Y')
560: and not exists
561: (select /*+ no_unnest leading(th2) index(adj FA_ADJUSTMENTS_U1) */ 1
562: from fa_adjustments adj,
563: fa_transaction_headers th2
564: where th2.member_transaction_header_id in
565: (trx.src_transaction_header_id, trx.dest_transaction_header_id)
566: and adj.transaction_header_id = th2.transaction_header_id
567: and adj.book_type_code = bc.book_type_code