eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PURGE_PKG dependencies on AP_INVOICE_PAYMENTS

Line 455: /* bug3136911 added ap_invoice_payments table join in order to check only

451: max_chk_id NUMBER ;
452: p_id_vc2 VARCHAR2(30) ;
453: -- Bug 8942883 End
454:
455: /* bug3136911 added ap_invoice_payments table join in order to check only
456: invoices which are related to payment.
457: */
458: CURSOR c_main IS
459: select pl.invoice_id

Line 461: ap_invoice_payments ip

457: */
458: CURSOR c_main IS
459: select pl.invoice_id
460: from ap_purge_invoice_list pl,
461: ap_invoice_payments ip
462: where pl.invoice_id = ip.invoice_id;
463:
464: CURSOR c_main_check(l_invoice_id NUMBER) IS
465: select invoice_id

Line 489: from ap_invoice_payments ip,

485: Function Check_inv(l_check_id IN NUMBER) RETURN BOOLEAN IS
486:
487: CURSOR c_inv IS
488: select pil.invoice_id
489: from ap_invoice_payments ip,
490: ap_purge_invoice_list pil
491: where ip.check_id = l_check_id
492: and ip.invoice_id = pil.invoice_id (+) ;
493:

Line 543: from ap_invoice_payments

539: Function Check_check(l_invoice_id IN NUMBER ) RETURN BOOLEAN IS
540:
541: CURSOR c_check IS
542: select check_id
543: from ap_invoice_payments
544: where invoice_id = l_invoice_id ;
545:
546: l_flag BOOLEAN := FALSE;
547: l_check_id number;

Line 604: FROM ap_invoice_payments ; */

600: FROM ap_invoices ;
601:
602: SELECT MAX( check_id )
603: INTO max_chk_id
604: FROM ap_invoice_payments ; */
605: SELECT last_number
606: INTO max_inv_id
607: FROM all_sequences
608: WHERE sequence_owner = l_sch_name

Line 718: from ap_invoice_payments

714: IF use_vc2 THEN -- Bug 8942883
715: p_id_vc2 := tab_check_vc2.next(p_id_vc2) ;
716: DELETE FROM ap_purge_invoice_list
717: WHERE invoice_id in ( select invoice_id
718: from ap_invoice_payments
719: where check_id = p_id_vc2);
720: ELSE
721: p_id := tab_check.next(p_id) ;
722: DELETE FROM ap_purge_invoice_list

Line 724: from ap_invoice_payments

720: ELSE
721: p_id := tab_check.next(p_id) ;
722: DELETE FROM ap_purge_invoice_list
723: WHERE invoice_id in ( select invoice_id
724: from ap_invoice_payments
725: where check_id = p_id);
726: END IF ;
727: END LOOP;
728: END IF;

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 982: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(c AP_CHECKS_U1) */

978: DELETE /*+ PARALLEL(pl) ROWID(pl) */
979: FROM ap_purge_invoice_list pl
980: WHERE pl.rowid IN
981: (SELECT /*+ ORDERED PARALLEL(pl1) FULL(pl1) USE_NL(p,c)
982: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(c AP_CHECKS_U1) */
983: pl1.rowid
984: FROM ap_purge_invoice_list pl1,
985: ap_invoice_payments p,
986: ap_checks c

Line 985: ap_invoice_payments p,

981: (SELECT /*+ ORDERED PARALLEL(pl1) FULL(pl1) USE_NL(p,c)
982: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(c AP_CHECKS_U1) */
983: pl1.rowid
984: FROM ap_purge_invoice_list pl1,
985: ap_invoice_payments p,
986: ap_checks c
987: WHERE p.invoice_id = pl1.invoice_id
988: AND p.check_id = c.check_id
989: AND ((p.posted_flag <> 'Y'

Line 1003: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(sr CE_STATEMENT_RECONS_N2) */

999: DELETE /*+ PARALLEL(pl) ROWID(pl) */
1000: FROM ap_purge_invoice_list pl
1001: WHERE pl.rowid IN
1002: (SELECT /*+ ORDERED PARALLEL(pl1) FULL(pl1) USE_NL(p, 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

Line 1006: ap_invoice_payments p,

1002: (SELECT /*+ ORDERED PARALLEL(pl1) FULL(pl1) USE_NL(p, 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'

Line 1055: from ap_invoice_payments aip

1051:
1052: DELETE FROM ap_purge_invoice_list PL
1053: where EXISTS(
1054: select 'history not purgeable'
1055: from ap_invoice_payments aip
1056: , ap_payment_history aph
1057: where aip.invoice_id = PL.invoice_id
1058: and aip.check_id = aph.check_id
1059: -- To check for posted_flag added for bug#2274656

Line 1102: ap_invoice_payments aip,

1098: pl1.rowid -- 7759218
1099: from ap_purge_invoice_list pl1,
1100: xla_events xe, --Bug 4588031
1101: xla_transaction_entities xte, --Bug 4588031
1102: ap_invoice_payments aip,
1103: ap_system_parameters_all asp,--bug5052478
1104: xla_ae_headers xeh --Bug 4588031
1105: where xte.entity_code = 'AP_PAYMENTS'
1106: and NVL(XTE.SOURCE_ID_INT_1,-99) = aip.check_id --11059839

Line 1333: FROM ap_invoice_payments IP1,

1329: DELETE
1330: FROM ap_purge_invoice_list PL
1331: WHERE EXISTS (
1332: SELECT 'relational problem'
1333: FROM ap_invoice_payments IP1,
1334: ap_invoice_payments IP2
1335: WHERE PL.invoice_id = IP1.invoice_id
1336: AND IP1.check_id = IP2.check_id
1337: AND IP2.invoice_id NOT IN (

Line 1334: ap_invoice_payments IP2

1330: FROM ap_purge_invoice_list PL
1331: WHERE EXISTS (
1332: SELECT 'relational problem'
1333: FROM ap_invoice_payments IP1,
1334: ap_invoice_payments IP2
1335: WHERE PL.invoice_id = IP1.invoice_id
1336: AND IP1.check_id = IP2.check_id
1337: AND IP2.invoice_id NOT IN (
1338: SELECT PL2.invoice_id

Line 1352: FROM ap_invoice_payments IP1, ap_invoice_payments IP2

1348: SET PL.double_check_flag = 'N'
1349: WHERE PL.double_check_flag = 'Y'
1350: AND EXISTS (
1351: SELECT /*+NO_UNNEST*/'relational problem'
1352: FROM ap_invoice_payments IP1, ap_invoice_payments IP2
1353: WHERE PL.invoice_id = IP1.invoice_id
1354: AND IP1.check_id = IP2.check_id
1355: AND IP2.invoice_id NOT IN (
1356: SELECT PL2.invoice_id

Line 1619: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(c AP_CHECKS_U1) INDEX(d

1615: FROM
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,

Line 1624: ap_invoice_payments p,

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,
1625: ap_checks c,
1626: ap_invoice_distributions d,
1627: ap_invoice_lines l
1628: WHERE i.rowid = pi.inv_rowid

Line 1649: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(d AP_INVOICE_DISTRIBUTIONS_U1) */

1645: NVL(i.exclusive_payment_flag, 'N'), 'Y')
1646: GROUP BY i.invoice_id
1647: UNION
1648: SELECT /*+ ORDERED PARALLEL(pzi) FULL(pzi) USE_NL(i,p,d)
1649: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(d AP_INVOICE_DISTRIBUTIONS_U1) */
1650: i.invoice_id, NULL check_id
1651: FROM purge_zero_inv pzi,
1652: ap_invoices i,
1653: ap_invoice_payments p,

Line 1653: ap_invoice_payments p,

1649: INDEX(p AP_INVOICE_PAYMENTS_N1) INDEX(d AP_INVOICE_DISTRIBUTIONS_U1) */
1650: i.invoice_id, NULL check_id
1651: FROM purge_zero_inv pzi,
1652: ap_invoices i,
1653: ap_invoice_payments p,
1654: ap_invoice_distributions d
1655: WHERE i.rowid = pzi.inv_rowid
1656: AND p.invoice_id (+) = i.invoice_id
1657: AND i.invoice_id = d.invoice_id(+)

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 3197: FROM ap_invoice_payments P, ap_checks C

3193: SET PL.double_check_flag = 'N'
3194: WHERE PL.double_check_flag = 'Y'
3195: AND EXISTS (
3196: SELECT /*+NO_UNNEST*/'payment no longer purgeable'
3197: FROM ap_invoice_payments P, ap_checks C
3198: WHERE P.invoice_id = PL.invoice_id
3199: AND P.check_id = C.check_id
3200: AND (P.posted_flag <> 'Y'
3201: OR P.last_update_date > g_activity_date

Line 3303: ap_invoice_payments aip,

3299: and update stmt (in Retest_Invoice_Independents()) has same queries. */
3300: Select 'payment accounting not purgeable' -- 7759218
3301: from xla_events xe, --Bug 4588031
3302: xla_transaction_entities xte, --Bug 4588031
3303: ap_invoice_payments aip,
3304: ap_system_parameters_all asp,--bug5052478
3305: xla_ae_headers xeh --Bug 4588031
3306: where xte.entity_code = 'AP_PAYMENTS'
3307: and NVL(XTE.SOURCE_ID_INT_1,-99) = aip.check_id --11059839

Line 3322: , ap_invoice_payments aip

3318: /*Commented the subquery - bug 12955426 */
3319: /*
3320: SELECT 'payment accounting not purgeable'
3321: FROM xla_events xe
3322: , ap_invoice_payments aip
3323: , ap_checks apc
3324: , xla_ae_headers xeh
3325: , xla_transaction_entities xte
3326: WHERE xte.entity_code = 'AP_CHECKS'

Line 3390: ap_invoice_payments ip

3386:
3387: CURSOR c_main IS
3388: select pl.invoice_id
3389: from ap_purge_invoice_list pl,
3390: ap_invoice_payments ip
3391: where pl.invoice_id = ip.invoice_id;
3392:
3393: CURSOR c_main_check(l_invoice_id NUMBER) IS
3394: select invoice_id

Line 3418: from ap_invoice_payments ip,

3414: Function Check_inv(l_check_id IN NUMBER) RETURN BOOLEAN IS
3415:
3416: CURSOR c_inv IS
3417: select pil.invoice_id
3418: from ap_invoice_payments ip,
3419: ap_purge_invoice_list pil
3420: where ip.check_id = l_check_id
3421: and ip.invoice_id = pil.invoice_id (+)
3422: and pil.double_check_flag = 'Y';

Line 3474: from ap_invoice_payments

3470: Function Check_check(l_invoice_id IN NUMBER ) RETURN BOOLEAN IS
3471:
3472: CURSOR c_check IS
3473: select check_id
3474: from ap_invoice_payments
3475: where invoice_id = l_invoice_id ;
3476:
3477: l_flag BOOLEAN := FALSE;
3478: l_check_id number;

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') )

Line 3577: FROM ap_invoice_payments ; */

3573: FROM ap_invoices ;
3574:
3575: SELECT MAX( check_id )
3576: INTO max_chk_id
3577: FROM ap_invoice_payments ; */
3578: SELECT last_number
3579: INTO max_inv_id
3580: FROM all_sequences
3581: WHERE sequence_owner = l_sch_name

Line 3694: from ap_invoice_payments

3690: p_id_vc2 := tab_check_vc2.next(p_id_vc2) ;
3691: UPDATE ap_purge_invoice_list
3692: SET double_check_flag = 'N'
3693: WHERE invoice_id in ( select invoice_id
3694: from ap_invoice_payments
3695: where check_id = p_id_vc2);
3696: ELSE
3697: p_id := tab_check.next(p_id) ;
3698: UPDATE ap_purge_invoice_list

Line 3701: from ap_invoice_payments

3697: p_id := tab_check.next(p_id) ;
3698: UPDATE ap_purge_invoice_list
3699: SET double_check_flag = 'N'
3700: WHERE invoice_id in ( select invoice_id
3701: from ap_invoice_payments
3702: where check_id = p_id);
3703: END IF ;
3704: END LOOP;
3705: END IF;

Line 3770: debug_info := 'ap_invoice_payments';

3766: INTO fp_check_rows
3767: FROM ap_checks;
3768:
3769: --
3770: debug_info := 'ap_invoice_payments';
3771: IF g_debug_switch in ('y','Y') THEN
3772: Print('(Count_Ap_Rows)'||debug_info);
3773: END IF;
3774:

Line 3778: FROM ap_invoice_payments;

3774:
3775: --
3776: SELECT count(*)
3777: INTO fp_invoice_payment_rows
3778: FROM ap_invoice_payments;
3779:
3780: --
3781: debug_info := 'ap_invoices';
3782: IF g_debug_switch in ('y','Y') THEN

Line 4532: ap_invoice_payments = fp_invoice_payment_rows,

4528:
4529: UPDATE financials_purges
4530: SET
4531: ap_checks = fp_check_rows,
4532: ap_invoice_payments = fp_invoice_payment_rows,
4533: ap_invoices = fp_invoice_rows,
4534: po_headers = fp_po_header_rows ,
4535: po_receipts = fp_receipt_line_rows,
4536: po_requisition_headers = fp_req_header_rows,

Line 4569: FROM ap_invoice_payments aip

4565: UPDATE ap_purge_invoice_list PL
4566: SET PL.double_check_flag = 'N'
4567: WHERE EXISTS (
4568: SELECT 'history not purgeable'
4569: FROM ap_invoice_payments aip
4570: , ap_payment_history aph
4571: WHERE aip.invoice_id = PL.invoice_id
4572: and aip.check_id = aph.check_id
4573: and aph.last_update_date > g_activity_date);

Line 5182: FROM ap_invoice_payments P, ap_purge_invoice_list PL,

5178: RETURN BOOLEAN IS
5179:
5180: CURSOR overflow_select is
5181: SELECT C.check_stock_id,C.check_number
5182: FROM ap_invoice_payments P, ap_purge_invoice_list PL,
5183: ap_checks C
5184: WHERE P.invoice_id = PL.invoice_id
5185: AND P.check_id = C.check_id
5186: AND PL.double_check_flag = 'Y'

Line 5444: l_invoice_payment_id ap_invoice_payments.invoice_payment_id%TYPE;

5440: l_invoice_id ap_invoices.invoice_id%TYPE;
5441: l_invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
5442: l_check_id ap_checks.check_id%TYPE;
5443: l_payment_history_id ap_payment_history.payment_history_id%TYPE;
5444: l_invoice_payment_id ap_invoice_payments.invoice_payment_id%TYPE;
5445:
5446: -- Bug 8913560 : Added the 3 variables given below
5447: l_check_rows NUMBER ;
5448: l_invoice_payment_rows NUMBER ;

Line 5522: ap_invoice_payments IP

5518: WHERE (AUD.doc_sequence_id , AUD.doc_sequence_value)
5519: IN (SELECT C.doc_sequence_id , C.doc_sequence_value
5520: FROM ap_purge_invoice_list PL,
5521: ap_checks C,
5522: ap_invoice_payments IP
5523: WHERE PL.double_check_flag = 'Y'
5524: AND -- Bug 8913560 PL.invoice_id BETWEEN range_low AND range_high
5525: PL.rowid BETWEEN p_start_rowid AND p_end_rowid
5526: AND PL.invoice_id = IP.invoice_id

Line 5556: FROM ap_invoice_payments P, ap_purge_invoice_list PL

5552: -- bug 5052764 - go to base table ap_checks_all to remove FTS
5553: DELETE FROM ap_checks_all C
5554: WHERE C.check_id IN (
5555: SELECT P.check_id
5556: FROM ap_invoice_payments P, ap_purge_invoice_list PL
5557: WHERE P.invoice_id = PL.invoice_id
5558: AND PL.double_check_flag = 'Y'
5559: AND -- Bug 8913560 PL.invoice_id BETWEEN range_low AND range_high
5560: PL.rowid BETWEEN p_start_rowid AND p_end_rowid );

Line 5586: FROM ap_invoice_payments aip

5582:
5583: DELETE FROM ap_payment_history aph
5584: WHERE EXISTS (
5585: SELECT 'history purgeable'
5586: FROM ap_invoice_payments aip
5587: , ap_purge_invoice_list PL
5588: WHERE aip.invoice_id = PL.invoice_id
5589: and aip.check_id = aph.check_id
5590: and PL.double_check_flag = 'Y'

Line 5593: debug_info := 'ap_invoice_payments';

5589: and aip.check_id = aph.check_id
5590: and PL.double_check_flag = 'Y'
5591: and PL.rowid BETWEEN p_start_rowid AND p_end_rowid); --9481539
5592:
5593: debug_info := 'ap_invoice_payments';
5594: IF g_debug_switch in ('y','Y') THEN
5595: Print('(Delete_AP_Tables)'||debug_info);
5596: END IF;
5597:

Line 5601: DELETE FROM ap_invoice_payments

5597:
5598:
5599: -- delete_invoice_payments
5600:
5601: DELETE FROM ap_invoice_payments
5602: WHERE invoice_id IN (
5603: SELECT PL.invoice_id
5604: FROM ap_purge_invoice_list PL
5605: WHERE PL.double_check_flag = 'Y'

Line 5946: ,ap_invoice_payments aip

5942: WHERE ael.ae_header_id in
5943: ( SELECT aeh.ae_header_id
5944: FROM ap_ae_headers aeh -- bug 2153117 added
5945: ,ap_accounting_events aae
5946: ,ap_invoice_payments aip
5947: ,ap_purge_invoice_list pil
5948: WHERE aae.source_id = aip.check_id
5949: and aae.source_table = 'AP_CHECKS'
5950: and pil.double_check_flag = 'Y'

Line 5979: , ap_invoice_payments aip

5975: DELETE FROM ap_ae_headers aeh
5976: WHERE aeh.accounting_event_id in
5977: ( SELECT aae.accounting_event_id
5978: FROM ap_accounting_events aae
5979: , ap_invoice_payments aip
5980: , ap_purge_invoice_list pil
5981: -- bug2153117 removed
5982: -- , ap_ae_headers aeh
5983: WHERE aae.source_id = aip.check_id

Line 6026: AP_INVOICE_PAYMENTS AIP

6022: DELETE FROM AP_ACCOUNTING_EVENTS AAE WHERE
6023: aae.source_id in ( SELECT APC.CHECK_ID
6024: FROM AP_PURGE_INVOICE_LIST PIL,
6025: AP_CHECKS APC,
6026: AP_INVOICE_PAYMENTS AIP
6027: WHERE PIL.DOUBLE_CHECK_FLAG = 'Y'
6028: AND APC.CHECK_ID = AIP.CHECK_ID
6029: AND AIP.INVOICE_ID = PIL.INVOICE_ID
6030: AND PIL.INVOICE_ID BETWEEN range_low

Line 6038: AP_INVOICE_PAYMENTS AIP,

6034:
6035: DELETE FROM AP_ACCOUNTING_EVENTS AAE WHERE
6036: AAE.source_id IN ( SELECT APH.CHECK_ID
6037: FROM AP_PURGE_INVOICE_LIST PIL,
6038: AP_INVOICE_PAYMENTS AIP,
6039: AP_PAYMENT_HISTORY APH
6040: WHERE PIL.DOUBLE_CHECK_FLAG = 'Y'
6041: AND APH.CHECK_ID = AIP.CHECK_ID
6042: AND AIP.INVOICE_ID = PIL.INVOICE_ID

Line 6892: ap_invoice_payments = invoice_payment_rows,

6888:
6889: UPDATE financials_purges
6890: SET
6891: ap_checks = check_rows,
6892: ap_invoice_payments = invoice_payment_rows,
6893: ap_invoices = invoice_rows,
6894: ap_ae_lines = ae_line_rows,
6895: ap_ae_headers = ae_header_rows,
6896: ap_accounting_events = accounting_event_rows

Line 6903: NVL( ap_invoice_payments, 0 ) ,

6899: COMMIT ;
6900: ELSE */
6901: IF l_purge_without_review <> 'Y' THEN
6902: SELECT NVL( ap_checks, 0 ) ,
6903: NVL( ap_invoice_payments, 0 ) ,
6904: NVL( ap_invoices, 0 ) ,
6905: NVL( ap_ae_lines, 0 ) ,
6906: NVL( ap_ae_headers, 0 ) ,
6907: NVL( ap_accounting_events, 0 )

Line 7019: NVL( ap_invoice_payments, 0 ) ,

7015: end if;
7016: */
7017: -- Bug 8913560 Start
7018: SELECT NVL( ap_checks, 0 ) ,
7019: NVL( ap_invoice_payments, 0 ) ,
7020: NVL( ap_invoices, 0 ) ,
7021: NVL( ap_ae_lines, 0 ) ,
7022: NVL( ap_ae_headers, 0 ) ,
7023: NVL( ap_accounting_events, 0 )

Line 7195: ap_invoice_payments = nvl(ap_invoice_payments, 0) - invoice_payment_rows,

7191: -- record_final_statistics
7192: UPDATE financials_purges
7193: SET
7194: ap_checks = nvl(ap_checks, 0) - check_rows,
7195: ap_invoice_payments = nvl(ap_invoice_payments, 0) - invoice_payment_rows,
7196: ap_invoices = nvl(ap_invoices, 0) - invoice_rows,
7197: po_headers = nvl(po_headers, 0) - po_header_rows,
7198: po_requisition_headers = nvl(po_requisition_headers, 0) - req_header_rows,
7199: po_vendors = nvl(po_vendors, 0) - vendor_rows,

Line 7986: ap_invoice_payments = NVL(ap_invoice_payments , 0 ) + p_invoice_payment_rows,

7982: PRAGMA AUTONOMOUS_TRANSACTION ;
7983: BEGIN
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,