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.ARPT_SQL_FUNC_UTIL dependencies on RA_TERMS_LINES

Line 1230: FROM ra_terms_lines tl,

1226: ),
1227: p_trx_date + tl.due_days
1228: )
1229: INTO l_term_due_date
1230: FROM ra_terms_lines tl,
1231: ra_terms t
1232: WHERE tl.term_id = p_term_id
1233: AND t.term_id = tl.term_id
1234: AND tl.sequence_num = (

Line 1236: FROM ra_terms_lines

1232: WHERE tl.term_id = p_term_id
1233: AND t.term_id = tl.term_id
1234: AND tl.sequence_num = (
1235: SELECT MIN(sequence_num)
1236: FROM ra_terms_lines
1237: WHERE term_id = p_term_id
1238: );
1239: END IF;
1240:

Line 1348: FROM ra_terms_lines

1344: THEN
1345:
1346: SELECT COUNT(*)
1347: INTO l_count
1348: FROM ra_terms_lines
1349: WHERE term_id = p_term_id;
1350:
1351: END IF;
1352: