[Home] [Help]
1073: select adj.amount,
1074: CASE WHEN adj.type ='CHARGES'
1075: THEN adj.amount
1076: ELSE 0 END fin_charge_charged
1077: from ar_adjustments adj
1078: where adj.payment_schedule_id = p_payment_schedule_id
1079: and adj.apply_date <= p_as_of_date
1080: and adj.status = 'A');
1081: IF p_formula <> 'Y' THEN
1953: | i) amount_due_remaining from ar_payment_schedules |
1954: | ii) amount_applied + discount from ar_receivable_applications after the |
1955: | finance charge date. Note that the trx_date of the credit items is considered |
1956: | for determining this as compared to the application date |
1957: | iii) amount_adjusted from ar_adjustments after the finance charge date |
1958: | b) If simple / flat interest has to be computed, the finance charge computed before |
1959: | finance charge date has to be deducted from the above amount. |
1960: | c) From the above computed balance, the debit items are adjusted against the credit |
1961: | amount in the order of the due date. If two debit items have the same due date, the |
2353: ps.org_id,
2354: ps.cash_receipt_id,
2355: 'OVERDUE' charge_type
2356: from ar_payment_schedules ps,
2357: ar_adjustments adj,
2358: ar_lc_cust_sites_t cust_site,
2359: ar_late_charge_cust_balance_gt bal
2360: where ps.customer_id = cust_site.customer_id
2361: and cust_site.customer_site_use_id = decode(ps.class,
2778: | i) amount_due_remaining from ar_payment_schedules |
2779: | ii) amount_applied + discount from ar_receivable_applications after the |
2780: | finance charge date. The data on which the credit item is created is used |
2781: | instead of the application date |
2782: | iii) amount_adjusted from ar_adjustments after the finance charge date |
2783: | b) If simple / flat interest has to be computed, the finance charge computed before |
2784: | finance charge date has to be deducted from the above amount |
2785: | c) In this case, the Credit items are treated similar to Debit Items. Interest is |
2786: | calculated on the credit items as done for debit items. |
3060: ps.org_id,
3061: ps.cash_receipt_id,
3062: 'OVERDUE' charge_type
3063: from ar_payment_schedules ps,
3064: ar_adjustments adj,
3065: ar_lc_cust_sites_t cust_site,
3066: ar_late_charge_cust_balance_gt bal
3067: where ps.customer_id = cust_site.customer_id
3068: and cust_site.customer_site_use_id = decode(ps.class,
3652: | a) The Receipt Date is used for finding out the late applications on a debit item. So, |
3653: | if an application is Reversed, that need not be considered as the application and |
3654: | it's reversal will cancel out each other on that receipt date. |
3655: | b) The finance charge that is already charged on this invoice is fetched from |
3656: | ar_adjustments |
3657: | c) Open Credit Items are not considered as we are tracking only the late applications |
3658: | |
3659: | PARAMETERS |
3660: | |
3932: ra_customer_trx trx,
3933: ar_transaction_history th,
3934: (select ps.payment_schedule_id ,sum(adj.amount) fin_charge_charged
3935: from ar_payment_schedules ps,
3936: ar_adjustments adj,
3937: ar_lc_cust_sites_t cust_site
3938: where ps.customer_id = cust_site.customer_id
3939: and decode(cust_site.customer_site_use_id,'','X', ps.customer_site_use_id)
3940: = decode(cust_site.customer_site_use_id,'','X', cust_site.customer_site_use_id)
5091: sum(-1 *adj.amount) open_bal,
5092: sum(-1*(case when (decode(ps.class,'CM',ps.due_date,ps.due_date + NVL(cust_site.payment_grace_days,0))) < p_as_of_date then 1 else 0 end)
5093: *(adj.amount)) overdue_bal,
5094: ps.org_id
5095: FROM ar_adjustments adj ,
5096: ar_payment_schedules ps,
5097: ar_lc_cust_sites_t cust_site,
5098: ra_customer_trx ct,
5099: ra_cust_trx_types typ
6928: | is populated, we can assume that Interest Invoice was created on this payment |
6929: | schedule. 11i AR Finance Charge functionality uses the field last_accrue_charge_date |
6930: | in hz_cust_site_uses to store the last date on which Finance Charge was computed on |
6931: | the invoices of a given customer site use. Such finance charges will be created as |
6932: | Adjustments and can be derived from ar_adjustments. If any of these two conditions |
6933: | are satisfied, the payment_schedule is treated as if Interest was computed on it. |
6934: | If hold_charged_invoices_flag = 'Y' then |
6935: | ps.last_charge_date should be NULL |
6936: | AND fin_charge_charged should be Zero |