APPS.CE_AUTO_BANK_MATCH dependencies on CE_222_RECONCILED_V

Line 4922: FROM ce_222_reconciled_v catv

4918: catv.exchange_rate_date,
4919: catv.exchange_rate_type,
4920: catv.org_id,
4921: catv.CE_BANK_ACCT_USE_ID
4922: FROM ce_222_reconciled_v catv
4923: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4924: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
4925: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id,catv.org_id)
4926: AND nvl(catv.trx_number,'-99999')

Line 4973: FROM ce_222_reconciled_v catv, ce_statement_lines sl

4969: catv.exchange_rate_date,
4970: catv.exchange_rate_type,
4971: catv.org_id,
4972: catv.CE_BANK_ACCT_USE_ID
4973: FROM ce_222_reconciled_v catv, ce_statement_lines sl
4974: WHERE nvl(sl.bank_trx_number,'-9999') =
4975: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
4976: AND (nvl(sl.invoice_text, '-99999') =
4977: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')

Line 5071: FROM ce_222_reconciled_v catv, ce_statement_lines sl

5067: catv.exchange_rate_date,
5068: catv.exchange_rate_type,
5069: catv.org_id,
5070: catv.CE_BANK_ACCT_USE_ID
5071: FROM ce_222_reconciled_v catv, ce_statement_lines sl
5072: WHERE nvl(sl.bank_trx_number,'-9999') =
5073: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5074: AND (nvl(sl.invoice_text, '-99999') =
5075: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')