APPS.CE_AUTO_BANK_MATCH dependencies on CE_222_RECONCILED_V

Line 5169: FROM ce_222_reconciled_v catv

5165: catv.exchange_rate_date,
5166: catv.exchange_rate_type,
5167: catv.org_id,
5168: catv.CE_BANK_ACCT_USE_ID
5169: FROM ce_222_reconciled_v catv
5170: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
5171: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
5172: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)
5173: AND nvl(catv.trx_number,'-99999')

Line 5220: FROM ce_222_reconciled_v catv, ce_statement_lines sl

5216: catv.exchange_rate_date,
5217: catv.exchange_rate_type,
5218: catv.org_id,
5219: catv.CE_BANK_ACCT_USE_ID
5220: FROM ce_222_reconciled_v catv, ce_statement_lines sl
5221: WHERE nvl(sl.bank_trx_number,'-9999') =
5222: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5223: AND (nvl(sl.invoice_text, '-99999') =
5224: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')

Line 5318: FROM ce_222_reconciled_v catv, ce_statement_lines sl

5314: catv.exchange_rate_date,
5315: catv.exchange_rate_type,
5316: catv.org_id,
5317: catv.CE_BANK_ACCT_USE_ID
5318: FROM ce_222_reconciled_v catv, ce_statement_lines sl
5319: WHERE nvl(sl.bank_trx_number,'-9999') =
5320: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5321: AND (nvl(sl.invoice_text, '-99999') =
5322: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')