CE_RECON_HISTORY_ITEMS

Details

Schema: FUSION
Object owner: CE
Object type: VIEW

Columns

Name
RECON_HISTORY_ITEM_ID RECON_HISTORY_ID RECON_SOURCE SOURCE_ID JOURNAL_NAME JOURNAL_BATCH_NAME SOURCE_LINE_ID BANK_ACCOUNT_ID STATEMENT_NUMBER RECON_REFERENCE TRX_DATE AMOUNT TRX_TYPE TRX_TYPE_CODE RECON_SOURCE_MEANING IS_HISTORY_ITEM BA_CURRENCY_CODE STATEMENT_HEADER_ID TRANSACTION_NUMBER BATCH_NAME PAYMENT_INSTRUCTION_ID RECEIPT_BATCH_NAME

Name

RECON_HISTORY_ITEM_ID

RECON_HISTORY_ID

RECON_SOURCE

SOURCE_ID

JOURNAL_NAME

JOURNAL_BATCH_NAME

SOURCE_LINE_ID

BANK_ACCOUNT_ID

STATEMENT_NUMBER

RECON_REFERENCE

TRX_DATE

AMOUNT

TRX_TYPE

TRX_TYPE_CODE

RECON_SOURCE_MEANING

IS_HISTORY_ITEM

BA_CURRENCY_CODE

STATEMENT_HEADER_ID

TRANSACTION_NUMBER

BATCH_NAME

PAYMENT_INSTRUCTION_ID

RECEIPT_BATCH_NAME

Query

SQL_Statement
SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID, ReconHistoryItemEO.RECON_HISTORY_ID, ReconHistoryItemEO.RECON_SOURCE, ReconHistoryItemEO.SOURCE_ID, NULL JOURNAL_NAME, NULL JOURNAL_BATCH_NAME, ReconHistoryItemEO.SOURCE_LINE_ID, bsh.bank_account_id, bsh.statement_number, bsl.recon_reference recon_reference, bsl.booking_date trx_date, DECODE(NVL(bsl.flow_indicator, 'CRDT'), 'DBIT', -bsl.AMOUNT, bsl.AMOUNT) amount, type_lookup.meaning trx_type, type_lookup.lookup_code trx_type_code, source_lookup.meaning recon_source_meaning, 'Y' is_history_item, ce_ba.currency_code ba_currency_code, bsh.statement_header_id statement_header_id, NULL transaction_number, NULL BATCH_NAME, NULL PAYMENT_INSTRUCTION_ID, NULL RECEIPT_BATCH_NAME FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO, ce_statement_headers bsh, ce_statement_lines bsl, ce_lookups source_lookup, ce_lookups type_lookup, ce_bank_accounts ce_ba WHERE bsl.statement_line_id = ReconHistoryItemEO.source_id AND ReconHistoryItemEO.recon_source = 'BS' AND bsh.statement_header_id = bsl.statement_header_id AND source_lookup.lookup_type = 'CE_RECON_SOURCE' AND source_lookup.lookup_code = ReconHistoryItemEO.recon_source AND type_lookup.lookup_code = bsl.trx_type AND type_lookup.lookup_type = 'CE_TRX_TYPE' AND ce_ba.bank_account_id = bsh.bank_account_id UNION ALL SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID, ReconHistoryItemEO.RECON_HISTORY_ID, ReconHistoryItemEO.RECON_SOURCE, ReconHistoryItemEO.SOURCE_ID, NULL JOURNAL_NAME, NULL JOURNAL_BATCH_NAME, ReconHistoryItemEO.SOURCE_LINE_ID, use.bank_account_id, NULL statement_number, TO_CHAR(ap.check_number) recon_reference, ap.check_date trx_date, ReconHistoryItemEO.cleared_amount amount, type_lookup.meaning trx_type, map.trx_type trx_type_code, lookup.meaning recon_source_meaning, 'Y' is_history_item, ce_ba.currency_code ba_currency_code, NULL statement_header_id, NULL transaction_number, NULL BATCH_NAME, ap.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID, NULL RECEIPT_BATCH_NAME FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO, ap_checks_all ap, ce_bank_acct_uses_all use, ce_trx_type_mapping map, ce_lookups lookup, ce_lookups type_lookup, ce_bank_accounts ce_ba WHERE ap.check_id = ReconHistoryItemEO.source_id AND ReconHistoryItemEO.recon_source = 'AP' AND map.PMT_RCT_METHOD(+) = ap.payment_method_lookup_code AND use.bank_acct_use_id = ap.ce_bank_acct_use_id AND lookup.lookup_type = 'CE_RECON_SOURCE' AND lookup.lookup_code = ReconHistoryItemEO.recon_source AND type_lookup.lookup_code (+) = map.trx_type AND type_lookup.lookup_type (+) = 'CE_TRX_TYPE' AND ce_ba.bank_account_id = use.bank_account_id UNION ALL SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID, ReconHistoryItemEO.RECON_HISTORY_ID, ReconHistoryItemEO.RECON_SOURCE, ReconHistoryItemEO.SOURCE_ID, NULL JOURNAL_NAME, NULL JOURNAL_BATCH_NAME, ReconHistoryItemEO.SOURCE_LINE_ID, ce_bau.bank_account_id bank_account_id, NULL statement_number, ar.receipt_number recon_reference, NVL(ar.deposit_date, ar.receipt_date) trx_date, ReconHistoryItemEO.cleared_amount amount, type_lookup.meaning trx_type, map.trx_type trx_type_code, lookup.meaning recon_source_meaning, 'Y' is_history_item, ce_ba.currency_code ba_currency_code, NULL statement_header_id, NULL transaction_number, ar_b.NAME BATCH_NAME, NULL PAYMENT_INSTRUCTION_ID, lockbox.NAME RECEIPT_BATCH_NAME FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO, ar_cash_receipts_all ar, ar_receipt_methods ar_m, ce_trx_type_mapping map, ce_lookups lookup, ce_lookups type_lookup, ce_bank_acct_uses_all ce_bau, ce_bank_accounts ce_ba, ar_batches_all ar_b, ar_batches_all lockbox WHERE ar.cash_receipt_id = ReconHistoryItemEO.source_id AND ReconHistoryItemEO.recon_source = 'AR' AND map.PMT_RCT_METHOD(+) = ar_m.name AND ar_m.receipt_method_id = ar.receipt_method_id AND lookup.lookup_type = 'CE_RECON_SOURCE' AND lookup.lookup_code = ReconHistoryItemEO.recon_source AND type_lookup.lookup_code (+) = map.trx_type AND type_lookup.lookup_type (+) = 'CE_TRX_TYPE' AND ce_bau.bank_acct_use_id = ar.remit_bank_acct_use_id AND ce_ba.bank_account_id = ce_bau.bank_account_id AND ar_b.org_id(+) = ar.org_id AND ar_b.batch_id (+) = ar.REMITTANCE_BATCH_ID AND lockbox.batch_id (+) = ar.RECEIPT_BATCH_ID AND lockbox.type (+) = 'MANUAL' UNION ALL SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID, ReconHistoryItemEO.RECON_HISTORY_ID, ReconHistoryItemEO.RECON_SOURCE, ReconHistoryItemEO.SOURCE_ID, NULL JOURNAL_NAME, NULL JOURNAL_BATCH_NAME, ReconHistoryItemEO.SOURCE_LINE_ID, ext.bank_account_id, NULL statement_number, ext.reference_text recon_reference, ext.transaction_date trx_date, ReconHistoryItemEO.cleared_amount amount, type_lookup.meaning trx_type, ext.transaction_type trx_type_code, lookup.meaning recon_source_meaning, 'Y' is_history_item, ext.currency_code ba_currency_code, NULL statement_header_id, ext.transaction_id transaction_number, NULL BATCH_NAME, NULL PAYMENT_INSTRUCTION_ID, NULL RECEIPT_BATCH_NAME FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO, ce_external_transactions ext, ce_lookups lookup, ce_lookups type_lookup WHERE ext.external_transaction_id = ReconHistoryItemEO.source_id AND ReconHistoryItemEO.recon_source = 'XT' AND lookup.lookup_type = 'CE_RECON_SOURCE' AND lookup.lookup_code = ReconHistoryItemEO.recon_source AND type_lookup.lookup_code (+) = ext.transaction_type AND type_lookup.lookup_type (+) = 'CE_TRX_TYPE' UNION ALL SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID, ReconHistoryItemEO.RECON_HISTORY_ID, ReconHistoryItemEO.RECON_SOURCE, ReconHistoryItemEO.SOURCE_ID, NULL JOURNAL_NAME, NULL JOURNAL_BATCH_NAME, ReconHistoryItemEO.SOURCE_LINE_ID, pay.payer_bank_account_id bank_account_id, NULL statement_number, pay.check_number recon_reference, pay.payment_date trx_date, ReconHistoryItemEO.cleared_amount amount, type_lookup.meaning trx_type, map.trx_type trx_type_code, lookup.meaning recon_source_meaning, 'Y' is_history_item, ce_ba.currency_code ba_currency_code, NULL statement_header_id, NULL transaction_number, pfi.instance_name BATCH_NAME, NULL PAYMENT_INSTRUCTION_ID, NULL RECEIPT_BATCH_NAME FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO, pay_ce_transactions pay, ce_trx_type_mapping map, ce_lookups lookup, ce_lookups type_lookup, ce_bank_accounts ce_ba, pay_payroll_actions ppa, (select distinct pay_request_id, flow_instance_id from pay_requests) pr_dist, pay_flow_instances pfi WHERE pay.payroll_rel_action_id = ReconHistoryItemEO.source_id AND ReconHistoryItemEO.recon_source = 'PR' AND map.pay_payment_type_id(+) = pay.payment_type_id AND lookup.lookup_type = 'CE_RECON_SOURCE' AND lookup.lookup_code = ReconHistoryItemEO.recon_source AND type_lookup.lookup_code (+) = map.trx_type AND type_lookup.lookup_type (+) = 'CE_TRX_TYPE' AND ce_ba.bank_account_id = pay.payer_bank_account_id AND pay.payroll_action_id = ppa.payroll_action_id AND ppa.pay_request_id = pr_dist.pay_request_id AND pr_dist.flow_instance_id = pfi.flow_instance_id UNION ALL SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID, ReconHistoryItemEO.RECON_HISTORY_ID, ReconHistoryItemEO.RECON_SOURCE, ReconHistoryItemEO.SOURCE_ID, GL_JEH.NAME JOURNAL_NAME, GL_JEB.NAME JOURNAL_BATCH_NAME, ReconHistoryItemEO.SOURCE_LINE_ID, ReconHistory.bank_account_id, NULL statement_number, TO_CHAR(GL_JEL_REC.jgzz_recon_ref) recon_reference, Trunc(GL_JEL.effective_date) trx_date, ReconHistoryItemEO.cleared_amount amount, null trx_type, NULL trx_type_code, lookup.meaning recon_source_meaning, 'Y' is_history_item, ce_ba.currency_code, NULL statement_header_id, NULL transaction_number, NULL BATCH_NAME, NULL PAYMENT_INSTRUCTION_ID, NULL RECEIPT_BATCH_NAME FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO, CE_RECON_HISTORY ReconHistory, gl_je_lines GL_JEL, gl_je_lines_recon GL_JEL_REC, gl_je_batches GL_JEB, gl_je_headers GL_JEH, ce_lookups lookup, ce_internal_bank_accts_v ce_ba WHERE GL_JEL.je_header_id = ReconHistoryItemEO.source_id AND ReconHistory.RECON_HISTORY_ID = ReconHistoryItemEO.RECON_HISTORY_ID AND GL_JEB.je_batch_id = GL_JEH.je_batch_id AND GL_JEH.je_header_id = GL_JEL.je_header_id AND CE_BA.bank_account_id = ReconHistory.bank_account_id AND GL_JEL.je_line_num = ReconHistoryItemEO.SOURCE_LINE_ID AND ReconHistoryItemEO.recon_source = 'ORA_GL' AND lookup.lookup_type = 'CE_RECON_SOURCE' AND lookup.lookup_code = ReconHistoryItemEO.recon_source AND GL_JEL_REC.je_header_id (+) = GL_JEL.je_header_id AND GL_JEL_REC.je_line_num (+) = GL_JEL.je_line_num

SQL_Statement

SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID,

ReconHistoryItemEO.RECON_HISTORY_ID,

ReconHistoryItemEO.RECON_SOURCE,

ReconHistoryItemEO.SOURCE_ID,

NULL JOURNAL_NAME,

NULL JOURNAL_BATCH_NAME,

ReconHistoryItemEO.SOURCE_LINE_ID,

bsh.bank_account_id,

bsh.statement_number,

bsl.recon_reference recon_reference,

bsl.booking_date trx_date,

DECODE(NVL(bsl.flow_indicator, 'CRDT'), 'DBIT', -bsl.AMOUNT, bsl.AMOUNT) amount,

type_lookup.meaning trx_type,

type_lookup.lookup_code trx_type_code,

source_lookup.meaning recon_source_meaning,

'Y' is_history_item,

ce_ba.currency_code ba_currency_code,

bsh.statement_header_id statement_header_id,

NULL transaction_number,

NULL BATCH_NAME,

NULL PAYMENT_INSTRUCTION_ID,

NULL RECEIPT_BATCH_NAME

FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO,

ce_statement_headers bsh,

ce_statement_lines bsl,

ce_lookups source_lookup,

ce_lookups type_lookup,

ce_bank_accounts ce_ba

WHERE bsl.statement_line_id = ReconHistoryItemEO.source_id

AND ReconHistoryItemEO.recon_source = 'BS'

AND bsh.statement_header_id = bsl.statement_header_id

AND source_lookup.lookup_type = 'CE_RECON_SOURCE'

AND source_lookup.lookup_code = ReconHistoryItemEO.recon_source

AND type_lookup.lookup_code = bsl.trx_type

AND type_lookup.lookup_type = 'CE_TRX_TYPE'

AND ce_ba.bank_account_id = bsh.bank_account_id

UNION ALL

SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID,

ReconHistoryItemEO.RECON_HISTORY_ID,

ReconHistoryItemEO.RECON_SOURCE,

ReconHistoryItemEO.SOURCE_ID,

NULL JOURNAL_NAME,

NULL JOURNAL_BATCH_NAME,

ReconHistoryItemEO.SOURCE_LINE_ID,

use.bank_account_id,

NULL statement_number,

TO_CHAR(ap.check_number) recon_reference,

ap.check_date trx_date,

ReconHistoryItemEO.cleared_amount amount,

type_lookup.meaning trx_type,

map.trx_type trx_type_code,

lookup.meaning recon_source_meaning,

'Y' is_history_item,

ce_ba.currency_code ba_currency_code,

NULL statement_header_id,

NULL transaction_number,

NULL BATCH_NAME,

ap.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID,

NULL RECEIPT_BATCH_NAME

FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO,

ap_checks_all ap,

ce_bank_acct_uses_all use,

ce_trx_type_mapping map,

ce_lookups lookup,

ce_lookups type_lookup,

ce_bank_accounts ce_ba

WHERE ap.check_id = ReconHistoryItemEO.source_id

AND ReconHistoryItemEO.recon_source = 'AP'

AND map.PMT_RCT_METHOD(+) = ap.payment_method_lookup_code

AND use.bank_acct_use_id = ap.ce_bank_acct_use_id

AND lookup.lookup_type = 'CE_RECON_SOURCE'

AND lookup.lookup_code = ReconHistoryItemEO.recon_source

AND type_lookup.lookup_code (+) = map.trx_type

AND type_lookup.lookup_type (+) = 'CE_TRX_TYPE'

AND ce_ba.bank_account_id = use.bank_account_id

UNION ALL

SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID,

ReconHistoryItemEO.RECON_HISTORY_ID,

ReconHistoryItemEO.RECON_SOURCE,

ReconHistoryItemEO.SOURCE_ID,

NULL JOURNAL_NAME,

NULL JOURNAL_BATCH_NAME,

ReconHistoryItemEO.SOURCE_LINE_ID,

ce_bau.bank_account_id bank_account_id,

NULL statement_number,

ar.receipt_number recon_reference,

NVL(ar.deposit_date, ar.receipt_date) trx_date,

ReconHistoryItemEO.cleared_amount amount,

type_lookup.meaning trx_type,

map.trx_type trx_type_code,

lookup.meaning recon_source_meaning,

'Y' is_history_item,

ce_ba.currency_code ba_currency_code,

NULL statement_header_id,

NULL transaction_number,

ar_b.NAME BATCH_NAME,

NULL PAYMENT_INSTRUCTION_ID,

lockbox.NAME RECEIPT_BATCH_NAME

FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO,

ar_cash_receipts_all ar,

ar_receipt_methods ar_m,

ce_trx_type_mapping map,

ce_lookups lookup,

ce_lookups type_lookup,

ce_bank_acct_uses_all ce_bau,

ce_bank_accounts ce_ba,

ar_batches_all ar_b,

ar_batches_all lockbox

WHERE ar.cash_receipt_id = ReconHistoryItemEO.source_id

AND ReconHistoryItemEO.recon_source = 'AR'

AND map.PMT_RCT_METHOD(+) = ar_m.name

AND ar_m.receipt_method_id = ar.receipt_method_id

AND lookup.lookup_type = 'CE_RECON_SOURCE'

AND lookup.lookup_code = ReconHistoryItemEO.recon_source

AND type_lookup.lookup_code (+) = map.trx_type

AND type_lookup.lookup_type (+) = 'CE_TRX_TYPE'

AND ce_bau.bank_acct_use_id = ar.remit_bank_acct_use_id

AND ce_ba.bank_account_id = ce_bau.bank_account_id

AND ar_b.org_id(+) = ar.org_id

AND ar_b.batch_id (+) = ar.REMITTANCE_BATCH_ID

AND lockbox.batch_id (+) = ar.RECEIPT_BATCH_ID

AND lockbox.type (+) = 'MANUAL'

UNION ALL

SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID,

ReconHistoryItemEO.RECON_HISTORY_ID,

ReconHistoryItemEO.RECON_SOURCE,

ReconHistoryItemEO.SOURCE_ID,

NULL JOURNAL_NAME,

NULL JOURNAL_BATCH_NAME,

ReconHistoryItemEO.SOURCE_LINE_ID,

ext.bank_account_id,

NULL statement_number,

ext.reference_text recon_reference,

ext.transaction_date trx_date,

ReconHistoryItemEO.cleared_amount amount,

type_lookup.meaning trx_type,

ext.transaction_type trx_type_code,

lookup.meaning recon_source_meaning,

'Y' is_history_item,

ext.currency_code ba_currency_code,

NULL statement_header_id,

ext.transaction_id transaction_number,

NULL BATCH_NAME,

NULL PAYMENT_INSTRUCTION_ID,

NULL RECEIPT_BATCH_NAME

FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO,

ce_external_transactions ext,

ce_lookups lookup,

ce_lookups type_lookup

WHERE ext.external_transaction_id = ReconHistoryItemEO.source_id

AND ReconHistoryItemEO.recon_source = 'XT'

AND lookup.lookup_type = 'CE_RECON_SOURCE'

AND lookup.lookup_code = ReconHistoryItemEO.recon_source

AND type_lookup.lookup_code (+) = ext.transaction_type

AND type_lookup.lookup_type (+) = 'CE_TRX_TYPE'

UNION ALL

SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID,

ReconHistoryItemEO.RECON_HISTORY_ID,

ReconHistoryItemEO.RECON_SOURCE,

ReconHistoryItemEO.SOURCE_ID,

NULL JOURNAL_NAME,

NULL JOURNAL_BATCH_NAME,

ReconHistoryItemEO.SOURCE_LINE_ID,

pay.payer_bank_account_id bank_account_id,

NULL statement_number,

pay.check_number recon_reference,

pay.payment_date trx_date,

ReconHistoryItemEO.cleared_amount amount,

type_lookup.meaning trx_type,

map.trx_type trx_type_code,

lookup.meaning recon_source_meaning,

'Y' is_history_item,

ce_ba.currency_code ba_currency_code,

NULL statement_header_id,

NULL transaction_number,

pfi.instance_name BATCH_NAME,

NULL PAYMENT_INSTRUCTION_ID,

NULL RECEIPT_BATCH_NAME

FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO,

pay_ce_transactions pay,

ce_trx_type_mapping map,

ce_lookups lookup,

ce_lookups type_lookup,

ce_bank_accounts ce_ba,

pay_payroll_actions ppa,

(select distinct pay_request_id, flow_instance_id

from pay_requests) pr_dist,

pay_flow_instances pfi

WHERE pay.payroll_rel_action_id = ReconHistoryItemEO.source_id

AND ReconHistoryItemEO.recon_source = 'PR'

AND map.pay_payment_type_id(+) = pay.payment_type_id

AND lookup.lookup_type = 'CE_RECON_SOURCE'

AND lookup.lookup_code = ReconHistoryItemEO.recon_source

AND type_lookup.lookup_code (+) = map.trx_type

AND type_lookup.lookup_type (+) = 'CE_TRX_TYPE'

AND ce_ba.bank_account_id = pay.payer_bank_account_id

AND pay.payroll_action_id = ppa.payroll_action_id

AND ppa.pay_request_id = pr_dist.pay_request_id

AND pr_dist.flow_instance_id = pfi.flow_instance_id

UNION ALL

SELECT ReconHistoryItemEO.RECON_HISTORY_ITEM_ID,

ReconHistoryItemEO.RECON_HISTORY_ID,

ReconHistoryItemEO.RECON_SOURCE,

ReconHistoryItemEO.SOURCE_ID,

GL_JEH.NAME JOURNAL_NAME,

GL_JEB.NAME JOURNAL_BATCH_NAME,

ReconHistoryItemEO.SOURCE_LINE_ID,

ReconHistory.bank_account_id,

NULL statement_number,

TO_CHAR(GL_JEL_REC.jgzz_recon_ref) recon_reference,

Trunc(GL_JEL.effective_date) trx_date,

ReconHistoryItemEO.cleared_amount amount,

null trx_type,

NULL trx_type_code,

lookup.meaning recon_source_meaning,

'Y' is_history_item,

ce_ba.currency_code,

NULL statement_header_id,

NULL transaction_number,

NULL BATCH_NAME,

NULL PAYMENT_INSTRUCTION_ID,

NULL RECEIPT_BATCH_NAME

FROM CE_RECON_HISTORY_ITEMS ReconHistoryItemEO,

CE_RECON_HISTORY ReconHistory,

gl_je_lines GL_JEL,

gl_je_lines_recon GL_JEL_REC,

gl_je_batches GL_JEB,

gl_je_headers GL_JEH,

ce_lookups lookup,

ce_internal_bank_accts_v ce_ba

WHERE GL_JEL.je_header_id = ReconHistoryItemEO.source_id

AND ReconHistory.RECON_HISTORY_ID = ReconHistoryItemEO.RECON_HISTORY_ID

AND GL_JEB.je_batch_id = GL_JEH.je_batch_id

AND GL_JEH.je_header_id = GL_JEL.je_header_id

AND CE_BA.bank_account_id = ReconHistory.bank_account_id

AND GL_JEL.je_line_num = ReconHistoryItemEO.SOURCE_LINE_ID

AND ReconHistoryItemEO.recon_source = 'ORA_GL'

AND lookup.lookup_type = 'CE_RECON_SOURCE'

AND lookup.lookup_code = ReconHistoryItemEO.recon_source

AND GL_JEL_REC.je_header_id (+) = GL_JEL.je_header_id

AND GL_JEL_REC.je_line_num (+) = GL_JEL.je_line_num