eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_AUTO_BANK_MATCH dependencies on CE_200_RECONCILED_V

Line 4877: FROM ce_200_reconciled_v catv

4873: catv.exchange_rate_date,
4874: catv.exchange_rate_type,
4875: catv.org_id,
4876: catv.CE_BANK_ACCT_USE_ID
4877: FROM ce_200_reconciled_v catv
4878: WHERE catv.bank_account_id = CE_AUTO_BANK_MATCH.csh_bank_account_id
4879: --AND catv.ce_bank_acct_use_id = CE_AUTO_BANK_MATCH.bau_bank_acct_use_id
4880: AND catv.org_id = nvl(CE_AUTO_BANK_REC.G_org_id, catv.org_id)
4881: AND nvl(catv.trx_number,'-99999')

Line 5169: FROM ce_200_reconciled_v catv, ce_statement_lines sl

5165: catv.exchange_rate_date,
5166: catv.exchange_rate_type,
5167: catv.org_id,
5168: catv.CE_BANK_ACCT_USE_ID
5169: FROM ce_200_reconciled_v catv, ce_statement_lines sl
5170: WHERE nvl(sl.bank_trx_number,'-9999') =
5171: nvl(CE_AUTO_BANK_MATCH.csl_bank_trx_number, '-9999')
5172: AND (nvl(sl.invoice_text, '-99999') =
5173: nvl(CE_AUTO_BANK_MATCH.csl_invoice_text, '-99999')