[Home] [Help]
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
237: and trx.request_id = p_req_id
713: nvl(rps.customer_site_use_id, -99) site_use_id,
714: rps.invoice_currency_code rcpt_currency,
715: cr.receipt_date as_of_date,
716: sum(nvl(ra.amount_applied_from,ra.amount_applied)) receipt_amount
717: from ar_receivable_applications ra,
718: ar_payment_schedules rps,
719: ar_cash_receipts cr
720: where ra.request_id = p_req_id
721: and ra.status = 'UNAPP'
751: cr.currency_code currency,
752: cr.org_id,
753: max(cr.receipt_date) last_cash_receipt_date
754: from ar_cash_receipts cr,
755: ar_receivable_applications ra
756: where ra.request_id = p_req_id
757: and ra.status = 'UNAPP'
758: and sign(ra.amount_applied) = 1
759: and cr.cash_receipt_id = ra.cash_receipt_id
800: count(DECODE(ps.class,'INV',
801: ps.payment_schedule_id, null)) count_of_tot_inv_inst_paid,
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'
3890: null)) unresolved_cash
3891: FROM ar_payment_schedules ps,
3892: ar_cash_receipts cr,
3893: ar_cash_receipt_history crh,
3894: ar_receivable_applications ra
3895: WHERE ps.payment_schedule_id = p_ps_id
3896: and ps.cash_receipt_id = cr.cash_receipt_id
3897: and crh.cash_receipt_id = cr.cash_receipt_id
3898: and crh.cash_receipt_history_id = ra.cash_receipt_history_id -- apandit
4992: rcpt_ps.invoice_currency_code,
4993: nvl(ra.amount_applied_from,ra.amount_applied),
4994: ra.apply_date
4995: FROM ar_payment_schedules trx_ps,
4996: ar_receivable_applications ra,
4997: ar_payment_schedules rcpt_ps
4998: WHERE ra.receivable_application_id = p_ra_id
4999: and ra.status in ('APP')
5000: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id
5202: rcpt_ps.invoice_currency_code,
5203: nvl(ra.amount_applied_from,ra.amount_applied),
5204: ra.apply_date
5205: FROM ar_payment_schedules trx_ps,
5206: ar_receivable_applications ra,
5207: ar_payment_schedules rcpt_ps
5208: WHERE ra.receivable_application_id = p_ra_id
5209: and ra.status in ('APP')
5210: and ra.payment_schedule_id = rcpt_ps.payment_schedule_id
5423: ra.unearned_discount_taken,
5424: decode(sign(nvl(ra.earned_discount_taken,0)),-1,-1,0,0,1) count_of_edisc,
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')
5705: ra.unearned_discount_taken,
5706: decode(sign(nvl(ra.earned_discount_taken,0)),-1,-1,0,0,1) count_of_edisc,
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')
5720: Cursor get_inv_disc_info(p_rec_app_id IN NUMBER) IS
5721: select sum( nvl(ra.earned_discount_taken,0)
5722: + nvl(ra.unearned_discount_taken,0)
5723: ) total_disc
5724: from ar_receivable_applications ra
5725: where receivable_application_id = p_rec_app_id
5726: and status = 'APP'
5727: and display = 'Y';
5728:
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
6143: and trx.request_id = p_req_id
7242: (SELECT SUM(DECODE(rap.applied_payment_schedule_id, -2, 0,
7243: crh.amount))
7244: FROM ar_cash_receipts_all cr,
7245: ar_cash_receipt_history_all crh,
7246: ar_receivable_applications_all rap
7247: WHERE nvl(cr.confirmed_flag, 'Y') = 'Y'
7248: AND cr.reversal_date IS NULL
7249: AND cr.cash_receipt_id = crh.cash_receipt_id
7250: AND crh.current_record_flag = 'Y'
7284: (SELECT SUM(DECODE(rap.applied_payment_schedule_id, -2, 0,
7285: crh.amount))
7286: FROM ar_cash_receipts_all cr,
7287: ar_cash_receipt_history_all crh,
7288: ar_receivable_applications_all rap
7289: WHERE nvl(cr.confirmed_flag, 'Y') = 'Y'
7290: AND cr.reversal_date IS NULL
7291: AND cr.cash_receipt_id = crh.cash_receipt_id
7292: AND crh.current_record_flag = 'Y'