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 923: ap_invoices_all ai,ap_system_parameters_all asp--bug5052748

919: Select 'invoice accounting not purgeable'
920: from xla_events xe, --Bug 4588031
921: xla_transaction_entities xte, --Bug 4588031
922: xla_ae_headers xeh, --Bug 4588031
923: ap_invoices_all ai,ap_system_parameters_all asp--bug5052748
924: where xte.entity_code = 'AP_INVOICES'
925: and xte.source_id_int_1 = PL.invoice_id
926: AND pl.invoice_id=ai.invoice_id
927: AND ai.org_id=asp.org_id

Line 1527: from ap_invoices_all ai

1523: -- test ap vendors
1524: delete from po_purge_vendor_list pvl
1525: where exists
1526: (select null
1527: from ap_invoices_all ai
1528: where ai.vendor_id = pvl.vendor_id)
1529: or exists
1530: (select null
1531: from ap_selected_invoices_all asi,

Line 1633: from ap_invoices_all ai

1629:
1630:
1631: delete from po_purge_vendor_list pvl
1632: where exists (select null
1633: from ap_invoices_all ai
1634: where ai.vendor_id = pvl.vendor_id)
1635: or exists (select null
1636: from ap_selected_invoices_all asi,
1637: ap_supplier_sites_all pvs

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

2134: doc_sequence_value,org_id)
2135: SELECT i.invoice_id, i.vendor_id, v.vendor_site_code, i.invoice_num,
2136: i.invoice_date, i.invoice_amount, b.batch_name, p_purge_name,
2137: i.doc_sequence_id, i.doc_sequence_value,i.org_id
2138: FROM ap_invoices_all i, ap_supplier_sites_all v, ap_batches_all b
2139: WHERE i.vendor_site_id = v.vendor_site_id
2140: AND i.batch_id = b.batch_id (+)
2141: AND i.invoice_id IN (SELECT PL.invoice_id
2142: FROM ap_purge_invoice_list PL

Line 2946: ap_invoices_all ai,

2942: SELECT 'invoice accounting not purgeable'
2943: FROM xla_events xe,
2944: xla_ae_headers xeh,
2945: xla_transaction_entities xte,
2946: ap_invoices_all ai,
2947: ap_system_parameters_all asp --bug5052748
2948: where xte.entity_code = 'AP_INVOICES'
2949: and xte.entity_id = xe.entity_id
2950: and xte.source_id_int_1 =PL.invoice_id

Line 3515: from ap_invoices_all ai

3511: update po_purge_vendor_list pvl
3512: set double_check_flag = 'N'
3513: where pvl.double_check_flag = 'Y'
3514: and (exists (select null
3515: from ap_invoices_all ai
3516: where ai.vendor_id = pvl.vendor_id)
3517: or
3518: exists (select null
3519: from ap_selected_invoices_all asi,