[Home] [Help]
1051: + nvl(ra.earned_discount_taken,0)
1052: + nvl(ra.unearned_discount_taken,0))
1053: ,0) amount_applied,
1054: 0 fin_charge_charged
1055: from ar_receivable_applications ra,
1056: ar_payment_schedules ps_cm_cr
1057: where applied_payment_schedule_id = p_payment_schedule_id
1058: and ra.status = 'APP'
1059: and nvl(ra.confirmed_flag,'Y') = 'Y'
1061: and ps_cm_cr.trx_date <= p_as_of_date
1062: union all
1063: select nvl(ra.amount_applied_from, ra.amount_applied),
1064: 0 fin_charge_charged
1065: from ar_receivable_applications ra
1066: where payment_schedule_id = p_payment_schedule_id
1067: and ra.apply_date <= p_as_of_date
1068: and ra.status = 'APP'
1069: and nvl(ra.confirmed_flag,'Y') = 'Y'
1950: | PSEUDO CODE/LOGIC |
1951: | |
1952: | a) Get the overdue balances of the debit items as sum of |
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 |
2478: ps.org_id,
2479: ps.cash_receipt_id,
2480: 'OVERDUE' charge_type
2481: from ar_payment_schedules ps,
2482: ar_receivable_applications app,
2483: ar_payment_schedules ps_cm_cr,
2484: ar_lc_cust_sites_t cust_site,
2485: ar_late_charge_cust_balance_gt bal
2486: where ps.customer_id = cust_site.customer_id
2775: | PSEUDO CODE/LOGIC |
2776: | |
2777: | a) Get the overdue balances of the items as sum of |
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 |
3200: ps.org_id,
3201: ps.cash_receipt_id,
3202: 'OVERDUE' charge_type
3203: from ar_payment_schedules ps,
3204: ar_receivable_applications app,
3205: ar_payment_schedules ps_cm_cr,
3206: ar_lc_cust_sites_t cust_site,
3207: ar_late_charge_cust_balance_gt bal
3208: where ps.customer_id = cust_site.customer_id
3335: ps.org_id,
3336: ps.cash_receipt_id,
3337: 'OVERDUE' charge_type
3338: from ar_payment_schedules ps,
3339: ar_receivable_applications app,
3340: ar_lc_cust_sites_t cust_site,
3341: ar_late_charge_cust_balance_gt bal
3342: where ps.customer_id = cust_site.customer_id
3343: and cust_site.customer_site_use_id = ps.customer_site_use_id
3925: cr.cash_receipt_id
3926: from ar_payment_schedules ps,
3927: ar_lc_cust_sites_t cust_site,
3928: ar_late_charge_cust_balance_gt bal,
3929: ar_receivable_applications app,
3930: ar_cash_receipts cr,
3931: ra_cust_trx_types types,
3932: ra_customer_trx trx,
3933: ar_transaction_history th,
4960: * (ra.amount_applied + NVL(ra.earned_discount_taken,0)
4961: + NVL(ra.unearned_discount_taken,0))) overdue_bal,
4962: ps.org_id
4963: FROM ar_payment_schedules ps,
4964: ar_receivable_applications ra,
4965: ar_payment_schedules ps_cm_cr,
4966: ar_lc_cust_sites_t cust_site,
4967: ra_customer_trx ct,
4968: ra_cust_trx_types typ
5006: * (ra.amount_applied + NVL(ra.earned_discount_taken,0)
5007: + NVL(ra.unearned_discount_taken,0))) overdue_bal,
5008: ps.org_id
5009: FROM ar_payment_schedules ps,
5010: ar_receivable_applications ra,
5011: ar_payment_schedules ps_cm_cr,
5012: ar_lc_cust_sites_t cust_site,
5013: ra_customer_trx ct,
5014: ra_cust_trx_types typ
5050: *(ra.amount_applied + NVL(ra.earned_discount_taken,0)
5051: + NVL(ra.unearned_discount_taken,0))) overdue_bal,
5052: ps.org_id
5053: FROM ar_payment_schedules ps,
5054: ar_receivable_applications ra,
5055: ar_lc_cust_sites_t cust_site,
5056: ra_customer_trx ct,
5057: ra_cust_trx_types typ
5058: WHERE ps.customer_id = cust_site.customer_id