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 RA_CUSTOMER_TRX

Line 355: ra_customer_trx CT_DM,

351: (nvl(cr.reversal_category, cr.status||'X') = cr.status AND
352: 'Y' = (SELECT 'Y'
353: FROM ar_payment_schedules PS_DM,
354: ra_cust_trx_types CTT_DM,
355: ra_customer_trx CT_DM,
356: ra_cust_trx_line_gl_dist DM_GLD
357: WHERE PS_DM.reversed_cash_receipt_id = cr.cash_receipt_id
358: AND PS_DM.class = 'DM'
359: AND PS_DM.cust_trx_type_id = CTT_DM.cust_trx_type_id

Line 1220: ra_customer_trx ct,

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'
1224: and nvl(trh.current_record_flag,'Y') = 'Y'

Line 1221: ra_customer_trx_lines ctl

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'
1224: and nvl(trh.current_record_flag,'Y') = 'Y'
1225: and ct.customer_trx_id = trh.customer_trx_id