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_ARXCCS_XMLP_PKG dependencies on AR_CASH_RECEIPT_HISTORY

Line 670: ar_cash_receipt_history acrh

666: into l_ytd_nsf_amount,
667: l_ytd_convert_nsf,
668: l_ytd_nsf_count
669: from ar_cash_receipts,
670: ar_cash_receipt_history acrh
671: --where ar_cash_receipts.pay_from_customer = customer_id
672: where ar_cash_receipts.pay_from_customer = customer_id_1
673: and ar_cash_receipts.cash_receipt_id = acrh.cash_receipt_id
674: and acrh.first_posted_record_flag = 'Y'

Line 1833: AR_CASH_RECEIPT_HISTORY CRH,

1829: ROUND(TRUNC(SYSDATE) - CRH.GL_DATE),
1830: RA_CUSTOMER_TRX.TRX_NUMBER
1831: FROM AR_LOOKUPS,
1832: AR_CASH_RECEIPTS,
1833: AR_CASH_RECEIPT_HISTORY CRH,
1834: AR_RECEIVABLE_APPLICATIONS,
1835: RA_CUSTOMER_TRX
1836: WHERE NVL(AR_CASH_RECEIPTS.TYPE, 'CASH') = AR_LOOKUPS.LOOKUP_CODE
1837: AND AR_LOOKUPS.LOOKUP_TYPE = 'PAYMENT_CATEGORY_TYPE'