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 AP_PAYMENT_HISTORY_ALL

Line 2199: ap_payment_history_all aph,

2195: ce_bank_acct_uses_ou_v aba,
2196: ce_bank_accounts ba,
2197: ce_bank_acct_uses_ou_v aba2,
2198: ce_bank_accounts ba2,
2199: ap_payment_history_all aph,
2200: ap_checks_all c,
2201: ap_invoice_payments_all pay,
2202: ap_invoices_all inv,
2203: po_vendors ven

Line 2247: from ap_payment_history_all aph2

2243: AND aph.org_id (+) = c.org_id
2244: AND aph.transaction_type (+) = 'PAYMENT CLEARING'
2245: AND not exists
2246: (select null
2247: from ap_payment_history_all aph2
2248: where aph2.check_id = c.check_id
2249: and aph2.org_id = c.org_id
2250: and aph2.transaction_type = 'PAYMENT CLEARING'
2251: and aph2.payment_history_id > aph.payment_history_id);

Line 2494: ap_payment_history_all aph,

2490: ce_system_parameters sp,
2491: ce_statement_reconcils_all rec,
2492: ce_bank_accounts ba,
2493: ce_bank_acct_uses_ou_v aba,
2494: ap_payment_history_all aph,
2495: ap_checks_all c,
2496: ap_invoice_payments_all pay,
2497: ap_invoices_all inv,
2498: po_vendors ven