[Home] [Help]
267: SELECT ROUND(SUM((ra.apply_date - ps.trx_date) * ra.amount_applied)
268: / SUM(ra.amount_applied)
269: , 0) WEIGHTED_AVG_DAYS_PAID
270: INTO l_wtd_days_paid
271: FROM ar_receivable_applications ra,
272: ar_payment_schedules ps,
273: hz_cust_accounts ca
274: WHERE ps.customer_id = ca.cust_account_id
275: AND ca.party_id = p_party_id
289: SELECT ROUND(SUM((ra.apply_date - ps.trx_date) * ra.amount_applied)
290: / SUM(ra.amount_applied)
291: , 0) WEIGHTED_AVG_DAYS_PAID
292: INTO l_wtd_days_paid
293: FROM ar_receivable_applications ra,
294: ar_payment_schedules ps
295: WHERE ps.customer_id = p_cust_account_id
296: AND ra.status = 'APP'
297: AND ps.payment_schedule_id = ra.applied_payment_schedule_id
309: SELECT ROUND(SUM((ra.apply_date - ps.trx_date) * ra.amount_applied)
310: / SUM(ra.amount_applied)
311: , 0) WEIGHTED_AVG_DAYS_PAID
312: INTO l_wtd_days_paid
313: FROM ar_receivable_applications ra,
314: ar_payment_schedules ps
315: WHERE ps.customer_site_use_id = p_customer_site_use_id
316: AND ra.status = 'APP'
317: AND ps.payment_schedule_id = ra.applied_payment_schedule_id
1266: SELECT sum( nvl(ra.acctd_amount_applied_to,0) +
1267: nvl(ra.acctd_earned_discount_taken,0) +
1268: nvl(ra.acctd_unearned_discount_taken,0))
1269: INTO l_apps_tot
1270: FROM ar_receivable_applications ra
1271: WHERE ra.applied_payment_schedule_id = p_payment_schedule_id
1272: AND ra.status = 'APP'
1273: AND nvl(ra.confirmed_flag,'Y') = 'Y'
1274: AND ra.gl_date > p_to_date;