DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 42: FROM ar_receivable_applications_all ar_receivable_applications,

38: round(sum(ar_receivable_applications.apply_date -
39: ar_payment_schedules.trx_date) /
40: count(ar_receivable_applications.apply_date)))
41: INTO l_ave_pay_days
42: FROM ar_receivable_applications_all ar_receivable_applications,
43: ar_payment_schedules_all ar_payment_schedules
44: WHERE ar_receivable_applications.applied_payment_schedule_id =
45: ar_payment_schedules.payment_schedule_id
46: AND ar_payment_schedules.customer_id = X_customer_id