APPS.AR_INVOICE_UTILS dependencies on RA_TERMS

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 );

Line 3694: FROM ra_terms t_su,

3690:
3691: -- Get term_id for NON-BFB enabled customers
3692: UPDATE ar_trx_header_gt gt
3693: SET term_id = (SELECT tl.term_id
3694: FROM ra_terms t_su,
3695: ra_terms t_cp1,
3696: ra_terms t_cp2,
3697: ra_terms tl, /*Bug 3984916*/
3698: hz_customer_profiles cp1,

Line 3695: ra_terms t_cp1,

3691: -- Get term_id for NON-BFB enabled customers
3692: UPDATE ar_trx_header_gt gt
3693: SET term_id = (SELECT tl.term_id
3694: FROM ra_terms t_su,
3695: ra_terms t_cp1,
3696: ra_terms t_cp2,
3697: ra_terms tl, /*Bug 3984916*/
3698: hz_customer_profiles cp1,
3699: hz_customer_profiles cp2,

Line 3696: ra_terms t_cp2,

3692: UPDATE ar_trx_header_gt gt
3693: SET term_id = (SELECT tl.term_id
3694: FROM ra_terms t_su,
3695: ra_terms t_cp1,
3696: ra_terms t_cp2,
3697: ra_terms tl, /*Bug 3984916*/
3698: hz_customer_profiles cp1,
3699: hz_customer_profiles cp2,
3700: hz_cust_site_uses su

Line 3697: ra_terms tl, /*Bug 3984916*/

3693: SET term_id = (SELECT tl.term_id
3694: FROM ra_terms t_su,
3695: ra_terms t_cp1,
3696: ra_terms t_cp2,
3697: ra_terms tl, /*Bug 3984916*/
3698: hz_customer_profiles cp1,
3699: hz_customer_profiles cp2,
3700: hz_cust_site_uses su
3701: WHERE gt.bill_to_customer_id = cp1.cust_account_id(+)