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 912: ar_cash_receipt_history_all crh,

908: IF p_party_id IS NOT NULL THEN
909: SELECT SUM(cr.amount) NSF_STOP_PAYMENT_AMOUNT
910: INTO l_nsf_stop_payment_amount
911: FROM ar_cash_receipts_all cr,
912: ar_cash_receipt_history_all crh,
913: hz_cust_accounts ca
914: WHERE cr.cash_receipt_id = crh.cash_receipt_id
915: AND crh.current_record_flag = 'Y'
916: AND crh.status = 'REVERSED'

Line 931: ar_cash_receipt_history_all crh

927: ELSIF p_cust_account_id IS NOT NULL THEN
928: SELECT SUM(cr.amount) NSF_STOP_PAYMENT_AMOUNT
929: INTO l_nsf_stop_payment_amount
930: FROM ar_cash_receipts_all cr,
931: ar_cash_receipt_history_all crh
932: WHERE cr.cash_receipt_id = crh.cash_receipt_id
933: AND crh.current_record_flag = 'Y'
934: AND crh.status = 'REVERSED'
935: -- BEGIN fix bug #4483830--20050714-jypark-change query for NSF info

Line 948: ar_cash_receipt_history_all crh

944: ELSIF p_customer_site_use_id IS NOT NULL THEN
945: SELECT SUM(cr.amount) NSF_STOP_PAYMENT_AMOUNT
946: INTO l_nsf_stop_payment_amount
947: FROM ar_cash_receipts_all cr,
948: ar_cash_receipt_history_all crh
949: WHERE cr.cash_receipt_id = crh.cash_receipt_id
950: AND crh.current_record_flag = 'Y'
951: AND crh.status = 'REVERSED'
952: -- BEGIN fix bug #4483830--20050714-jypark-change query for NSF info