[Home] [Help]
657: + nvl(ra.earned_discount_taken,0)
658: + nvl(ra.unearned_discount_taken,0))
659: ,0) amount_applied,
660: 0 fin_charge_charged
661: from ar_receivable_applications ra,
662: ar_payment_schedules ps_cm_cr
663: where applied_payment_schedule_id = p_payment_schedule_id
664: and ra.status = 'APP'
665: and nvl(ra.confirmed_flag,'Y') = 'Y'
667: and ps_cm_cr.trx_date <= p_as_of_date
668: union all
669: select nvl(ra.amount_applied_from, ra.amount_applied),
670: 0 fin_charge_charged
671: from ar_receivable_applications ra
672: where payment_schedule_id = p_payment_schedule_id
673: and ra.apply_date <= p_as_of_date
674: and ra.status = 'APP'
675: and nvl(ra.confirmed_flag,'Y') = 'Y'
1558: | PSEUDO CODE/LOGIC |
1559: | |
1560: | a) Get the overdue balances of the debit items as sum of |
1561: | i) amount_due_remaining from ar_payment_schedules |
1562: | ii) amount_applied + discount from ar_receivable_applications after the |
1563: | finance charge date. Note that the trx_date of the credit items is considered |
1564: | for determining this as compared to the application date |
1565: | iii) amount_adjusted from ar_adjustments after the finance charge date |
1566: | b) If simple / flat interest has to be computed, the finance charge computed before |
2085: ps.org_id,
2086: ps.cash_receipt_id,
2087: 'OVERDUE' charge_type
2088: from ar_payment_schedules ps,
2089: ar_receivable_applications app,
2090: ar_payment_schedules ps_cm_cr,
2091: ar_lc_cust_sites_t cust_site,
2092: ar_late_charge_cust_balance_gt bal
2093: where ps.customer_id = cust_site.customer_id
2375: | PSEUDO CODE/LOGIC |
2376: | |
2377: | a) Get the overdue balances of the items as sum of |
2378: | i) amount_due_remaining from ar_payment_schedules |
2379: | ii) amount_applied + discount from ar_receivable_applications after the |
2380: | finance charge date. The data on which the credit item is created is used |
2381: | instead of the application date |
2382: | iii) amount_adjusted from ar_adjustments after the finance charge date |
2383: | b) If simple / flat interest has to be computed, the finance charge computed before |
2800: ps.org_id,
2801: ps.cash_receipt_id,
2802: 'OVERDUE' charge_type
2803: from ar_payment_schedules ps,
2804: ar_receivable_applications app,
2805: ar_payment_schedules ps_cm_cr,
2806: ar_lc_cust_sites_t cust_site,
2807: ar_late_charge_cust_balance_gt bal
2808: where ps.customer_id = cust_site.customer_id
2934: ps.org_id,
2935: ps.cash_receipt_id,
2936: 'OVERDUE' charge_type
2937: from ar_payment_schedules ps,
2938: ar_receivable_applications app,
2939: ar_lc_cust_sites_t cust_site,
2940: ar_late_charge_cust_balance_gt bal
2941: where ps.customer_id = cust_site.customer_id
2942: and cust_site.customer_site_use_id = ps.customer_site_use_id
3514: cust_site.late_charge_calculation_trx eff_charge_type
3515: from ar_payment_schedules ps,
3516: ar_lc_cust_sites_t cust_site,
3517: ar_late_charge_cust_balance_gt bal,
3518: ar_receivable_applications app,
3519: ar_cash_receipts cr,
3520: ra_cust_trx_types types,
3521: ra_customer_trx trx,
3522: ar_transaction_history th,
4538: * (ra.amount_applied + NVL(ra.earned_discount_taken,0)
4539: + NVL(ra.unearned_discount_taken,0))) overdue_bal,
4540: ps.org_id
4541: FROM ar_payment_schedules ps,
4542: ar_receivable_applications ra,
4543: ar_payment_schedules ps_cm_cr,
4544: ar_lc_cust_sites_t cust_site
4545: WHERE ps.customer_id = cust_site.customer_id
4546: AND cust_site.customer_site_use_id = decode(ps.class,
4576: *(ra.amount_applied + NVL(ra.earned_discount_taken,0)
4577: + NVL(ra.unearned_discount_taken,0))) overdue_bal,
4578: ps.org_id
4579: FROM ar_payment_schedules ps,
4580: ar_receivable_applications ra,
4581: ar_lc_cust_sites_t cust_site
4582: WHERE ps.customer_id = cust_site.customer_id
4583: AND cust_site.customer_site_use_id = decode(ps.class,
4584: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,