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.AR_RAAPI_UTIL dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 2367: FROM ra_cust_trx_line_gl_dist_all d

2363:
2364: CURSOR c_line_amount (p_trx_id NUMBER, p_line_id NUMBER,
2365: p_adj_type VARCHAR2, p_rev_adj_id NUMBER) IS
2366: SELECT SUM(NVL(d.amount,0)) amount
2367: FROM ra_cust_trx_line_gl_dist_all d
2368: WHERE d.customer_trx_line_id = NVL(p_line_id,
2369: d.customer_trx_line_id)
2370: AND d.customer_trx_id = p_trx_id
2371: AND d.account_class = DECODE(p_adj_type,'EA','UNEARN','REV')

Line 2379: FROM ra_cust_trx_line_gl_dist_all d,

2375:
2376: CURSOR c_cm_line_amount (p_trx_id NUMBER, p_line_id NUMBER,
2377: p_adj_type VARCHAR2, p_rev_adj_id NUMBER) IS
2378: SELECT NVL(SUM(NVL(d.amount,0)),0) amount
2379: FROM ra_cust_trx_line_gl_dist_all d,
2380: ra_customer_trx_lines_all l
2381: WHERE l.previous_customer_trx_line_id =
2382: NVL(p_line_id,
2383: l.previous_customer_trx_line_id)