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_RECEIPTS

Line 723: FROM ar_cash_receipts cr,

719:
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'

Line 742: FROM ar_cash_receipts cr,

738: AND ca.party_id = p_party_id;
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'

Line 759: FROM ar_cash_receipts cr,

755: AND cr.pay_from_customer = p_cust_account_id;
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'

Line 800: FROM ar_cash_receipts_all cr,

796:
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'

Line 819: FROM ar_cash_receipts_all cr,

815: AND ca.party_id = p_party_id;
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'

Line 836: FROM ar_cash_receipts_all cr,

832: AND cr.pay_from_customer = p_cust_account_id;
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'