[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
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
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
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
6133: from ra_customer_trx trx,
6134: ar_payment_schedules ps,
6135: ra_customer_trx prev_trx,
6136: ra_cust_trx_types ctt,
6137: ra_terms rt,
6138: ra_terms_lines rtl,
6139: ar_receivable_applications_all ra_cm,
6140: ar_payment_schedules_all cm_app_ps,
6141: ar_trx_summary trx_sum
6134: ar_payment_schedules ps,
6135: ra_customer_trx prev_trx,
6136: ra_cust_trx_types ctt,
6137: ra_terms rt,
6138: ra_terms_lines rtl,
6139: ar_receivable_applications_all ra_cm,
6140: ar_payment_schedules_all cm_app_ps,
6141: ar_trx_summary trx_sum
6142: where trx.customer_trx_id = ps.customer_trx_id