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_CUST_TRX_TYPES

Line 1885: ra_cust_trx_types types,

1881: 'CM',
1882: 'Y') balance_due
1883: from ar_payment_schedules ps,
1884: ra_customer_trx trx,
1885: ra_cust_trx_types types,
1886: ar_lc_cust_sites_t cust_site,
1887: ar_late_charge_cust_balance_gt bal
1888: where ps.customer_id = cust_site.customer_id
1889: and ps.customer_site_use_id = cust_site.customer_site_use_id

Line 2647: ra_cust_trx_types types,

2643: and nvl(ps.last_charge_date,l_fin_charge_date-1) < l_fin_charge_date
2644: and nvl(ps.receipt_confirmed_flag, 'Y') = 'Y') a,
2645: ra_customer_trx trx,
2646: ar_transaction_history th,
2647: ra_cust_trx_types types,
2648: ar_cash_receipts cr
2649: where trx.customer_trx_id(+) = a.customer_trx_id
2650: and nvl(trx.finance_charges,decode(a.class,'DEP','N','Y')) = 'Y'
2651: and a.customer_trx_id = th.customer_trx_id(+)

Line 3511: ra_cust_trx_types types,

3507: 'PMT',ps.trx_date,
3508: 'CM',ps.trx_date,ps.due_date) <= l_fin_charge_date
3509: and nvl(ps.receipt_confirmed_flag, 'Y') = 'Y') a,
3510: ra_customer_trx trx,
3511: ra_cust_trx_types types,
3512: ar_transaction_history th,
3513: ar_cash_receipts cr
3514: where trx.customer_trx_id(+) = a.customer_trx_id
3515: and nvl(trx.finance_charges,decode(a.class,'DEP','N','Y')) = 'Y'

Line 3931: ra_cust_trx_types types,

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,
3934: (select ps.payment_schedule_id ,sum(adj.amount) fin_charge_charged
3935: from ar_payment_schedules ps,

Line 4928: ra_cust_trx_types typ

4924: ps.org_id
4925: FROM ar_payment_schedules_all ps,
4926: ar_lc_cust_sites_t cust_site,
4927: ra_customer_trx ct,
4928: ra_cust_trx_types typ
4929: WHERE ps.customer_id = cust_site.customer_id
4930: AND ps.customer_trx_id = ct.customer_trx_id --Bug12884574
4931: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
4932: AND ct.org_id = typ.org_id --Bug12884574

Line 4968: ra_cust_trx_types typ

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
4969: WHERE ps.customer_id = cust_site.customer_id
4970: AND ct.customer_trx_id = ps.customer_trx_id --Bug12884574
4971: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
4972: AND ct.org_id = typ.org_id --Bug12884574

Line 5014: ra_cust_trx_types typ

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
5015: WHERE ps.customer_id = cust_site.customer_id
5016: AND ct.customer_trx_id = ps.customer_trx_id --Bug12884574
5017: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
5018: AND ct.org_id = typ.org_id --Bug12884574

Line 5057: ra_cust_trx_types typ

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
5059: AND ct.customer_trx_id = ps.customer_trx_id --Bug12884574
5060: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
5061: AND ct.org_id = typ.org_id --Bug12884574

Line 5099: ra_cust_trx_types typ

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
5100: WHERE ps.customer_id = cust_site.customer_id
5101: AND ct.customer_trx_id = ps.customer_trx_id --Bug12884574
5102: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
5103: AND ct.org_id = typ.org_id --Bug12884574

Line 5172: ra_cust_trx_types typ

5168: ar_transaction_history ath,
5169: ra_customer_trx_lines lines,
5170: ar_lc_cust_sites_t cust_site,
5171: ra_customer_trx ct,
5172: ra_cust_trx_types typ
5173: WHERE ps.customer_id = cust_site.customer_id
5174: AND ps.customer_trx_id = ct.customer_trx_id --Bug12884574
5175: AND ct.cust_trx_type_id = typ.cust_trx_type_id --Bug12884574
5176: AND ct.org_id = typ.org_id --Bug12884574