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_ARXVASUM2 dependencies on AR_TRANSACTION_HISTORY

Line 1104: from ar_transaction_history trh,

1100: count(ps.amount_due_remaining)
1101: into p_BR_protested_amt,
1102: p_BR_protested_func_amt,
1103: p_BR_protested_count
1104: from ar_transaction_history trh,
1105: ar_payment_schedules ps
1106: where trh.gl_date between p_start_date and p_end_date
1107: and trh.status = 'PROTESTED'
1108: and nvl(trh.current_record_flag,'Y') = 'Y'

Line 1162: from ar_transaction_history trh,

1158: count(ps.amount_due_remaining)
1159: into p_BR_unpaid_amt,
1160: p_BR_unpaid_func_amt,
1161: p_BR_unpaid_count
1162: from ar_transaction_history trh,
1163: ar_payment_schedules ps
1164: where trh.gl_date between p_start_date and p_end_date
1165: and trh.status = 'UNPAID'
1166: and nvl(trh.current_record_flag,'Y') = 'Y'

Line 1219: from ar_transaction_history trh,

1215: count(distinct ctl.customer_trx_id)
1216: into p_BR_pend_acceptance_amt,
1217: p_BR_pend_acceptance_func_amt,
1218: p_BR_pend_acceptance_count
1219: from ar_transaction_history trh,
1220: ra_customer_trx ct,
1221: ra_customer_trx_lines ctl
1222: where trh.gl_date between p_start_date and p_end_date
1223: and trh.status = 'PENDING_ACCEPTANCE'