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_PAYMENT_SCHEDULES

Line 101: -- 3641604 ap_payment_schedules aps

97: ap_invoices_all ai,
98: ap_invoice_distributions_all aid1,
99: fnd_lookup_types_vl lkp,
100: fnd_lookup_values_vl lkv
101: -- 3641604 ap_payment_schedules aps
102: WHERE
103: ai.invoice_id = aid1.invoice_id
104: -- and ai.payment_status_flag<>'P'
105: -- Fix for 2545297 commented above line and wrote below one

Line 146: FROM ap_payment_schedules

142: */
143:
144: CURSOR ps_cursor (p_invoice_id NUMBER) IS
145: SELECT payment_num
146: FROM ap_payment_schedules
147: WHERE invoice_id = p_invoice_id;
148:
149:
150: BEGIN --#1

Line 243: ap_payment_schedules_pkg.get_discount_available

239: l_sum_discount := 0;
240: FOR ps_rec IN ps_cursor(inv_rec.invoice_id) LOOP
241: BEGIN
242: l_sum_discount := l_sum_discount +
243: ap_payment_schedules_pkg.get_discount_available
244: (inv_rec.invoice_id, ps_rec.payment_num, sysdate,
245: inv_rec.invoice_currency_code);
246: EXCEPTION
247: WHEN NO_DATA_FOUND