DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on RA_TERMS

Line 3367: ra_terms t ,

3363: SELECT ctl.extended_amount *
3364: nvl(tl.relative_amount,1)/ nvl(t.base_amount,1)
3365: INTO l_trx_line_amount
3366: FROM ra_customer_trx_lines ctl ,
3367: ra_terms t ,
3368: ra_terms_lines tl ,
3369: ar_payment_schedules ps
3370: WHERE ps.payment_schedule_id = p_payment_schedule_id and
3371: ctl.customer_trx_id = p_customer_trx_id and

Line 3368: ra_terms_lines tl ,

3364: nvl(tl.relative_amount,1)/ nvl(t.base_amount,1)
3365: INTO l_trx_line_amount
3366: FROM ra_customer_trx_lines ctl ,
3367: ra_terms t ,
3368: ra_terms_lines tl ,
3369: ar_payment_schedules ps
3370: WHERE ps.payment_schedule_id = p_payment_schedule_id and
3371: ctl.customer_trx_id = p_customer_trx_id and
3372: ctl.line_type = 'LINE' and

Line 3552: , ra_terms t

3548: , hz_cust_site_uses su
3549: , ra_batch_sources bs
3550: , ar_lookups lu
3551: , hz_cust_accounts cust
3552: , ra_terms t
3553: , ar_payment_schedules ps
3554: , ar_cons_inv ci
3555: WHERE
3556: ps.class in ('CB','CM','DEP','DM','INV','BR')

Line 3649: , ra_terms t

3645: , hz_cust_site_uses su
3646: , ra_batch_sources bs
3647: , ar_lookups lu
3648: , hz_cust_accounts cst
3649: , ra_terms t
3650: , ar_payment_schedules ps
3651: , ar_cons_inv ci
3652: WHERE
3653: ps.class in ('CB','CM','DEP','DM','INV','BR')