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_CONSINV dependencies on RA_TERMS_LINES

Line 502: ra_terms_lines TL1

498: SELECT T.term_id term_id ,
499: TL1.due_day_of_month day_due,
500: TL1.due_months_forward months_forward
501: FROM ra_terms T,
502: ra_terms_lines TL1
503: WHERE TL1.term_id = T.term_id
504: AND T.term_id = nvl(C_term_id, T.term_id)
505: AND T.due_cutoff_day = C_cutoff_day
506: AND TL1.due_day_of_month IS NOT NULL

Line 509: from ra_terms_lines TL2

505: AND T.due_cutoff_day = C_cutoff_day
506: AND TL1.due_day_of_month IS NOT NULL
507: AND TL1.due_months_forward IS NOT NULL
508: AND 1 = (select count(*)
509: from ra_terms_lines TL2
510: where TL2.term_id = TL1.term_id) ;
511:
512: /* bug2892106 Broke up this stmt into 3 stmt based on parameter.
513: -- bug2501071 : Moved ra_terms/(_lines) to c_types in order to