APPS.FA_XLA_EXTRACT_UTIL_PKG dependencies on FA_ADJUSTMENTS

Line 395: from fa_adjustments adj

391: and th.transaction_header_id = te.source_id_int_1
392: and bc.book_type_code = p_book_type_code
393: and not exists
394: (select /*+ no_unnest */ 1
395: from fa_adjustments adj
396: where adj.transaction_header_id = th.transaction_header_id
397: and adj.book_type_code = bc.book_type_code
398: and adj.adjustment_amount <> 0
399: and nvl(adj.track_member_flag, 'N') <> 'Y')

Line 401: (select /*+ no_unnest index(adj FA_ADJUSTMENTS_U1) */ 1

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

Line 402: from fa_adjustments adj,

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

Line 456: from fa_adjustments adj

452: and trx.trx_reference_id = te.source_id_int_1
453: and bc.book_type_code = p_book_type_code
454: and not exists
455: (select /*+ no_unnest */ 1
456: from fa_adjustments adj
457: where adj.transaction_header_id in
458: (trx.src_transaction_header_id, trx.dest_transaction_header_id)
459: and adj.book_type_code = bc.book_type_code
460: and adj.adjustment_amount <> 0

Line 463: (select /*+ no_unnest index(adj FA_ADJUSTMENTS_U1) */ 1

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

Line 464: from fa_adjustments adj,

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