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_ARXCCS_XMLP_PKG dependencies on AR_RECEIVABLES_TRX

Line 573: ar_receivables_trx,

569: into l_ytd_finance_charge_amount,
570: l_ytd_convert_finance_charge,
571: l_ytd_finance_charge_count
572: from ar_adjustments,
573: ar_receivables_trx,
574: ar_payment_schedules
575: where ar_adjustments.payment_schedule_id=
576: ar_payment_schedules.payment_schedule_id
577: and ar_payment_schedules.customer_site_use_id = site_use_id

Line 579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id

575: where ar_adjustments.payment_schedule_id=
576: ar_payment_schedules.payment_schedule_id
577: and ar_payment_schedules.customer_site_use_id = site_use_id
578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id
580: and ar_receivables_trx.type='FINCHRG'
581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate
582: and nvl(ar_adjustments.postable,'Y')='Y'
583: --and ar_payment_schedules.customer_id=customer_id

Line 580: and ar_receivables_trx.type='FINCHRG'

576: ar_payment_schedules.payment_schedule_id
577: and ar_payment_schedules.customer_site_use_id = site_use_id
578: and ar_payment_schedules.invoice_currency_code = Currency_Bucket
579: and ar_adjustments.receivables_trx_id=ar_receivables_trx.receivables_trx_id
580: and ar_receivables_trx.type='FINCHRG'
581: and ar_adjustments.apply_date between add_months(sysdate,-12) and sysdate
582: and nvl(ar_adjustments.postable,'Y')='Y'
583: --and ar_payment_schedules.customer_id=customer_id
584: and ar_payment_schedules.customer_id=customer_id_1