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.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 337: FROM ap_invoice_payments_all aipa,

333: ORDER BY rctgl.gl_date,party_id, invoice_number;
334:
335: CURSOR c_max_payment_date(cp_invoice_id NUMBER) IS
336: SELECT MAX(aca.check_date)
337: FROM ap_invoice_payments_all aipa,
338: ap_checks_all aca
339: WHERE aipa.invoice_id = cp_invoice_id
340: AND aca.check_id = aipa.check_id;
341:

Line 430: , ap_invoice_payments_all apip

426:
427: CURSOR c_paid_amt(cp_invoice_id NUMBER, cp_grace_date DATE) IS
428: SELECT nvl(SUM(apc.amount),0)
429: FROM ap_checks_all apc
430: , ap_invoice_payments_all apip
431: WHERE apc.check_id = apip.check_id
432: AND apip.invoice_id = cp_invoice_id
433: AND apc.check_date <= cp_grace_date;
434: