DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on RA_TERMS_LINES

Line 2006: from ra_terms_lines tl, ra_terms t

2002: AND ctt.cust_trx_type_id = gt.cust_trx_type_id -- ER 5869149
2003: AND ctt.type <> 'CM' -- ER 5869149
2004: AND NOT EXISTS (
2005: SELECT 'X'
2006: from ra_terms_lines tl, ra_terms t
2007: where nvl(gt.trx_date, trunc(sysdate))
2008: between t.start_date_active and nvl(t.end_date_active, nvl( gt.trx_date, trunc(sysdate) ) )
2009: and t.term_id = tl.term_id
2010: and t.term_id = gt.term_id );