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_RATE_ADJ dependencies on RA_CUSTOMER_TRX_LINES

Line 323: FROM ra_customer_trx_lines_gt

319: CURSOR c_trx_gt(p_customer_trx_id IN NUMBER)
320: IS
321: SELECT COUNT(CUSTOMER_TRX_LINE_ID),
322: CUSTOMER_TRX_LINE_ID
323: FROM ra_customer_trx_lines_gt
324: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
325: GROUP BY CUSTOMER_TRX_LINE_ID;
326:
327: l_cnt_line DBMS_SQL.NUMBER_TABLE;

Line 344: FROM ra_customer_trx_lines

340: FRT_ED_AMOUNT ,
341: FRT_UNED_ACCTD_AMOUNT ,
342: FRT_UNED_AMOUNT ,
343: customer_trx_line_id
344: FROM ra_customer_trx_lines
345: WHERE customer_trx_id = p_customer_trx_id;
346:
347: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
348: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;

Line 1997: UPDATE ra_customer_trx_lines SET

1993:
1994:
1995: IF l_reset_rem = 'Y' THEN
1996: FORALL i IN l_customer_trx_line_id.FIRST ..l_customer_trx_line_id.LAST
1997: UPDATE ra_customer_trx_lines SET
1998: ACCTD_AMOUNT_DUE_REMAINING = l_ACCTD_AMOUNT_DUE_REMAINING(i),
1999: AMOUNT_DUE_REMAINING = l_AMOUNT_DUE_REMAINING(i),
2000: CHRG_ACCTD_AMOUNT_REMAINING= l_CHRG_ACCTD_AMOUNT_REMAINING(i),
2001: CHRG_AMOUNT_REMAINING = l_CHRG_AMOUNT_REMAINING(i),