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.AR_INVOICE_SQL_FUNC_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 216: FROM ar_payment_schedules

212:
213: SELECT -1 * (NVL(SUM(amount_line_items_original), 0) -
214: NVL(SUM(amount_line_items_remaining), 0))
215: INTO commit_total_activity
216: FROM ar_payment_schedules
217: WHERE customer_trx_id = p_init_cust_trx_id;
218:
219: ELSE commit_total_activity := 0;
220:

Line 388: FROM ar_payment_schedules

384:
385: SELECT -1 * (NVL(SUM(amount_line_items_original), 0) -
386: NVL(SUM(amount_line_items_remaining), 0))
387: INTO commit_total_activity
388: FROM ar_payment_schedules
389: WHERE customer_trx_id = p_init_cust_trx_id;
390:
391: ELSE commit_total_activity := 0;
392: