APPS.FA_XLA_EXTRACT_UTIL_PKG dependencies on FA_ADJUSTMENTS

Line 459: from fa_adjustments adj

455: and bc.book_type_code = te.source_id_char_1
456: and bc.set_of_books_id = te.ledger_id
457: and not exists
458: (select /*+ no_unnest */ 1
459: from fa_adjustments adj
460: where adj.transaction_header_id = th.transaction_header_id
461: and adj.book_type_code = bc.book_type_code
462: and adj.adjustment_amount <> 0
463: and nvl(adj.track_member_flag, 'N') <> 'Y')

Line 465: (select /*+ no_unnest leading(th2) index(adj FA_ADJUSTMENTS_U1) */ 1

461: and adj.book_type_code = bc.book_type_code
462: and adj.adjustment_amount <> 0
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

Line 466: from fa_adjustments adj,

462: and adj.adjustment_amount <> 0
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

Line 508: from fa_adjustments adj

504: and bc.book_type_code = te.source_id_char_1
505: and bc.set_of_books_id = te.ledger_id
506: and not exists
507: (select /*+ no_unnest */ 1
508: from fa_adjustments adj
509: where adj.transaction_header_id = th.transaction_header_id
510: and adj.book_type_code = bc.book_type_code
511: and adj.adjustment_amount <> 0
512: and nvl(adj.track_member_flag, 'N') <> 'Y');

Line 554: from fa_adjustments adj

550: and bc.book_type_code = te.source_id_char_1
551: and bc.set_of_books_id = te.ledger_id
552: and not exists
553: (select /*+ no_unnest */ 1
554: from fa_adjustments adj
555: where adj.transaction_header_id in
556: (trx.src_transaction_header_id, trx.dest_transaction_header_id)
557: and adj.book_type_code = bc.book_type_code
558: and adj.adjustment_amount <> 0

Line 561: (select /*+ no_unnest leading(th2) index(adj FA_ADJUSTMENTS_U1) */ 1

557: and adj.book_type_code = bc.book_type_code
558: and adj.adjustment_amount <> 0
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)

Line 562: from fa_adjustments adj,

558: and adj.adjustment_amount <> 0
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