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 375: ar_cash_receipts cr

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

Line 392: to prevent FTS on table ar_cash_receipts */

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

Line 399: ar_cash_receipts cr

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