DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on AP_PAYMENT_HISTORY_ALL

Line 2205: ap_payment_history_all aph,

2201: ce_bank_accounts ba,
2202: --ce_bank_acct_uses_ou_v aba2, -- Bug 9062935 removed use of view
2203: iby_ext_bank_accounts ext, -- Bug 9062935
2204: --ce_bank_accounts ba2, -- Bug 9361270 Commented Line
2205: ap_payment_history_all aph,
2206: ap_checks_all c,
2207: ap_invoice_payments_all pay,
2208: ap_invoices_all inv,
2209: po_vendors ven

Line 2249: from ap_payment_history_all aph2

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

Line 2487: ap_payment_history_all aph,

2483: ce_system_parameters sp,
2484: ce_statement_reconcils_all rec,
2485: ce_bank_accounts ba,
2486: ce_bank_acct_uses_ou_v aba,
2487: ap_payment_history_all aph,
2488: ap_checks_all c,
2489: ap_invoice_payments_all pay,
2490: ap_invoices_all inv,
2491: po_vendors ven