eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CALC_LATE_CHARGE dependencies on AR_LATE_CHARGE_CUST_BALANCE_GT

Line 1447: ar_late_charge_cust_balance_gt bal

1443: -1* ps.amount_due_remaining balance_due
1444: from ar_cash_receipts cr,
1445: ar_payment_schedules ps,
1446: ar_lc_cust_sites_t cust_site,
1447: ar_late_charge_cust_balance_gt bal
1448: where ps.actual_date_closed > l_fin_charge_date
1449: and ps.class ='PMT'
1450: and ps.trx_date <= l_fin_charge_date
1451: and nvl(ps.last_charge_date,l_fin_charge_date-1) < l_fin_charge_date

Line 1496: ar_late_charge_cust_balance_gt bal

1492: from ar_payment_schedules ps,
1493: ra_customer_trx trx,
1494: ra_cust_trx_types types,
1495: ar_lc_cust_sites_t cust_site,
1496: ar_late_charge_cust_balance_gt bal
1497: where ps.customer_id = cust_site.customer_id
1498: and ps.customer_site_use_id = cust_site.customer_site_use_id
1499: and ps.invoice_currency_code = cust_site.currency_code
1500: and mod(nvl(cust_site.customer_site_use_id,0),l_total_workers) =

Line 1969: ar_late_charge_cust_balance_gt bal

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,
1972: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
1973: ps.customer_site_use_id,

Line 2092: ar_late_charge_cust_balance_gt bal

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
2094: and cust_site.customer_site_use_id = decode(ps.class,
2095: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2096: ps.customer_site_use_id,

Line 2215: ar_late_charge_cust_balance_gt bal

2211: ps.cash_receipt_id,
2212: 'OVERDUE' charge_type
2213: from ar_payment_schedules ps,
2214: ar_lc_cust_sites_t cust_site,
2215: ar_late_charge_cust_balance_gt bal
2216: where ps.customer_id = cust_site.customer_id
2217: and cust_site.customer_site_use_id = decode(ps.class,
2218: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2219: ps.customer_site_use_id,

Line 2667: ar_late_charge_cust_balance_gt bal

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,
2670: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2671: ps.customer_site_use_id,

Line 2807: ar_late_charge_cust_balance_gt bal

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
2809: and cust_site.customer_site_use_id = decode(ps.class,
2810: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2811: ps.customer_site_use_id,

Line 2940: ar_late_charge_cust_balance_gt bal

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
2943: and ps.invoice_currency_code = cust_site.currency_code
2944: and mod(nvl(cust_site.customer_site_use_id,0),l_total_workers) =

Line 3063: ar_late_charge_cust_balance_gt bal

3059: ps.cash_receipt_id,
3060: 'OVERDUE' charge_type
3061: from ar_payment_schedules ps,
3062: ar_lc_cust_sites_t cust_site,
3063: ar_late_charge_cust_balance_gt bal
3064: where ps.customer_id = cust_site.customer_id
3065: and cust_site.customer_site_use_id = decode(ps.class,
3066: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3067: ps.customer_site_use_id,

Line 3517: ar_late_charge_cust_balance_gt bal,

3513: 'LATE' charge_type,
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,

Line 4485: INSERT INTO ar_late_charge_cust_balance_gt

4481: BEGIN
4482: IF l_debug_flag = 'Y' THEN
4483: debug( 'ar_calc_late_charge.insert_cust_balances()+');
4484: END IF;
4485: INSERT INTO ar_late_charge_cust_balance_gt
4486: (late_charge_cust_sites_id,
4487: customer_id,
4488: customer_site_use_id,
4489: currency_code,

Line 6110: from ar_late_charge_cust_balance_gt

6106: customer_site_use_id,
6107: currency_code,
6108: customer_open_balance,
6109: customer_overdue_balance
6110: from ar_late_charge_cust_balance_gt
6111: order by org_id,
6112: customer_id,
6113: customer_site_use_id,
6114: currency_code;

Line 6692: /* Populate the table ar_late_charge_cust_balance_gt with the customer open balance

6688: p_cust_site_use_id => l_cust_site_use_id,
6689: p_worker_number => l_worker_number,
6690: p_total_workers => l_total_workers);
6691:
6692: /* Populate the table ar_late_charge_cust_balance_gt with the customer open balance
6693: and customer overdue balance for all the selected customer, site ,currency_code
6694: and org combination */
6695:
6696: insert_cust_balances(p_as_of_date => l_fin_charge_date,