[Home] [Help]
378: SELECT ROUND(SUM((ra.apply_date - ps.trx_date) * ra.amount_applied)
379: / SUM(ra.amount_applied)
380: , 0) WEIGHTED_AVG_DAYS_PAID
381: INTO l_wtd_days_paid
382: FROM ar_receivable_applications ra,
383: ar_payment_schedules ps,
384: hz_cust_accounts ca
385: WHERE ps.customer_id = ca.cust_account_id
386: AND ca.party_id = p_party_id
400: SELECT ROUND(SUM((ra.apply_date - ps.trx_date) * ra.amount_applied)
401: / SUM(ra.amount_applied)
402: , 0) WEIGHTED_AVG_DAYS_PAID
403: INTO l_wtd_days_paid
404: FROM ar_receivable_applications ra,
405: ar_payment_schedules ps
406: WHERE ps.customer_id = p_cust_account_id
407: AND ra.status = 'APP'
408: AND ps.payment_schedule_id = ra.applied_payment_schedule_id
420: SELECT ROUND(SUM((ra.apply_date - ps.trx_date) * ra.amount_applied)
421: / SUM(ra.amount_applied)
422: , 0) WEIGHTED_AVG_DAYS_PAID
423: INTO l_wtd_days_paid
424: FROM ar_receivable_applications ra,
425: ar_payment_schedules ps
426: WHERE ps.customer_site_use_id = p_customer_site_use_id
427: AND ra.status = 'APP'
428: AND ps.payment_schedule_id = ra.applied_payment_schedule_id
1377: SELECT sum( nvl(ra.acctd_amount_applied_to,0) +
1378: nvl(ra.acctd_earned_discount_taken,0) +
1379: nvl(ra.acctd_unearned_discount_taken,0))
1380: INTO l_apps_tot
1381: FROM ar_receivable_applications ra
1382: WHERE ra.applied_payment_schedule_id = p_payment_schedule_id
1383: AND ra.status = 'APP'
1384: AND nvl(ra.confirmed_flag,'Y') = 'Y'
1385: AND ra.gl_date <= p_to_date;--Added for Bug 8201317 14-Jun-2010 barathsr