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 327: FROM ra_customer_trx_lines_gt

323: CURSOR c_trx_gt(p_customer_trx_id IN NUMBER)
324: IS
325: SELECT COUNT(CUSTOMER_TRX_LINE_ID),
326: CUSTOMER_TRX_LINE_ID
327: FROM ra_customer_trx_lines_gt
328: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
329: GROUP BY CUSTOMER_TRX_LINE_ID;
330:
331: l_cnt_line DBMS_SQL.NUMBER_TABLE;

Line 348: FROM ra_customer_trx_lines

344: FRT_ED_AMOUNT ,
345: FRT_UNED_ACCTD_AMOUNT ,
346: FRT_UNED_AMOUNT ,
347: customer_trx_line_id
348: FROM ra_customer_trx_lines
349: WHERE customer_trx_id = p_customer_trx_id;
350:
351: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;

Line 2073: UPDATE ra_customer_trx_lines SET

2069:
2070:
2071: IF l_reset_rem = 'Y' THEN
2072: FORALL i IN l_customer_trx_line_id.FIRST ..l_customer_trx_line_id.LAST
2073: UPDATE ra_customer_trx_lines SET
2074: ACCTD_AMOUNT_DUE_REMAINING = l_ACCTD_AMOUNT_DUE_REMAINING(i),
2075: AMOUNT_DUE_REMAINING = l_AMOUNT_DUE_REMAINING(i),
2076: CHRG_ACCTD_AMOUNT_REMAINING= l_CHRG_ACCTD_AMOUNT_REMAINING(i),
2077: CHRG_AMOUNT_REMAINING = l_CHRG_AMOUNT_REMAINING(i),