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_AUTO_PAYMENT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 389: from ap_invoice_distributions aid

385:
386: -- BUG 4121323 : selecting base_amount
387: select sum(nvl(aid.base_amount,aid.amount))
388: into l_prev_withheld_amt
389: from ap_invoice_distributions aid
390: where aid.invoice_id=rec_new_payments.invoice_id
391: and aid.awt_invoice_payment_id
392: in (select invoice_payment_id
393: from ap_invoice_payments aip

Line 405: AP_INVOICE_DISTRIBUTIONS AID

401: /* Bug 3309344 commenting this select statement
402: SELECT MAX(AID.awt_gross_amount)
403: INTO l_awt_gross_amount
404: FROM AP_INVOICE_PAYMENTS AIP,
405: AP_INVOICE_DISTRIBUTIONS AID
406: WHERE AIP.invoice_id = rec_new_payments.invoice_id
407: AND AIP.check_id = p_old_check_id
408: AND AIP.reversal_inv_pmt_id IS NULL
409: AND AID.awt_invoice_payment_id = AIP.invoice_payment_id;

Line 668: FROM ap_invoice_distributions AID

664: INTO l_call_withholding
665: FROM ap_invoices AI
666: WHERE AI.invoice_id = p_invoice_id
667: AND EXISTS ( SELECT 'At least 1 AWT line created automatically at payment time'
668: FROM ap_invoice_distributions AID
669: WHERE aid.invoice_id = ai.invoice_id
670: AND aid.awt_invoice_payment_id is not null);
671:
672: RETURN(TRUE);