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_DISTRIBUTIONS

Line 704: FROM ap_invoice_distributions d

700: DELETE
701: FROM ap_purge_invoice_list PL
702: WHERE EXISTS
703: (SELECT 'project-related vendor invoices'
704: FROM ap_invoice_distributions d
705: WHERE d.invoice_id = pl.invoice_id
706: AND d.project_id is not null) -- bug1746226
707: OR EXISTS
708: (SELECT 'project-related expense report'

Line 741: FROM ap_invoice_distributions D, ap_invoices I

737: DELETE
738: FROM ap_purge_invoice_list PL
739: WHERE EXISTS
740: (SELECT 'distributions not purgeable'
741: FROM ap_invoice_distributions D, ap_invoices I
742: WHERE I.invoice_id = D.invoice_id
743: AND PL.invoice_id = D.invoice_id
744: AND ( D.last_update_date > g_activity_date
745: OR D.posted_flag <> 'Y'

Line 771: FROM ap_invoice_distributions D, ap_invoices I

767: DELETE
768: FROM ap_purge_invoice_list PL
769: WHERE EXISTS
770: (SELECT 'distributions not purgeable'
771: FROM ap_invoice_distributions D, ap_invoices I
772: WHERE I.invoice_id = D.invoice_id
773: AND PL.invoice_id = D.invoice_id
774: AND ( D.last_update_date > g_activity_date
775: OR D.posted_flag <> 'Y'

Line 882: FROM ap_invoice_distributions ID

878: DELETE
879: FROM ap_purge_invoice_list PL
880: WHERE EXISTS
881: (SELECT 'X'
882: FROM ap_invoice_distributions ID
883: WHERE PL.invoice_id = ID.invoice_id
884: AND ID.line_type_lookup_code = 'PREPAY'
885: AND ID.prepay_distribution_id IS NOT NULL);
886:

Line 965: from ap_invoice_distributions aid, rcv_transactions rcv

961:
962: DELETE FROM ap_purge_invoice_list PL
963: WHERE EXISTS (
964: select 'matched'
965: from ap_invoice_distributions aid, rcv_transactions rcv
966: where aid.invoice_id = PL.invoice_id
967: and aid.rcv_transaction_id = rcv.transaction_id
968: and rcv.last_update_date > g_activity_date);
969:

Line 973: from ap_invoice_distributions ad

969:
970: DELETE FROM ap_purge_invoice_list PL
971: WHERE EXISTS
972: (select null
973: from ap_invoice_distributions ad
974: where ad.invoice_id = PL.invoice_id
975: and ad.rcv_transaction_id is not null
976: and exists (
977: select 'matching' from ap_invoice_distributions ad2

Line 977: select 'matching' from ap_invoice_distributions ad2

973: from ap_invoice_distributions ad
974: where ad.invoice_id = PL.invoice_id
975: and ad.rcv_transaction_id is not null
976: and exists (
977: select 'matching' from ap_invoice_distributions ad2
978: where ad2.rcv_transaction_id = ad.rcv_transaction_id
979: and ad2.invoice_id NOT IN (
980: select invoice_id
981: from ap_purge_invoice_list

Line 1100: from ap_invoice_distributions ad

1096: IF p_purge_status = 'INITIATING' THEN
1097: delete from ap_purge_invoice_list apl
1098: where exists
1099: (select null
1100: from ap_invoice_distributions ad
1101: where ad.invoice_id = apl.invoice_id
1102: and ad.po_distribution_id is not null
1103: and not exists (select null
1104: from po_purge_po_list ppl,

Line 1117: from ap_invoice_distributions ad,po_distributions pd

1113: update ap_purge_invoice_list apl
1114: set double_check_flag = 'N'
1115: where double_check_flag = 'Y'
1116: and exists (select /*+NO_UNNEST*/ null
1117: from ap_invoice_distributions ad,po_distributions pd
1118: where ad.invoice_id = apl.invoice_id
1119: AND pd.po_distribution_id=ad.po_distribution_id
1120: and ad.po_distribution_id is not null
1121: and not exists (SELECT null

Line 1410: FROM ap_invoices I, ap_invoice_distributions D

1406:
1407: INSERT INTO ap_purge_invoice_list
1408: (invoice_id, purge_name, double_check_flag)
1409: SELECT DISTINCT I.invoice_id, p_purge_name, 'Y'
1410: FROM ap_invoices I, ap_invoice_distributions D
1411: WHERE I.invoice_id = D.invoice_id
1412: AND I.payment_status_flag || '' = 'Y'
1413: AND I.invoice_type_lookup_code <> 'PREPAYMENT'
1414: AND D.posted_flag || '' = 'Y'

Line 1424: FROM ap_invoices I, ap_invoice_distributions D

1420: AND I.last_update_date <= g_activity_date
1421: AND I.invoice_date <= g_activity_date
1422: UNION
1423: SELECT I.invoice_id, p_purge_name, 'Y'
1424: FROM ap_invoices I, ap_invoice_distributions D
1425: WHERE I.invoice_id = D.invoice_id (+)
1426: AND I.last_update_date <= g_activity_date
1427: AND I.invoice_date <= g_activity_date
1428: AND I.invoice_amount = 0

Line 2756: FROM ap_invoice_distributions d

2752: SET PL.double_check_flag = 'N'
2753: WHERE PL.double_check_flag = 'Y'
2754: AND (EXISTS
2755: (SELECT 'project-related vendor invoices'
2756: FROM ap_invoice_distributions d
2757: WHERE d.invoice_id = pl.invoice_id
2758: AND d.project_id is not null -- bug1746226
2759: )
2760: OR EXISTS

Line 2815: FROM ap_invoice_distributions D, ap_invoices I

2811: SET PL.double_check_flag = 'N'
2812: WHERE PL.double_check_flag = 'Y'
2813: AND EXISTS
2814: (SELECT /*+NO_UNNEST*/ 'distribution no longer purgeable'
2815: FROM ap_invoice_distributions D, ap_invoices I
2816: WHERE I.invoice_id = D.invoice_id
2817: AND PL.invoice_id = D.invoice_id
2818: AND ( D.last_update_date > g_activity_date
2819: OR D.posted_flag <> 'Y'

Line 2834: FROM ap_invoice_distributions D, ap_invoices I

2830: SET PL.double_check_flag = 'N'
2831: WHERE PL.double_check_flag = 'Y'
2832: AND EXISTS
2833: (SELECT /*+NO_UNNEST*/'distribution no longer purgeable'
2834: FROM ap_invoice_distributions D, ap_invoices I
2835: WHERE I.invoice_id = D.invoice_id
2836: AND PL.invoice_id = D.invoice_id
2837: AND ( D.last_update_date > g_activity_date
2838: OR D.posted_flag <> 'Y'

Line 2898: FROM ap_invoice_distributions aid

2894: UPDATE ap_purge_invoice_list PL
2895: SET PL.double_check_flag = 'N'
2896: WHERE EXISTS (
2897: SELECT 'matched'
2898: FROM ap_invoice_distributions aid
2899: , rcv_transactions rcv
2900: WHERE aid.invoice_id = PL.invoice_id
2901: and aid.rcv_transaction_id = rcv.transaction_id
2902: --Bug 1579474

Line 2917: FROM ap_invoice_distributions ad

2913: UPDATE ap_purge_invoice_list PL
2914: SET double_check_flag = 'N'
2915: WHERE EXISTS (
2916: SELECT null
2917: FROM ap_invoice_distributions ad
2918: WHERE ad.invoice_id = PL.invoice_id
2919: and ad.rcv_transaction_id IS NOT NULL
2920: and EXISTS (
2921: SELECT 'matching'

Line 2922: FROM ap_invoice_distributions ad2

2918: WHERE ad.invoice_id = PL.invoice_id
2919: and ad.rcv_transaction_id IS NOT NULL
2920: and EXISTS (
2921: SELECT 'matching'
2922: FROM ap_invoice_distributions ad2
2923: where ad2.rcv_transaction_id = ad.rcv_transaction_id
2924: and ad2.invoice_id NOT IN (
2925: SELECT invoice_id
2926: FROM ap_purge_invoice_list

Line 4945: l_invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;

4941: WHERE PL.double_check_flag = 'Y'
4942: AND PL.invoice_id BETWEEN low_inv_id AND high_inv_id;
4943:
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:

Line 5001: from ap_invoice_distributions aid

4997:
4998: delete from ap_chrg_allocations aca
4999: where exists (
5000: select 'allocations'
5001: from ap_invoice_distributions aid
5002: , ap_purge_invoice_list pil
5003: where aca.item_dist_id = aid.invoice_distribution_id
5004: and pil.invoice_id = aid.invoice_id
5005: and pil.invoice_id BETWEEN range_low and range_high

Line 5159: debug_info := 'ap_invoice_distributions';

5155: WHERE PL.double_check_flag = 'Y'
5156: AND PL.invoice_id BETWEEN range_low AND range_high);
5157:
5158:
5159: debug_info := 'ap_invoice_distributions';
5160: IF g_debug_switch in ('y','Y') THEN
5161: Print('(Delete_AP_Tables)'||debug_info);
5162: END IF;
5163:

Line 5165: DELETE FROM ap_invoice_distributions

5161: Print('(Delete_AP_Tables)'||debug_info);
5162: END IF;
5163:
5164:
5165: DELETE FROM ap_invoice_distributions
5166: WHERE invoice_id IN (
5167: SELECT PL.invoice_id
5168: FROM ap_purge_invoice_list PL
5169: WHERE PL.double_check_flag = 'Y'

Line 5442: , ap_invoice_distributions aid

5438: DELETE FROM ap_encumbrance_lines aen
5439: WHERE EXISTS (
5440: SELECT 'dist'
5441: FROM ap_purge_invoice_list pil
5442: , ap_invoice_distributions aid
5443: WHERE aen.invoice_distribution_id = aid.invoice_distribution_id
5444: and aid.invoice_id = pil.invoice_id
5445: and pil.double_check_flag = 'Y'
5446: and pil.invoice_id BETWEEN range_low AND range_high);