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_CORRECT_CC_ERRORS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 2244: ar_receivable_applications ra,

2240: trx.trx_number,
2241: trx_types.type,
2242: cr.receipt_number
2243: FROM ra_customer_trx trx,
2244: ar_receivable_applications ra,
2245: ar_cash_receipts cr,
2246: ra_cust_trx_types trx_types
2247: WHERE trx.customer_trx_id = ra.applied_customer_trx_id
2248: AND ra.cash_receipt_id = cr.cash_receipt_id

Line 2259: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

2255: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2256: l_rec_number ar_cash_receipts.receipt_number%TYPE;
2257: l_error_notes VARCHAR2(240);
2258: l_dummy_number NUMBER;
2259: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2260: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
2261: l_trx_number ra_customer_trx.trx_number%TYPE;
2262: l_object_version_number ar_cash_receipts.rec_version_number%TYPE;
2263: l_cc_error_code ar_cash_receipts.cc_error_code%TYPE;

Line 2423: FROM ar_receivable_applications ra

2419: INTO l_cash_receipt_id,
2420: l_rec_number
2421: FROM ar_cash_receipts cr
2422: WHERE cash_receipt_id in (SELECT ra.cash_receipt_id
2423: FROM ar_receivable_applications ra
2424: WHERE ra.application_ref_id = p_cc_trx_id
2425: AND ra.applied_payment_schedule_id = -6);
2426:
2427: Raise_RefundReverse_Event(p_misc_cash_receipt_id => p_cc_trx_id,