APPS.AP_PURGE_PKG dependencies on CE_STATEMENT_RECONCILIATIONS

Line 975: on ce_statement_reconciliations being applied as a filter.

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.
976: It also allows more control using hints. */
977:
978: DELETE /*+ PARALLEL(pl) ROWID(pl) */
979: FROM ap_purge_invoice_list pl

Line 1007: ce_statement_reconciliations sr

1003: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(sr CE_STATEMENT_RECONS_N2) */
1004: DISTINCT pl1.rowid
1005: FROM ap_purge_invoice_list pl1,
1006: ap_invoice_payments p,
1007: ce_statement_reconciliations sr
1008: WHERE p.invoice_id = pl1.invoice_id
1009: AND p.check_id = sr.reference_id
1010: AND sr.reference_type = 'PAYMENT'
1011: );