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_AUTOSELECT_PKG dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 461: update ap_payment_schedules_all

457:
458:
459: l_debug_info := 'update payment schedules';
460:
461: update ap_payment_schedules_all
462: set checkrun_id = null
463: where checkrun_id = p_checkrun_id;
464:
465:

Line 555: update ap_payment_schedules_all

551: l_remove_invoices(i).org_id);
552:
553:
554:
555: update ap_payment_schedules_all
556: set checkrun_id = null
557: where invoice_id = l_remove_invoices(i).invoice_id
558: and payment_num = l_remove_invoices(i).payment_num
559: and checkrun_id = p_checkrun_id;

Line 970: ap_payment_schedules_all aps,

966: --Bug 543942 added NVL in the above scenario
967: from ap_selected_invoices_all asi,
968: ap_invoices ai, --Bug6040657. Changed from ap_invoices_all to ap_invoices
969: ap_inv_selection_criteria_all aisc,
970: ap_payment_schedules_all aps,
971: fv_tpp_assignments_v fv, --5017076
972: iby_payment_methods_vl ipm -- Bug 5357689
973: where asi.invoice_id = ai.invoice_id
974: and aps.invoice_id = asi.invoice_id

Line 2044: ap_payment_schedules_all ps,

2040: ,Null payment_exchange_date
2041: FROM ap_supplier_sites_all sites,
2042: ap_suppliers suppliers,
2043: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
2044: ap_payment_schedules_all ps,
2045: ap_system_parameters_all asp,
2046: hz_parties hzp,
2047: hz_party_sites hzps, -- Bug 5620285
2048: hz_locations hzl -- Bug 5620285

Line 2338: ap_payment_schedules_all ps,

2334: ,Null payment_exchange_date
2335: FROM ap_supplier_sites_all sites,
2336: ap_suppliers suppliers,
2337: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
2338: ap_payment_schedules_all ps,
2339: ap_system_parameters_all asp,
2340: hz_parties hzp,
2341: hz_party_sites hzps, -- Bug 5620285
2342: hz_locations hzl -- Bug 5620285

Line 2815: l_debug_info := 'Update ap_payment_schedules_all: encumbrances are on';

2811: ,sel_inv_list.payment_exchange_date_l
2812: LIMIT 1000;
2813:
2814:
2815: l_debug_info := 'Update ap_payment_schedules_all: encumbrances are on';
2816: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2817: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
2818: END IF;
2819:

Line 2826: UPDATE Ap_Payment_Schedules_All

2822: END IF;
2823:
2824:
2825: FORALL i IN sel_inv_list.invoice_id_l.FIRST .. sel_inv_list.invoice_id_l.LAST
2826: UPDATE Ap_Payment_Schedules_All
2827: SET checkrun_id = sel_inv_list.checkrun_id_l(i)
2828: WHERE invoice_id = sel_inv_list.invoice_id_l(i)
2829: AND payment_num = sel_inv_list.payment_num_l(i)
2830: AND checkrun_id IS NULL --bug 6788730

Line 3016: FROM Ap_Payment_Schedules_All

3012: ,sel_inv_list.global_attribute18_l(i)
3013: ,sel_inv_list.global_attribute19_l(i)
3014: ,sel_inv_list.global_attribute20_l(i)
3015: ,sel_inv_list.global_attribute_category_l(i)
3016: FROM Ap_Payment_Schedules_All
3017: WHERE invoice_id = sel_inv_list.invoice_id_l(i)
3018: AND payment_num = sel_inv_list.payment_num_l(i)
3019: AND checkrun_id = sel_inv_list.checkrun_id_l(i)
3020: --bug 6788730

Line 3179: l_debug_info := 'Update ap_payment_schedules_all: encumbrances are off';

3175: ,sel_inv_list.payment_exchange_rate_type_l
3176: ,sel_inv_list.payment_exchange_date_l
3177: LIMIT 1000;
3178:
3179: l_debug_info := 'Update ap_payment_schedules_all: encumbrances are off';
3180: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3181: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
3182: END IF;
3183:

Line 3190: UPDATE Ap_Payment_Schedules_All

3186: END IF;
3187:
3188:
3189: FORALL i IN sel_inv_list.invoice_id_l.FIRST .. sel_inv_list.invoice_id_l.LAST
3190: UPDATE Ap_Payment_Schedules_All
3191: SET checkrun_id = sel_inv_list.checkrun_id_l(i)
3192: WHERE invoice_id = sel_inv_list.invoice_id_l(i)
3193: AND payment_num = sel_inv_list.payment_num_l(i)
3194: AND checkrun_id IS NULL --bug 6788730

Line 3381: FROM Ap_Payment_Schedules_All

3377: ,sel_inv_list.global_attribute18_l(i)
3378: ,sel_inv_list.global_attribute19_l(i)
3379: ,sel_inv_list.global_attribute20_l(i)
3380: ,sel_inv_list.global_attribute_category_l(i)
3381: FROM Ap_Payment_Schedules_All
3382: WHERE invoice_id = sel_inv_list.invoice_id_l(i)
3383: AND payment_num = sel_inv_list.payment_num_l(i)
3384: AND checkrun_id = sel_inv_list.checkrun_id_l(i)
3385: --bug 6788730

Line 3413: UPDATE Ap_Payment_Schedules_All aps

3409: END IF;
3410:
3411:
3412: -- Bug 5646890. Added l_checkrun_id condition for performance reason
3413: UPDATE Ap_Payment_Schedules_All aps
3414: SET checkrun_id = null
3415: WHERE checkrun_id = l_checkrun_id
3416: AND NOT EXISTS (SELECT /*+HASH_AJ */ 'no row in asi'
3417: FROM ap_selected_invoices_all asi

Line 3609: FROM ap_payment_schedules_all PS,

3605: 0) * DECODE(SIGN(ps.gross_amount),-1,-1,1))
3606: * (PS.AMOUNT_REMAINING / DECODE(PS.GROSS_AMOUNT,
3607: 0, 1,
3608: PS.GROSS_AMOUNT))))
3609: FROM ap_payment_schedules_all PS,
3610: ap_invoices ai --Bug6040657. Changed from ap_invoices_all to ap_invoices
3611: WHERE PS.invoice_id = asi.invoice_id
3612: AND PS.payment_num = asi.payment_num
3613: and ai.invoice_id = ps.invoice_id)

Line 4634: update ap_payment_schedules_all

4630:
4631:
4632: l_debug_info := 'update payment schedules';
4633:
4634: update ap_payment_schedules_all
4635: set checkrun_id = null
4636: where checkrun_id = p_checkrun_id;
4637:
4638: update ap_inv_selection_criteria_all