DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on RA_TERMS

Line 3549: ra_terms t ,

3545: SELECT ctl.extended_amount *
3546: nvl(tl.relative_amount,1)/ nvl(t.base_amount,1)
3547: INTO l_trx_line_amount
3548: FROM ra_customer_trx_lines ctl ,
3549: ra_terms t ,
3550: ra_terms_lines tl ,
3551: ar_payment_schedules ps
3552: WHERE ps.payment_schedule_id = p_payment_schedule_id and
3553: ctl.customer_trx_id = p_customer_trx_id and

Line 3550: ra_terms_lines tl ,

3546: nvl(tl.relative_amount,1)/ nvl(t.base_amount,1)
3547: INTO l_trx_line_amount
3548: FROM ra_customer_trx_lines ctl ,
3549: ra_terms t ,
3550: ra_terms_lines tl ,
3551: ar_payment_schedules ps
3552: WHERE ps.payment_schedule_id = p_payment_schedule_id and
3553: ctl.customer_trx_id = p_customer_trx_id and
3554: ctl.line_type = 'LINE' and

Line 3737: , ra_terms t

3733: , hz_cust_site_uses su
3734: , ra_batch_sources bs
3735: , ar_lookups lu
3736: , hz_cust_accounts cust
3737: , ra_terms t
3738: , ar_payment_schedules ps
3739: , ar_cons_inv ci
3740: WHERE
3741: ps.class in ('CB','CM','DEP','DM','INV','BR')

Line 3834: , ra_terms t

3830: , hz_cust_site_uses su
3831: , ra_batch_sources bs
3832: , ar_lookups lu
3833: , hz_cust_accounts cst
3834: , ra_terms t
3835: , ar_payment_schedules ps
3836: , ar_cons_inv ci
3837: WHERE
3838: ps.class in ('CB','CM','DEP','DM','INV','BR')