APPS.AR_BUS_EVENT_SUB_PVT dependencies on RA_TERMS_B

Line 806: ra_terms_b rt

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

Line 5429: ra_terms_b rt

5425: decode(sign(nvl(ra.unearned_discount_taken,0)),-1,-1,0,0,1) count_of_uedisc
5426: FROM ar_payment_schedules trx_ps,
5427: ar_receivable_applications ra,
5428: ar_payment_schedules rcpt_ps,
5429: ra_terms_b rt
5430: WHERE ra.receivable_application_id = ra_id
5431: and ra.status in ('APP','ACTIVITY')
5432: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id
5433: and ra.applied_payment_schedule_id = trx_ps.payment_schedule_id

Line 5711: ra_terms_b rt

5707: decode(sign(nvl(ra.unearned_discount_taken,0)),-1,-1,0,0,1) count_of_uedisc
5708: FROM ar_payment_schedules trx_ps,
5709: ar_receivable_applications ra,
5710: ar_payment_schedules rcpt_ps,
5711: ra_terms_b rt
5712: WHERE ra.receivable_application_id = ra_id
5713: and ra.status in ('APP','ACTIVITY')
5714: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id
5715: and ra.applied_payment_schedule_id = trx_ps.payment_schedule_id