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.IEX_COLL_IND dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 801: ar_cash_receipt_history_all crh,

797: IF p_party_id IS NOT NULL THEN
798: SELECT SUM(cr.amount) NSF_STOP_PAYMENT_AMOUNT
799: INTO l_nsf_stop_payment_amount
800: FROM ar_cash_receipts_all cr,
801: ar_cash_receipt_history_all crh,
802: hz_cust_accounts ca
803: WHERE cr.cash_receipt_id = crh.cash_receipt_id
804: AND crh.current_record_flag = 'Y'
805: AND crh.status = 'REVERSED'

Line 820: ar_cash_receipt_history_all crh

816: ELSIF p_cust_account_id IS NOT NULL THEN
817: SELECT SUM(cr.amount) NSF_STOP_PAYMENT_AMOUNT
818: INTO l_nsf_stop_payment_amount
819: FROM ar_cash_receipts_all cr,
820: ar_cash_receipt_history_all crh
821: WHERE cr.cash_receipt_id = crh.cash_receipt_id
822: AND crh.current_record_flag = 'Y'
823: AND crh.status = 'REVERSED'
824: -- BEGIN fix bug #4483830--20050714-jypark-change query for NSF info

Line 837: ar_cash_receipt_history_all crh

833: ELSIF p_customer_site_use_id IS NOT NULL THEN
834: SELECT SUM(cr.amount) NSF_STOP_PAYMENT_AMOUNT
835: INTO l_nsf_stop_payment_amount
836: FROM ar_cash_receipts_all cr,
837: ar_cash_receipt_history_all crh
838: WHERE cr.cash_receipt_id = crh.cash_receipt_id
839: AND crh.current_record_flag = 'Y'
840: AND crh.status = 'REVERSED'
841: -- BEGIN fix bug #4483830--20050714-jypark-change query for NSF info