APPS.AR_INVOICE_UTILS dependencies on RA_TERMS

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

Line 3790: FROM ra_terms t_su,

3786:
3787: -- Get term_id for NON-BFB enabled customers
3788: UPDATE ar_trx_header_gt gt
3789: SET term_id = (SELECT tl.term_id
3790: FROM ra_terms t_su,
3791: ra_terms t_cp1,
3792: ra_terms t_cp2,
3793: ra_terms tl, /*Bug 3984916*/
3794: hz_customer_profiles cp1,

Line 3791: ra_terms t_cp1,

3787: -- Get term_id for NON-BFB enabled customers
3788: UPDATE ar_trx_header_gt gt
3789: SET term_id = (SELECT tl.term_id
3790: FROM ra_terms t_su,
3791: ra_terms t_cp1,
3792: ra_terms t_cp2,
3793: ra_terms tl, /*Bug 3984916*/
3794: hz_customer_profiles cp1,
3795: hz_customer_profiles cp2,

Line 3792: ra_terms t_cp2,

3788: UPDATE ar_trx_header_gt gt
3789: SET term_id = (SELECT tl.term_id
3790: FROM ra_terms t_su,
3791: ra_terms t_cp1,
3792: ra_terms t_cp2,
3793: ra_terms tl, /*Bug 3984916*/
3794: hz_customer_profiles cp1,
3795: hz_customer_profiles cp2,
3796: hz_cust_site_uses su

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

3789: SET term_id = (SELECT tl.term_id
3790: FROM ra_terms t_su,
3791: ra_terms t_cp1,
3792: ra_terms t_cp2,
3793: ra_terms tl, /*Bug 3984916*/
3794: hz_customer_profiles cp1,
3795: hz_customer_profiles cp2,
3796: hz_cust_site_uses su
3797: WHERE gt.bill_to_customer_id = cp1.cust_account_id(+)