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_GET_CUSTOMER_BALANCE_PKG dependencies on AR_CASH_RECEIPTS

Line 373: ar_cash_receipts cr

369: nvl(sum(decode(ra.status ,'UNAPP',amount_applied, 0 )),0)
370: INTO l_on_acct_receipts ,
371: l_unapp_receipts
372: FROM ar_receivable_applications ra,
373: ar_cash_receipts cr
374: WHERE ra.cash_receipt_id = cr.cash_receipt_id
375: AND cr.pay_from_customer = cusinfo_rec.customer_id
376: AND cr.customer_site_use_id = siteinfo_rec.site_use_id
377: AND cr.currency_code = currency_rec.currency_code

Line 389: to prevent FTS on table ar_cash_receipts */

385: AND crh.trx_date+0 <= p_as_of_date ) ;
386:
387: ELSE
388: /* bug3692732 : Added cr.pay_from_customer = cusinfo_rec.customer_id to where clause
389: to prevent FTS on table ar_cash_receipts */
390:
391: SELECT nvl(sum(decode(ra.status , 'ACC', amount_applied, 0 )),0),
392: nvl(sum(decode(ra.status , 'UNAPP', amount_applied, 0)),0)
393: INTO l_on_acct_receipts ,

Line 396: ar_cash_receipts cr

392: nvl(sum(decode(ra.status , 'UNAPP', amount_applied, 0)),0)
393: INTO l_on_acct_receipts ,
394: l_unapp_receipts
395: FROM ar_receivable_applications ra,
396: ar_cash_receipts cr
397: WHERE ra.cash_receipt_id = cr.cash_receipt_id
398: AND cr.pay_from_customer = cusinfo_rec.customer_id
399: AND cr.currency_code = currency_rec.currency_code
400: AND cr.customer_site_use_id = siteinfo_rec.site_use_id