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_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICE_PAYMENTS

Line 458: FROM ap_invoice_payments

454: BEGIN
455:
456: SELECT NVL(SUM(NVL(amount, 0)), 0)
457: INTO v_payment_amount
458: FROM ap_invoice_payments
459: WHERE invoice_id = p_invoice_id
460: AND accounting_date <= p_as_of_date;
461:
462: RETURN v_payment_amount;

Line 493: FROM ap_invoice_payments AIP, ap_invoices AI

489: 3542467: Get the discount taken
490: */
491: SELECT NVL(SUM(NVL(AIP.amount, 0)), 0), NVL(SUM(NVL(AIP.discount_taken, 0)), 0)
492: INTO v_payment_amount, v_discount_taken
493: FROM ap_invoice_payments AIP, ap_invoices AI
494: WHERE AIP.invoice_id = AI.invoice_id
495: AND AI.invoice_id = p_invoice_id
496: AND accounting_date <= p_as_of_date;
497: