DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on AP_INVOICES

Line 2202: ap_invoices_all inv,

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'
2206: AND NVL(rec.current_record_flag,'Y') = 'Y'

Line 2497: ap_invoices_all inv,

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'
2501: AND NVL(rec.current_record_flag,'Y') = 'Y'

Line 6113: from ap_invoices ap,

6109: curr NUMBER;
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