APPS.CE_AUTO_BANK_MATCH dependencies on CE_200_RECONCILED_V

Line 5124: FROM ce_200_reconciled_v catv

5120: catv.exchange_rate_date,
5121: catv.exchange_rate_type,
5122: catv.org_id,
5123: catv.CE_BANK_ACCT_USE_ID
5124: FROM ce_200_reconciled_v catv
5125: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5126: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5127: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
5128: AND nvl(catv.trx_number,'-99999')

Line 5416: FROM ce_200_reconciled_v catv, ce_statement_lines sl

5412: catv.exchange_rate_date,
5413: catv.exchange_rate_type,
5414: catv.org_id,
5415: catv.CE_BANK_ACCT_USE_ID
5416: FROM ce_200_reconciled_v catv, ce_statement_lines sl
5417: WHERE nvl(sl.bank_trx_number,'-9999') =
5418: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5419: AND (nvl(sl.invoice_text, '-99999') =
5420: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')