DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on AP_INVOICE_PAYMENTS

Line 2201: ap_invoice_payments_all pay,

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
2204: WHERE sob.set_of_books_id = sp.set_of_books_id
2205: AND NVL(rec.status_flag, 'U') = 'U'

Line 2496: ap_invoice_payments_all pay,

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
2499: WHERE sob.set_of_books_id = sp.set_of_books_id
2500: AND NVL(rec.status_flag, 'U') = 'U'

Line 6114: ap_invoice_payments aip,

6110:
6111: cursor count_dup_invoice is
6112: select count(*)
6113: from ap_invoices ap,
6114: ap_invoice_payments aip,
6115: ap_checks_all ac,
6116: ce_bank_accounts ba,
6117: ce_bank_acct_uses_ou_v bau
6118: where ba.bank_account_num = CE_AUTO_BANK_MATCH.csl_bank_account_text