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 433: /* bug3136911 added ap_invoice_payments table join in order to check only

429: tab_inv tab_status_type;
430: tab_check tab_status_type;
431: tab_clear tab_status_type;
432:
433: /* bug3136911 added ap_invoice_payments table join in order to check only
434: invoices which are related to payment.
435: */
436: CURSOR c_main IS
437: select pl.invoice_id

Line 439: ap_invoice_payments ip

435: */
436: CURSOR c_main IS
437: select pl.invoice_id
438: from ap_purge_invoice_list pl,
439: ap_invoice_payments ip
440: where pl.invoice_id = ip.invoice_id;
441:
442: CURSOR c_main_check(l_invoice_id NUMBER) IS
443: select invoice_id

Line 466: from ap_invoice_payments ip,

462: Function Check_inv(l_check_id IN NUMBER) RETURN BOOLEAN IS
463:
464: CURSOR c_inv IS
465: select pil.invoice_id
466: from ap_invoice_payments ip,
467: ap_purge_invoice_list pil
468: where ip.check_id = l_check_id
469: and ip.invoice_id = pil.invoice_id (+) ;
470:

Line 511: from ap_invoice_payments

507: Function Check_check(l_invoice_id IN NUMBER ) RETURN BOOLEAN IS
508:
509: CURSOR c_check IS
510: select check_id
511: from ap_invoice_payments
512: where invoice_id = l_invoice_id ;
513:
514: l_flag BOOLEAN := FALSE;
515: l_check_id number;

Line 613: from ap_invoice_payments

609: FOR y IN 1..p_count LOOP
610: p_id := tab_check.next(p_id) ;
611: DELETE FROM ap_purge_invoice_list
612: WHERE invoice_id in ( select invoice_id
613: from ap_invoice_payments
614: where check_id = p_id);
615: END LOOP;
616: END IF;
617:

Line 802: -- Perf bug 5052674 -- go to base table AP_INVOICE_PAYMENTS_ALL for

798: Print('(Do_independent_inv_checks)' ||debug_info);
799: END IF;
800:
801: -- Test Payments
802: -- Perf bug 5052674 -- go to base table AP_INVOICE_PAYMENTS_ALL for
803: -- main SELECT query and base table CE_STATEMENT_RECONCILS_ALL for sub-query
804: DELETE
805: FROM ap_purge_invoice_list PL
806: WHERE EXISTS

Line 808: FROM ap_invoice_payments_all P,

804: DELETE
805: FROM ap_purge_invoice_list PL
806: WHERE EXISTS
807: (SELECT 'payment not purgeable'
808: FROM ap_invoice_payments_all P,
809: ap_checks C
810: WHERE P.invoice_id = PL.invoice_id
811: AND P.check_id = C.check_id
812: AND (((P.posted_flag <> 'Y'

Line 899: from ap_invoice_payments aip

895:
896: DELETE FROM ap_purge_invoice_list PL
897: where EXISTS(
898: select 'history not purgeable'
899: from ap_invoice_payments aip
900: , ap_payment_history aph
901: where aip.invoice_id = PL.invoice_id
902: and aip.check_id = aph.check_id
903: -- To check for posted_flag added for bug#2274656

Line 940: ap_invoice_payments aip,

936: OR EXISTS (
937: Select 'payment accounting not purgeable'
938: from xla_events xe, --Bug 4588031
939: xla_transaction_entities xte, --Bug 4588031
940: ap_invoice_payments aip,
941: ap_system_parameters_all asp,--bug5052478
942: xla_ae_headers xeh --Bug 4588031
943: where xte.entity_code = 'AP_PAYMENTS'
944: and xte.source_id_int_1 = aip.check_id

Line 1169: FROM ap_invoice_payments IP1,

1165: DELETE
1166: FROM ap_purge_invoice_list PL
1167: WHERE EXISTS (
1168: SELECT 'relational problem'
1169: FROM ap_invoice_payments IP1,
1170: ap_invoice_payments IP2
1171: WHERE PL.invoice_id = IP1.invoice_id
1172: AND IP1.check_id = IP2.check_id
1173: AND IP2.invoice_id NOT IN (

Line 1170: ap_invoice_payments IP2

1166: FROM ap_purge_invoice_list PL
1167: WHERE EXISTS (
1168: SELECT 'relational problem'
1169: FROM ap_invoice_payments IP1,
1170: ap_invoice_payments IP2
1171: WHERE PL.invoice_id = IP1.invoice_id
1172: AND IP1.check_id = IP2.check_id
1173: AND IP2.invoice_id NOT IN (
1174: SELECT PL2.invoice_id

Line 1188: FROM ap_invoice_payments IP1, ap_invoice_payments IP2

1184: SET PL.double_check_flag = 'N'
1185: WHERE PL.double_check_flag = 'Y'
1186: AND EXISTS (
1187: SELECT /*+NO_UNNEST*/'relational problem'
1188: FROM ap_invoice_payments IP1, ap_invoice_payments IP2
1189: WHERE PL.invoice_id = IP1.invoice_id
1190: AND IP1.check_id = IP2.check_id
1191: AND IP2.invoice_id NOT IN (
1192: SELECT PL2.invoice_id

Line 2166: ap_invoice_payments_all IP,

2162: ac.amount, ac.currency_code, DECODE(void_date, null, null, 'Y'),
2163: p_purge_name, ac.doc_sequence_id, ac.doc_sequence_value, ac.payment_id,
2164: ac.org_id
2165: FROM ap_checks_all AC,
2166: ap_invoice_payments_all IP,
2167: ap_purge_invoice_list PL
2168: WHERE PL.invoice_id = IP.invoice_id
2169: AND IP.check_id = AC.check_id
2170: AND PL.double_check_flag = 'Y'

Line 2193: FROM ap_invoice_payments_all IP, ap_purge_invoice_list PL

2189: INSERT INTO ap_history_inv_payments_all
2190: (invoice_id, check_id, amount,org_id)
2191: SELECT
2192: IP.invoice_id, IP.check_id, SUM(IP.amount),IP.org_id
2193: FROM ap_invoice_payments_all IP, ap_purge_invoice_list PL
2194: WHERE IP.invoice_id = PL.invoice_id
2195: AND PL.double_check_flag = 'Y'
2196: AND PL.invoice_id BETWEEN range_low AND range_high
2197: GROUP BY IP.invoice_id, IP.check_id,

Line 2860: FROM ap_invoice_payments P, ap_checks C

2856: SET PL.double_check_flag = 'N'
2857: WHERE PL.double_check_flag = 'Y'
2858: AND EXISTS (
2859: SELECT /*+NO_UNNEST*/'payment no longer purgeable'
2860: FROM ap_invoice_payments P, ap_checks C
2861: WHERE P.invoice_id = PL.invoice_id
2862: AND P.check_id = C.check_id
2863: AND (P.posted_flag <> 'Y'
2864: OR P.last_update_date > g_activity_date

Line 2963: , ap_invoice_payments aip

2959: OR ( xeh.last_update_date > g_activity_date)))
2960: OR EXISTS (
2961: SELECT 'payment accounting not purgeable'
2962: FROM xla_events xe
2963: , ap_invoice_payments aip
2964: , ap_checks apc
2965: , xla_ae_headers xeh
2966: , xla_transaction_entities xte
2967: WHERE xte.entity_code = 'AP_CHECKS'

Line 3021: ap_invoice_payments ip

3017:
3018: CURSOR c_main IS
3019: select pl.invoice_id
3020: from ap_purge_invoice_list pl,
3021: ap_invoice_payments ip
3022: where pl.invoice_id = ip.invoice_id;
3023:
3024: CURSOR c_main_check(l_invoice_id NUMBER) IS
3025: select invoice_id

Line 3048: from ap_invoice_payments ip,

3044: Function Check_inv(l_check_id IN NUMBER) RETURN BOOLEAN IS
3045:
3046: CURSOR c_inv IS
3047: select pil.invoice_id
3048: from ap_invoice_payments ip,
3049: ap_purge_invoice_list pil
3050: where ip.check_id = l_check_id
3051: and ip.invoice_id = pil.invoice_id (+)
3052: and pil.double_check_flag = 'Y';

Line 3094: from ap_invoice_payments

3090: Function Check_check(l_invoice_id IN NUMBER ) RETURN BOOLEAN IS
3091:
3092: CURSOR c_check IS
3093: select check_id
3094: from ap_invoice_payments
3095: where invoice_id = l_invoice_id ;
3096:
3097: l_flag BOOLEAN := FALSE;
3098: l_check_id number;

Line 3197: from ap_invoice_payments

3193: p_id := tab_check.next(p_id) ;
3194: UPDATE ap_purge_invoice_list
3195: SET double_check_flag = 'N'
3196: WHERE invoice_id in ( select invoice_id
3197: from ap_invoice_payments
3198: where check_id = p_id);
3199: END LOOP;
3200: END IF;
3201:

Line 3266: debug_info := 'ap_invoice_payments';

3262: INTO fp_check_rows
3263: FROM ap_checks;
3264:
3265: --
3266: debug_info := 'ap_invoice_payments';
3267: IF g_debug_switch in ('y','Y') THEN
3268: Print('(Count_Ap_Rows)'||debug_info);
3269: END IF;
3270:

Line 3274: FROM ap_invoice_payments;

3270:
3271: --
3272: SELECT count(*)
3273: INTO fp_invoice_payment_rows
3274: FROM ap_invoice_payments;
3275:
3276: --
3277: debug_info := 'ap_invoices';
3278: IF g_debug_switch in ('y','Y') THEN

Line 4028: ap_invoice_payments = fp_invoice_payment_rows,

4024:
4025: UPDATE financials_purges
4026: SET
4027: ap_checks = fp_check_rows,
4028: ap_invoice_payments = fp_invoice_payment_rows,
4029: ap_invoices = fp_invoice_rows,
4030: po_headers = fp_po_header_rows ,
4031: po_receipts = fp_receipt_line_rows,
4032: po_requisition_headers = fp_req_header_rows,

Line 4065: FROM ap_invoice_payments aip

4061: UPDATE ap_purge_invoice_list PL
4062: SET PL.double_check_flag = 'N'
4063: WHERE EXISTS (
4064: SELECT 'history not purgeable'
4065: FROM ap_invoice_payments aip
4066: , ap_payment_history aph
4067: WHERE aip.invoice_id = PL.invoice_id
4068: and aip.check_id = aph.check_id
4069: and aph.last_update_date > g_activity_date);

Line 4677: FROM ap_invoice_payments P, ap_purge_invoice_list PL,

4673: RETURN BOOLEAN IS
4674:
4675: CURSOR overflow_select is
4676: SELECT C.check_stock_id,C.check_number
4677: FROM ap_invoice_payments P, ap_purge_invoice_list PL,
4678: ap_checks C
4679: WHERE P.invoice_id = PL.invoice_id
4680: AND P.check_id = C.check_id
4681: AND PL.double_check_flag = 'Y'

Line 4948: l_invoice_payment_id ap_invoice_payments.invoice_payment_id%TYPE;

4944: l_invoice_id ap_invoices.invoice_id%TYPE;
4945: l_invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
4946: l_check_id ap_checks.check_id%TYPE;
4947: l_payment_history_id ap_payment_history.payment_history_id%TYPE;
4948: l_invoice_payment_id ap_invoice_payments.invoice_payment_id%TYPE;
4949:
4950: BEGIN
4951:
4952: -- Update the calling sequence

Line 5016: ap_invoice_payments IP

5012: WHERE (AUD.doc_sequence_id , AUD.doc_sequence_value)
5013: IN (SELECT C.doc_sequence_id , C.doc_sequence_value
5014: FROM ap_purge_invoice_list PL,
5015: ap_checks C,
5016: ap_invoice_payments IP
5017: WHERE PL.double_check_flag = 'Y'
5018: AND PL.invoice_id BETWEEN range_low AND range_high
5019: AND PL.invoice_id = IP.invoice_id
5020: AND IP.check_id = C.check_id ) ;

Line 5048: FROM ap_invoice_payments P, ap_purge_invoice_list PL

5044: -- bug 5052764 - go to base table ap_checks_all to remove FTS
5045: DELETE FROM ap_checks_all C
5046: WHERE C.check_id IN (
5047: SELECT P.check_id
5048: FROM ap_invoice_payments P, ap_purge_invoice_list PL
5049: WHERE P.invoice_id = PL.invoice_id
5050: AND PL.double_check_flag = 'Y'
5051: AND PL.invoice_id BETWEEN range_low AND range_high);
5052:

Line 5075: FROM ap_invoice_payments aip

5071:
5072: DELETE FROM ap_payment_history aph
5073: WHERE EXISTS (
5074: SELECT 'history purgeable'
5075: FROM ap_invoice_payments aip
5076: , ap_purge_invoice_list PL
5077: WHERE aip.invoice_id = PL.invoice_id
5078: and aip.check_id = aph.check_id
5079: and PL.double_check_flag = 'Y');

Line 5081: debug_info := 'ap_invoice_payments';

5077: WHERE aip.invoice_id = PL.invoice_id
5078: and aip.check_id = aph.check_id
5079: and PL.double_check_flag = 'Y');
5080:
5081: debug_info := 'ap_invoice_payments';
5082: IF g_debug_switch in ('y','Y') THEN
5083: Print('(Delete_AP_Tables)'||debug_info);
5084: END IF;
5085:

Line 5089: DELETE FROM ap_invoice_payments

5085:
5086:
5087: -- delete_invoice_payments
5088:
5089: DELETE FROM ap_invoice_payments
5090: WHERE invoice_id IN (
5091: SELECT PL.invoice_id
5092: FROM ap_purge_invoice_list PL
5093: WHERE PL.double_check_flag = 'Y'

Line 5386: ,ap_invoice_payments aip

5382: WHERE ael.ae_header_id in
5383: ( SELECT aeh.ae_header_id
5384: FROM ap_ae_headers aeh -- bug 2153117 added
5385: ,ap_accounting_events aae
5386: ,ap_invoice_payments aip
5387: ,ap_purge_invoice_list pil
5388: WHERE aae.source_id = aip.check_id
5389: and aae.source_table = 'AP_CHECKS'
5390: and pil.double_check_flag = 'Y'

Line 5419: , ap_invoice_payments aip

5415: DELETE FROM ap_ae_headers aeh
5416: WHERE aeh.accounting_event_id in
5417: ( SELECT aae.accounting_event_id
5418: FROM ap_accounting_events aae
5419: , ap_invoice_payments aip
5420: , ap_purge_invoice_list pil
5421: -- bug2153117 removed
5422: -- , ap_ae_headers aeh
5423: WHERE aae.source_id = aip.check_id

Line 5466: AP_INVOICE_PAYMENTS AIP

5462: DELETE FROM AP_ACCOUNTING_EVENTS AAE WHERE
5463: aae.source_id in ( SELECT APC.CHECK_ID
5464: FROM AP_PURGE_INVOICE_LIST PIL,
5465: AP_CHECKS APC,
5466: AP_INVOICE_PAYMENTS AIP
5467: WHERE PIL.DOUBLE_CHECK_FLAG = 'Y'
5468: AND APC.CHECK_ID = AIP.CHECK_ID
5469: AND AIP.INVOICE_ID = PIL.INVOICE_ID
5470: AND PIL.INVOICE_ID BETWEEN range_low

Line 5478: AP_INVOICE_PAYMENTS AIP,

5474:
5475: DELETE FROM AP_ACCOUNTING_EVENTS AAE WHERE
5476: AAE.source_id IN ( SELECT APH.CHECK_ID
5477: FROM AP_PURGE_INVOICE_LIST PIL,
5478: AP_INVOICE_PAYMENTS AIP,
5479: AP_PAYMENT_HISTORY APH
5480: WHERE PIL.DOUBLE_CHECK_FLAG = 'Y'
5481: AND APH.CHECK_ID = AIP.CHECK_ID
5482: AND AIP.INVOICE_ID = PIL.INVOICE_ID

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

6501: -- record_final_statistics
6502: UPDATE financials_purges
6503: SET
6504: ap_checks = nvl(ap_checks, 0) - check_rows,
6505: ap_invoice_payments = nvl(ap_invoice_payments, 0) - invoice_payment_rows,
6506: ap_invoices = nvl(ap_invoices, 0) - invoice_rows,
6507: po_headers = nvl(po_headers, 0) - po_header_rows,
6508: po_requisition_headers = nvl(po_requisition_headers, 0) - req_header_rows,
6509: po_vendors = nvl(po_vendors, 0) - vendor_rows,