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

Line 724: ar_cash_receipt_history crh,

720: IF p_party_id IS NOT NULL THEN
721: SELECT COUNT(cr.cash_receipt_id) NSF_STOP_PAYMENT_COUNT
722: INTO l_nsf_stop_payment_count
723: FROM ar_cash_receipts cr,
724: ar_cash_receipt_history crh,
725: hz_cust_accounts ca
726: WHERE cr.cash_receipt_id = crh.cash_receipt_id
727: AND crh.current_record_flag = 'Y'
728: AND crh.status = 'REVERSED'

Line 743: ar_cash_receipt_history crh

739: ELSIF p_cust_account_id IS NOT NULL THEN
740: SELECT COUNT(cr.cash_receipt_id) NSF_STOP_PAYMENT_COUNT
741: INTO l_nsf_stop_payment_count
742: FROM ar_cash_receipts cr,
743: ar_cash_receipt_history crh
744: WHERE cr.cash_receipt_id = crh.cash_receipt_id
745: AND crh.current_record_flag = 'Y'
746: AND crh.status = 'REVERSED'
747: -- BEGIN fix bug #4483830--20050714-jypark-change query for NSF info

Line 760: ar_cash_receipt_history crh

756: ELSIF p_customer_site_use_id IS NOT NULL THEN
757: SELECT COUNT(cr.cash_receipt_id) NSF_STOP_PAYMENT_COUNT
758: INTO l_nsf_stop_payment_count
759: FROM ar_cash_receipts cr,
760: ar_cash_receipt_history crh
761: WHERE cr.cash_receipt_id = crh.cash_receipt_id
762: AND crh.current_record_flag = 'Y'
763: AND crh.status = 'REVERSED'
764: -- BEGIN fix bug #4483830--20050714-jypark-change query for NSF info

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