APPS.AR_BUS_EVENT_SUB_PVT dependencies on RA_TERMS_B

Line 805: ra_terms_b rt

801: count(decode(sign(ps.due_date-ra.apply_date),-1,
802: ps.payment_schedule_id, null)) count_of_inv_inst_paid_late
803: from ar_receivable_applications ra,
804: ar_payment_schedules ps,
805: ra_terms_b rt
806: where ra.request_id = p_req_id
807: and ra.status = 'APP'
808: and ps.payment_schedule_id = ra.applied_payment_schedule_id
809: and rt.term_id(+) = ps.term_id

Line 5411: ra_terms_b rt

5407: decode(sign(nvl(ra.unearned_discount_taken,0)),-1,-1,0,0,1) count_of_uedisc
5408: FROM ar_payment_schedules trx_ps,
5409: ar_receivable_applications ra,
5410: ar_payment_schedules rcpt_ps,
5411: ra_terms_b rt
5412: WHERE ra.receivable_application_id = ra_id
5413: and ra.status in ('APP','ACTIVITY')
5414: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id
5415: and ra.applied_payment_schedule_id = trx_ps.payment_schedule_id

Line 5688: ra_terms_b rt

5684: decode(sign(nvl(ra.unearned_discount_taken,0)),-1,-1,0,0,1) count_of_uedisc
5685: FROM ar_payment_schedules trx_ps,
5686: ar_receivable_applications ra,
5687: ar_payment_schedules rcpt_ps,
5688: ra_terms_b rt
5689: WHERE ra.receivable_application_id = ra_id
5690: and ra.status in ('APP','ACTIVITY')
5691: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id
5692: and ra.applied_payment_schedule_id = trx_ps.payment_schedule_id