[Home] [Help]
976: )
977: from ra_customer_trx ctrx,
978: hz_cust_site_uses rsu_st,
979: hz_cust_site_uses rsu_bt,
980: ar_system_parameters sp
981: where ctrx.customer_trx_id = p_customer_trx_id
982: and ctrx.org_id = p_org_id
983: and sp.org_id = p_org_id
984: and ctrx.bill_to_site_use_id = rsu_bt.site_use_id(+)
1009: select rt.receivables_trx_id
1010: into l_penalty_receivables_trx_id
1011: from ar_receivables_trx rt
1012: where rt.receivables_trx_id = (select sp.penalty_rec_trx_id
1013: from ar_system_parameters sp
1014: where sp.org_id = p_org_id)
1015: and rt.type = 'FINCHRG'
1016: and nvl(rt.status,'A') = 'A'
1017: and rt.org_id = p_org_id
1625: hz_parties party,
1626: hz_customer_profiles profiles,
1627: hz_cust_profile_amts prof_amts,
1628: hz_cust_site_uses site_use,
1629: ar_system_parameters sysparam
1630: WHERE cust_acct.party_id = party.party_id
1631: '|| l_customer_name_where ||'
1632: '|| l_customer_number_where || '
1633: AND cust_acct.status = ''A''
4151: | receipt grace days is subtracted from this. If this balance is atleast the min |
4152: | customer balance threshold, charge will be calculated. |
4153: | b) Charge computation |
4154: | Based on the set up in post_billing_debit_items and late_charge_billing_calc_mode,|
4155: | (in ar_system_parameters), different items and date range will be used to |
4156: | calculate the average daily balance |
4157: | c) Generation of the document in AR. |
4158: | 2. The following fields are not used for Average Daily Balance |
4159: | a) credit_items_flag |
4357: cust_sites.min_fc_balance_amount,
4358: cust_sites.min_fc_balance_percent
4359: from ar_cons_inv cons_inv,
4360: ar_lc_cust_sites_t cust_sites,
4361: ar_system_parameters sysparam
4362: where cons_inv.customer_id = cust_sites.customer_id
4363: and cons_inv.site_use_id = cust_sites.customer_site_use_id
4364: and cons_inv.currency_code = cust_sites.currency_code
4365: and mod(nvl(cust_sites.customer_site_use_id,0),l_total_workers) =
4437: cust_site.min_fc_balance_overdue_type,
4438: cust_site.min_fc_balance_amount,
4439: cust_site.min_fc_balance_percent
4440: from ar_lc_cust_sites_t cust_site,
4441: ar_system_parameters sysparam
4442: where sysparam.org_id = cust_site.org_id
4443: and sysparam.late_charge_billing_calc_mode = 'RUN_TO_RUN_DATE'
4444: and cust_site.late_charge_calculation_trx = 'AVG_DAILY_BALANCE'
4445: and mod(nvl(cust_site.customer_site_use_id,0),l_total_workers) =
4489: cust_sites.min_fc_balance_amount,
4490: cust_sites.min_fc_balance_percent
4491: from ar_payment_schedules ps,
4492: ar_lc_cust_sites_t cust_sites,
4493: ar_system_parameters sysparam
4494: where ps.customer_id = cust_sites.customer_id
4495: and decode(ps.class,
4496: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4497: ps.customer_site_use_id,
4737: cust_sites.min_fc_balance_amount,
4738: cust_sites.min_fc_balance_percent
4739: from ar_cons_inv cons_inv,
4740: ar_lc_cust_sites_t cust_sites,
4741: ar_system_parameters sysparam
4742: where cons_inv.customer_id = cust_sites.customer_id
4743: and cons_inv.site_use_id = cust_sites.customer_site_use_id
4744: and cons_inv.currency_code = cust_sites.currency_code
4745: and mod(nvl(cust_sites.customer_site_use_id,0),l_total_workers) =
4801: cust_sites.min_fc_balance_amount,
4802: cust_sites.min_fc_balance_percent
4803: from ar_payment_schedules ps,
4804: ar_lc_cust_sites_t cust_sites,
4805: ar_system_parameters sysparam
4806: where ps.customer_id = cust_sites.customer_id
4807: and decode(ps.class,
4808: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4809: ps.customer_site_use_id,
5659: 'N',
5660: l_srs_request_id,
5661: sysparam.org_id,
5662: 1
5663: from ar_system_parameters sysparam
5664: where nvl(l_operating_unit_id,sysparam.org_id) = sysparam.org_id);
5665:
5666: IF l_debug_flag = 'Y' THEN
5667: debug( 'ar_calc_late_charge.insert_int_batches()-' );
5834: trx.org_id,
5835: trx.display_flag) hdr,
5836: ar_lc_cust_sites_t cust_site,
5837: ar_interest_batches bat,
5838: ar_system_parameters sysparam
5839: where hdr.customer_id = cust_site.customer_id
5840: and hdr.customer_site_use_id = cust_site.customer_site_use_id
5841: and hdr.currency_code = cust_site.currency_code
5842: and mod(nvl(cust_site.customer_site_use_id,0),p_total_workers) =
7163: /* Check if late_charge calculation is enabled in system options */
7164: IF l_org_id IS NOT NULL THEN
7165: select allow_late_charges, set_of_books_id
7166: into l_compute_late_charge, l_set_of_books_id
7167: from ar_system_parameters
7168: where org_id = l_org_id ;
7169: IF l_debug_flag = 'Y' THEN
7170: debug('Running the Program for a single Operating Unit');
7171: debug('Late Charge option in System Options : '||l_compute_late_charge);