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_TYPES

Line 285: l_trx_type ra_cust_trx_types.type%TYPE;

281: ,x_msg_count OUT NOCOPY NUMBER
282: ,x_msg_data OUT NOCOPY VARCHAR2)
283: IS
284: l_customer_trx_id NUMBER;
285: l_trx_type ra_cust_trx_types.type%TYPE;
286: l_invoice_total NUMBER;
287: l_cm_total NUMBER;
288: l_inv_and_cm_total NUMBER;
289: l_prev_trx_id NUMBER;

Line 319: FROM ra_cust_trx_types tt,

315:
316: CURSOR c_trx_type IS
317: SELECT tt.type,
318: t.previous_customer_trx_id
319: FROM ra_cust_trx_types tt,
320: ra_customer_trx t
321: WHERE tt.cust_trx_type_id = t.cust_trx_type_id
322: AND t.customer_trx_id = g_customer_trx_id;
323:

Line 333: ra_cust_trx_types tt,

329:
330: CURSOR c_cm_total IS
331: SELECT sum(l.extended_amount)
332: FROM ra_customer_trx_lines l,
333: ra_cust_trx_types tt,
334: ra_customer_trx cm
335: WHERE l.customer_trx_id = cm.customer_trx_id
336: AND cm.cust_trx_type_id = tt.cust_trx_type_id
337: AND l.line_type = 'LINE'