APPS.AP_PURGE_PKG dependencies on AP_INVOICE_LINES

Line 1597: /* Bug 10391241 added join for ap_invoice_lines_all */

1593:
1594: EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL QUERY';
1595:
1596: -- modified the below query for bug13799066
1597: /* Bug 10391241 added join for ap_invoice_lines_all */
1598: INSERT INTO ap_purge_invoice_list pl
1599: (
1600: invoice_id,
1601: purge_name,

Line 1620: AP_INVOICE_DISTRIBUTIONS_U1) INDEX(l AP_INVOICE_LINES_U1) */

1616: (SELECT invoice_id, check_id
1617: FROM
1618: (SELECT /*+ ORDERED PARALLEL(PI) FULL(pi) USE_NL(i,p,c,d,l)
1619: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(c AP_CHECKS_U1) INDEX(d
1620: AP_INVOICE_DISTRIBUTIONS_U1) INDEX(l AP_INVOICE_LINES_U1) */
1621: i.invoice_id, MIN(c.check_id) check_id
1622: FROM purge_inv pi,
1623: ap_invoices i,
1624: ap_invoice_payments p,

Line 1627: ap_invoice_lines l

1623: ap_invoices i,
1624: ap_invoice_payments p,
1625: ap_checks c,
1626: ap_invoice_distributions d,
1627: ap_invoice_lines l
1628: WHERE i.rowid = pi.inv_rowid
1629: AND i.invoice_id = l.invoice_id
1630: AND i.invoice_id = d.invoice_id
1631: AND l.line_number = d.invoice_line_number -- bug14237038

Line 3030: FROM ap_invoice_lines IL

3026: SET PL.double_check_flag = 'N'
3027: WHERE PL.double_check_flag = 'Y'
3028: AND EXISTS(
3029: SELECT 'lines no longer purgeable'
3030: FROM ap_invoice_lines IL
3031: WHERE PL.invoice_id = IL.invoice_id
3032: AND IL.last_update_date > g_activity_date );
3033:
3034: /* bug 10391241 */

Line 5693: debug_info := 'ap_invoice_lines';

5689:
5690: l_invoice_distributions_rows := SQL%ROWCOUNT; /*bug 11829621*/
5691:
5692: /* bug 10391241 */
5693: debug_info := 'ap_invoice_lines';
5694: IF g_debug_switch in ('y','Y') THEN
5695: Print('(Delete_AP_Tables)'||debug_info);
5696: END IF;
5697:

Line 5699: DELETE FROM ap_invoice_lines

5695: Print('(Delete_AP_Tables)'||debug_info);
5696: END IF;
5697:
5698:
5699: DELETE FROM ap_invoice_lines
5700: WHERE invoice_id IN (
5701: SELECT PL.invoice_id
5702: FROM ap_purge_invoice_list PL
5703: WHERE PL.double_check_flag = 'Y'

Line 7988: ap_invoice_lines = NVL(ap_invoice_lines , 0 ) + p_invoice_lines_rows, --bug 11829621

7984: UPDATE financials_purges
7985: SET ap_checks = NVL(ap_checks , 0 ) + p_check_rows,
7986: ap_invoice_payments = NVL(ap_invoice_payments , 0 ) + p_invoice_payment_rows,
7987: ap_invoices = NVL(ap_invoices , 0 ) + p_invoice_rows,
7988: ap_invoice_lines = NVL(ap_invoice_lines , 0 ) + p_invoice_lines_rows, --bug 11829621
7989: ap_invoice_distributions = NVL(ap_invoice_distributions , 0 ) + p_invoice_distributions_rows, --bug 11829621
7990: ap_ae_lines = NVL(ap_ae_lines , 0 ) + p_ae_line_rows,
7991: ap_ae_headers = NVL(ap_ae_headers , 0 ) + p_ae_header_rows,
7992: ap_accounting_events = NVL(ap_accounting_events, 0 ) + p_accounting_event_rows