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.ARP_ARXVASUM dependencies on AR_TRANSACTION_HISTORY

Line 1115: from ar_transaction_history trh,

1111: count(ps.amount_due_remaining)
1112: into p_BR_protested_amt,
1113: p_BR_protested_func_amt,
1114: p_BR_protested_count
1115: from ar_transaction_history trh,
1116: ar_payment_schedules ps
1117: where trh.gl_date between p_start_date and p_end_date
1118: and trh.status = 'PROTESTED'
1119: and nvl(trh.current_record_flag,'Y') = 'Y'

Line 1174: from ar_transaction_history trh,

1170: count(ps.amount_due_remaining)
1171: into p_BR_unpaid_amt,
1172: p_BR_unpaid_func_amt,
1173: p_BR_unpaid_count
1174: from ar_transaction_history trh,
1175: ar_payment_schedules ps
1176: where trh.gl_date between p_start_date and p_end_date
1177: and trh.status = 'UNPAID'
1178: and nvl(trh.current_record_flag,'Y') = 'Y'

Line 1232: from ar_transaction_history trh,

1228: count(distinct ctl.customer_trx_id)
1229: into p_BR_pend_acceptance_amt,
1230: p_BR_pend_acceptance_func_amt,
1231: p_BR_pend_acceptance_count
1232: from ar_transaction_history trh,
1233: ra_customer_trx ct,
1234: ra_customer_trx_lines ctl
1235: where trh.gl_date between p_start_date and p_end_date
1236: and trh.status = 'PENDING_ACCEPTANCE'