APPS.FA_XLA_EXTRACT_UTIL_PKG dependencies on FA_TRANSACTION_HEADERS

Line 357: fa_transaction_headers th,

353: 'TRANSACTIONS',
354: bc.book_type_code
355: from xla_transaction_entities te,
356: xla_events ev,
357: fa_transaction_headers th,
358: fa_book_controls bc
359: where te.application_id = l_appl_id
360: and te.ledger_id = bc.set_of_books_id
361: and te.entity_code = 'TRANSACTIONS'

Line 403: fa_transaction_headers th2

399: and nvl(adj.track_member_flag, 'N') <> 'Y')
400: and not exists
401: (select /*+ no_unnest index(adj FA_ADJUSTMENTS_U1) */ 1
402: from fa_adjustments adj,
403: fa_transaction_headers th2
404: where th2.member_transaction_header_id = th.transaction_header_id
405: and adj.transaction_header_id = th2.transaction_header_id
406: and adj.book_type_code = bc.book_type_code
407: and adj.adjustment_amount <> 0

Line 465: fa_transaction_headers th2

461: and nvl(adj.track_member_flag, 'N') <> 'Y')
462: and not exists
463: (select /*+ no_unnest index(adj FA_ADJUSTMENTS_U1) */ 1
464: from fa_adjustments adj,
465: fa_transaction_headers th2
466: where th2.member_transaction_header_id in
467: (trx.src_transaction_header_id, trx.dest_transaction_header_id)
468: and adj.transaction_header_id = th2.transaction_header_id
469: and adj.book_type_code = bc.book_type_code