[Home] [Help]
681: THEN CASE WHEN adj.adjustment_type = 'A'
682: THEN adj.amount
683: ELSE 0 END
684: ELSE 0 END fin_charge_charged
685: from ar_adjustments adj
686: where adj.payment_schedule_id = p_payment_schedule_id
687: and adj.apply_date <= p_as_of_date
688: and adj.status = 'A');
689: IF p_formula <> 'Y' THEN
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 |
1567: | finance charge date has to be deducted from the above amount. |
1568: | c) From the above computed balance, the debit items are adjusted against the credit |
1569: | amount in the order of the due date. If two debit items have the same due date, the |
1963: ps.org_id,
1964: ps.cash_receipt_id,
1965: 'OVERDUE' charge_type
1966: from ar_payment_schedules ps,
1967: ar_adjustments adj,
1968: ar_lc_cust_sites_t cust_site,
1969: ar_late_charge_cust_balance_gt bal
1970: where ps.customer_id = cust_site.customer_id
1971: and cust_site.customer_site_use_id = decode(ps.class,
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 |
2384: | finance charge date has to be deducted from the above amount |
2385: | c) In this case, the Credit items are treated similar to Debit Items. Interest is |
2386: | calculated on the credit items as done for debit items. |
2661: ps.org_id,
2662: ps.cash_receipt_id,
2663: 'OVERDUE' charge_type
2664: from ar_payment_schedules ps,
2665: ar_adjustments adj,
2666: ar_lc_cust_sites_t cust_site,
2667: ar_late_charge_cust_balance_gt bal
2668: where ps.customer_id = cust_site.customer_id
2669: and cust_site.customer_site_use_id = decode(ps.class,
3247: | a) The Receipt Date is used for finding out the late applications on a debit item. So, |
3248: | if an application is Reversed, that need not be considered as the application and |
3249: | it's reversal will cancel out each other on that receipt date. |
3250: | b) The finance charge that is already charged on this invoice is fetched from |
3251: | ar_adjustments |
3252: | c) Open Credit Items are not considered as we are tracking only the late applications |
3253: | |
3254: | PARAMETERS |
3255: | |
3521: ra_customer_trx trx,
3522: ar_transaction_history th,
3523: (select ps.payment_schedule_id ,sum(adj.amount) fin_charge_charged
3524: from ar_payment_schedules ps,
3525: ar_adjustments adj,
3526: ar_lc_cust_sites_t cust_site
3527: where ps.customer_id = cust_site.customer_id
3528: and decode(cust_site.customer_site_use_id,'','X', ps.customer_site_use_id)
3529: = decode(cust_site.customer_site_use_id,'','X', cust_site.customer_site_use_id)
4611: sum(-1 *adj.amount) open_bal,
4612: sum(-1*(case when ps.due_date < p_as_of_date then 1 else 0 end)
4613: *(adj.amount)) overdue_bal,
4614: ps.org_id
4615: FROM ar_adjustments adj ,
4616: ar_payment_schedules ps,
4617: ar_lc_cust_sites_t cust_site
4618: WHERE ps.customer_id = cust_site.customer_id
4619: AND cust_site.customer_site_use_id = decode(ps.class,
6422: | is populated, we can assume that Interest Invoice was created on this payment |
6423: | schedule. 11i AR Finance Charge functionality uses the field last_accrue_charge_date |
6424: | in hz_cust_site_uses to store the last date on which Finance Charge was computed on |
6425: | the invoices of a given customer site use. Such finance charges will be created as |
6426: | Adjustments and can be derived from ar_adjustments. If any of these two conditions |
6427: | are satisfied, the payment_schedule is treated as if Interest was computed on it. |
6428: | If hold_charged_invoices_flag = 'Y' then |
6429: | ps.last_charge_date should be NULL |
6430: | AND fin_charge_charged should be Zero |