APPS.AP_PURGE_PKG dependencies on AP_INVOICES_ALL

Line 8: --Introduction of AP_INVOICES_ALL,AP_SYSTEM_PARAMETERS_ALL to force an

4: --This bug mainly solves most of the performance related issues reported
5: --in SQLREP.
6: --There are two kinds of fixes.
7: --NO_UNNEST is used in the inner query to prevent FTS on large tables.
8: --Introduction of AP_INVOICES_ALL,AP_SYSTEM_PARAMETERS_ALL to force an
9: --access path.
10: -- Private Variables
11: -- Declaring the global variables
12: g_debug_switch VARCHAR2(1) := 'N';

Line 1079: ap_invoices_all ai,

1075: WHERE pl.rowid IN (
1076: Select /*+ ORDERED PARALLEL(pl1) FULL(pl1) */
1077: pl1.rowid -- 7759218
1078: from ap_purge_invoice_list pl1,
1079: ap_invoices_all ai,
1080: xla_events xe, --Bug 4588031
1081: xla_transaction_entities xte, --Bug 4588031
1082: xla_ae_headers xeh, --Bug 4588031
1083: ap_system_parameters_all asp--bug5052748

Line 1769: from ap_invoices_all ai

1765: -- test ap vendors
1766: delete from po_purge_vendor_list pvl
1767: where exists
1768: (select null
1769: from ap_invoices_all ai
1770: where ai.vendor_id = pvl.vendor_id)
1771: or exists
1772: (select null
1773: from ap_selected_invoices_all asi,

Line 1875: from ap_invoices_all ai

1871:
1872:
1873: delete from po_purge_vendor_list pvl
1874: where exists (select null
1875: from ap_invoices_all ai
1876: where ai.vendor_id = pvl.vendor_id)
1877: or exists (select null
1878: from ap_selected_invoices_all asi,
1879: ap_supplier_sites_all pvs

Line 2393: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b

2389: doc_sequence_value,org_id)
2390: SELECT i.invoice_id, i.vendor_id, v.vendor_site_code, i.invoice_num,
2391: i.invoice_date, i.invoice_amount, b.batch_name, p_purge_name,
2392: i.doc_sequence_id, i.doc_sequence_value,i.org_id
2393: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b
2394: WHERE i.vendor_site_id = v.vendor_site_id
2395: AND i.batch_id = b.batch_id (+)
2396: AND i.invoice_id IN (SELECT PL.invoice_id
2397: FROM ap_purge_invoice_list PL

Line 3283: ap_invoices_all ai,

3279: SELECT 'invoice accounting not purgeable'
3280: FROM xla_events xe,
3281: xla_ae_headers xeh,
3282: xla_transaction_entities xte,
3283: ap_invoices_all ai,
3284: ap_system_parameters_all asp --bug5052748
3285: where xte.entity_code = 'AP_INVOICES'
3286: and xte.entity_id = xe.entity_id
3287: and NVL(XTE.SOURCE_ID_INT_1,-99) = PL.invoice_id /* Bug#12615876 */

Line 4019: from ap_invoices_all ai

4015: update po_purge_vendor_list pvl
4016: set double_check_flag = 'N'
4017: where pvl.double_check_flag = 'Y'
4018: and (exists (select null
4019: from ap_invoices_all ai
4020: where ai.vendor_id = pvl.vendor_id)
4021: or
4022: exists (select null
4023: from ap_selected_invoices_all asi,

Line 7244: FROM ap_invoices_all I --bug13799066

7240: DELETE FROM ap_batches B
7241: WHERE B.last_update_date <= g_activity_date
7242: AND NOT EXISTS (
7243: SELECT null
7244: FROM ap_invoices_all I --bug13799066
7245: WHERE I.batch_id = B.batch_id);
7246:
7247: -- clear_invoice_purge_list
7248: -- 9481539