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.ARP_BALANCE_CHECK dependencies on AR_CASH_RECEIPTS

Line 433: from ar_cash_receipts cr, ar_misc_cash_distributions mcd

429: mcd.misc_cash_distribution_id src_id,
430: 'MCD' src_tab,
431: 'N' cc_flag,
432: mcd.gl_date
433: from ar_cash_receipts cr, ar_misc_cash_distributions mcd
434: where cr.cash_receipt_id between p_cr_id_low and p_cr_id_high
435: and cr.cash_receipt_id = mcd.cash_receipt_id
436: and mcd.posting_control_id = -3
437: UNION ALL

Line 443: from ar_cash_receipts cr, ar_cash_receipt_history crh

439: crh.cash_receipt_history_id src_id,
440: 'CRH' src_tab,
441: 'N' cc_flag,
442: crh.gl_date
443: from ar_cash_receipts cr, ar_cash_receipt_history crh
444: where cr.cash_receipt_id between p_cr_id_low and p_cr_id_high
445: and cr.cash_receipt_id = crh.cash_receipt_id
446: and crh.posting_control_id = -3
447: and nvl(crh.postable_flag,'Y') = 'Y'

Line 456: from ar_cash_receipts cr, ar_receivable_applications ra

452: decode(ra.amount_applied_from,NULL,
453: 'N',
454: 'Y') cc_flag,
455: ra.gl_date
456: from ar_cash_receipts cr, ar_receivable_applications ra
457: where cr.cash_receipt_id between p_cr_id_low and p_cr_id_high
458: and cr.cash_receipt_id = ra.cash_receipt_id
459: and nvl(ra.confirmed_flag,'Y') = 'Y'
460: and nvl(ra.postable,'Y') = 'Y'