DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on RA_TERMS

Line 1981: /* 9928090/12662193 - made ra_terms an outer join so credit memos

1977:
1978: l_applied_payment_schedule_id := p_applied_payment_schedule_id;
1979: l_apply_date := p_apply_date;
1980:
1981: /* 9928090/12662193 - made ra_terms an outer join so credit memos
1982: would work properly and not get zeroed out */
1983: select ps.customer_id,
1984: ps.customer_site_use_id,
1985: ps.term_id,

Line 2016: ra_terms rt

2012: l_amount_line_items_original,
2013: l_partial_discount_flag
2014: from ar_payment_schedules ps,
2015: ra_cust_trx_types ctt,
2016: ra_terms rt
2017: where ps.payment_schedule_id = l_applied_payment_schedule_id
2018: AND ps.cust_trx_type_id = ctt.cust_trx_type_id
2019: AND ps.term_id = rt.term_id (+);
2020: