DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on RA_TERMS_LINES

Line 2096: from ra_terms_lines tl, ra_terms t

2092: AND ctt.cust_trx_type_id = gt.cust_trx_type_id -- ER 5869149
2093: AND ctt.type <> 'CM' -- ER 5869149
2094: AND NOT EXISTS (
2095: SELECT 'X'
2096: from ra_terms_lines tl, ra_terms t
2097: where nvl(gt.trx_date, trunc(sysdate))
2098: between t.start_date_active and nvl(t.end_date_active, nvl( gt.trx_date, trunc(sysdate) ) )
2099: and t.term_id = tl.term_id
2100: and t.term_id = gt.term_id );