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 835: ar_cash_receipt_history crh,

831: IF p_party_id IS NOT NULL THEN
832: SELECT COUNT(cr.cash_receipt_id) NSF_STOP_PAYMENT_COUNT
833: INTO l_nsf_stop_payment_count
834: FROM ar_cash_receipts cr,
835: ar_cash_receipt_history crh,
836: hz_cust_accounts ca
837: WHERE cr.cash_receipt_id = crh.cash_receipt_id
838: AND crh.current_record_flag = 'Y'
839: AND crh.status = 'REVERSED'

Line 854: ar_cash_receipt_history crh

850: ELSIF p_cust_account_id IS NOT NULL THEN
851: SELECT COUNT(cr.cash_receipt_id) NSF_STOP_PAYMENT_COUNT
852: INTO l_nsf_stop_payment_count
853: FROM ar_cash_receipts cr,
854: ar_cash_receipt_history crh
855: WHERE cr.cash_receipt_id = crh.cash_receipt_id
856: AND crh.current_record_flag = 'Y'
857: AND crh.status = 'REVERSED'
858: -- BEGIN fix bug #4483830--20050714-jypark-change query for NSF info

Line 871: ar_cash_receipt_history crh

867: ELSIF p_customer_site_use_id IS NOT NULL THEN
868: SELECT COUNT(cr.cash_receipt_id) NSF_STOP_PAYMENT_COUNT
869: INTO l_nsf_stop_payment_count
870: FROM ar_cash_receipts cr,
871: ar_cash_receipt_history crh
872: WHERE cr.cash_receipt_id = crh.cash_receipt_id
873: AND crh.current_record_flag = 'Y'
874: AND crh.status = 'REVERSED'
875: -- BEGIN fix bug #4483830--20050714-jypark-change query for NSF info

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