DBA Data[Home] [Help]

APPS.AR_CMGT_AGING dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 347: ar_receivable_applications_all ra

343: NVL(ra.earned_discount_taken,0)
344: + NVL(ra.unearned_discount_taken,0) ))) bucket6
345: FROM
346: ar_payment_schedules_all ps,
347: ar_receivable_applications_all ra
348: WHERE ra.applied_payment_schedule_id = ps.payment_schedule_id
349: --kjoshi bug#5169416
350: AND nvl(sign(ps.cons_inv_id),0) = decode(p_source,'CONS_BILL',1,0)
351: AND ps.payment_schedule_id +0 > 0

Line 612: ar_receivable_applications_all ra

608: (ra.amount_applied_from +
609: NVL(ra.earned_discount_taken,0)
610: + NVL(ra.unearned_discount_taken,0) ))) bucket6
611: FROM ar_payment_schedules_all ps,
612: ar_receivable_applications_all ra
613: WHERE
614: ps.payment_schedule_id +0 > 0
615: AND ra.payment_schedule_id = ps.payment_schedule_id
616: --kjoshi bug#5169416