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 RA_CUSTOMER_TRX

Line 583: from ra_customer_trx ctrx,

579: '',sp.finchrg_receivables_trx_id,
580: rsu_bt.finchrg_receivables_trx_id),
581: rsu_st.finchrg_receivables_trx_id
582: )
583: from ra_customer_trx ctrx,
584: hz_cust_site_uses rsu_st,
585: hz_cust_site_uses rsu_bt,
586: ar_system_parameters sp
587: where ctrx.customer_trx_id = p_customer_trx_id

Line 1232: ra_customer_trx trx,

1228: site_use.last_accrue_charge_date,
1229: ps.org_id
1230: from ar_payment_schedules ps,
1231: ar_transaction_history th,
1232: ra_customer_trx trx,
1233: hz_cust_accounts cust_acct,
1234: hz_parties party,
1235: hz_customer_profiles profiles,
1236: hz_cust_profile_amts prof_amts,

Line 1493: ra_customer_trx trx,

1489: l_fin_charge_date,
1490: 'CM',
1491: 'Y') balance_due
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

Line 2246: ra_customer_trx trx,

2242: and nvl(cust_site.charge_begin_date,ps.due_date) <= ps.due_date
2243: and ps.due_date < (l_fin_charge_date - nvl(cust_site.payment_grace_days,0))
2244: and nvl(ps.last_charge_date,l_fin_charge_date-1) < l_fin_charge_date
2245: and nvl(ps.receipt_confirmed_flag, 'Y') = 'Y') a,
2246: ra_customer_trx trx,
2247: ar_transaction_history th,
2248: ra_cust_trx_types types,
2249: ar_cash_receipts cr
2250: where trx.customer_trx_id(+) = a.customer_trx_id

Line 3107: ra_customer_trx trx,

3103: and decode(ps.class,
3104: 'PMT',ps.trx_date,
3105: 'CM',ps.trx_date,ps.due_date) <= l_fin_charge_date
3106: and nvl(ps.receipt_confirmed_flag, 'Y') = 'Y') a,
3107: ra_customer_trx trx,
3108: ra_cust_trx_types types,
3109: ar_transaction_history th,
3110: ar_cash_receipts cr
3111: where trx.customer_trx_id(+) = a.customer_trx_id

Line 3521: ra_customer_trx trx,

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,
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,

Line 4683: ra_customer_trx_lines lines,

4679: ps.org_id
4680: FROM ar_payment_schedules ps,
4681: ar_distributions ard,
4682: ar_transaction_history ath,
4683: ra_customer_trx_lines lines,
4684: ar_lc_cust_sites_t cust_site
4685: WHERE ps.customer_id = cust_site.customer_id
4686: AND cust_site.customer_site_use_id = decode(ps.class,
4687: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,