APPS.AP_PURGE_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 971: -- Perf bug 5052674 -- go to base table AP_INVOICE_PAYMENTS_ALL for

967: Print('(Do_independent_inv_checks)' ||debug_info);
968: END IF;
969:
970: -- Test Payments
971: -- Perf bug 5052674 -- go to base table AP_INVOICE_PAYMENTS_ALL for
972: -- main SELECT query and base table CE_STATEMENT_RECONCILS_ALL for sub-query
973: /*bug9944247-The sql has been split into two statements so that the SQL does not have
974: to be transformed by the CBO and to avoid the risk of OR clause and sub-query
975: on ce_statement_reconciliations being applied as a filter.

Line 2421: ap_invoice_payments_all IP,

2417: ac.amount, ac.currency_code, DECODE(void_date, null, null, 'Y'),
2418: p_purge_name, ac.doc_sequence_id, ac.doc_sequence_value, ac.payment_id,
2419: ac.org_id
2420: FROM ap_checks_all AC,
2421: ap_invoice_payments_all IP,
2422: ap_purge_invoice_list PL
2423: WHERE PL.invoice_id = IP.invoice_id
2424: AND IP.check_id = AC.check_id
2425: AND PL.double_check_flag = 'Y'

Line 2448: FROM ap_invoice_payments_all IP, ap_purge_invoice_list PL

2444: INSERT INTO ap_history_inv_payments_all
2445: (invoice_id, check_id, amount,org_id)
2446: SELECT
2447: IP.invoice_id, IP.check_id, SUM(IP.amount),IP.org_id
2448: FROM ap_invoice_payments_all IP, ap_purge_invoice_list PL
2449: WHERE IP.invoice_id = PL.invoice_id
2450: AND PL.double_check_flag = 'Y'
2451: AND PL.invoice_id BETWEEN range_low AND range_high
2452: GROUP BY IP.invoice_id, IP.check_id,

Line 3551: FROM ap_invoice_payments_all aip

3547:
3548: -- Bug 6082252 --
3549: l_dummy := 0;
3550: SELECT COUNT(*) into l_dummy
3551: FROM ap_invoice_payments_all aip
3552: WHERE check_id IN
3553: (SELECT DISTINCT check_id
3554: FROM ap_invoice_payments_all
3555: WHERE invoice_id IN

Line 3554: FROM ap_invoice_payments_all

3550: SELECT COUNT(*) into l_dummy
3551: FROM ap_invoice_payments_all aip
3552: WHERE check_id IN
3553: (SELECT DISTINCT check_id
3554: FROM ap_invoice_payments_all
3555: WHERE invoice_id IN
3556: (SELECT invoice_id
3557: FROM ap_purge_invoice_list
3558: WHERE double_check_flag = 'Y') )