[Home] [Help]
227: from ra_customer_trx trx,
228: ar_payment_schedules ps,
229: ra_customer_trx prev_trx,
230: ra_cust_trx_types ctt,
231: ra_terms rt,
232: ra_terms_lines rtl,
233: ar_receivable_applications_all ra_cm,
234: ar_payment_schedules_all cm_app_ps,
235: ar_trx_summary trx_sum
228: ar_payment_schedules ps,
229: ra_customer_trx prev_trx,
230: ra_cust_trx_types ctt,
231: ra_terms rt,
232: ra_terms_lines rtl,
233: ar_receivable_applications_all ra_cm,
234: ar_payment_schedules_all cm_app_ps,
235: ar_trx_summary trx_sum
236: where trx.customer_trx_id = ps.customer_trx_id
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
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
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
6105: from ra_customer_trx trx,
6106: ar_payment_schedules ps,
6107: ra_customer_trx prev_trx,
6108: ra_cust_trx_types ctt,
6109: ra_terms rt,
6110: ra_terms_lines rtl,
6111: ar_receivable_applications_all ra_cm,
6112: ar_payment_schedules_all cm_app_ps,
6113: ar_trx_summary trx_sum
6106: ar_payment_schedules ps,
6107: ra_customer_trx prev_trx,
6108: ra_cust_trx_types ctt,
6109: ra_terms rt,
6110: ra_terms_lines rtl,
6111: ar_receivable_applications_all ra_cm,
6112: ar_payment_schedules_all cm_app_ps,
6113: ar_trx_summary trx_sum
6114: where trx.customer_trx_id = ps.customer_trx_id