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 2106: ar_receivable_applications ra,

2102: trx.trx_number,
2103: trx_types.type,
2104: cr.receipt_number
2105: FROM ra_customer_trx trx,
2106: ar_receivable_applications ra,
2107: ar_cash_receipts cr,
2108: ra_cust_trx_types trx_types
2109: WHERE trx.customer_trx_id = ra.applied_customer_trx_id
2110: AND ra.cash_receipt_id = cr.cash_receipt_id

Line 2121: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

2117: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2118: l_rec_number ar_cash_receipts.receipt_number%TYPE;
2119: l_error_notes VARCHAR2(240);
2120: l_dummy_number NUMBER;
2121: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2122: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
2123: l_trx_number ra_customer_trx.trx_number%TYPE;
2124: l_object_version_number ar_cash_receipts.rec_version_number%TYPE;
2125: l_cc_error_code ar_cash_receipts.cc_error_code%TYPE;

Line 2288: FROM ar_receivable_applications ra

2284: INTO l_cash_receipt_id,
2285: l_rec_number
2286: FROM ar_cash_receipts cr
2287: WHERE cash_receipt_id in (SELECT ra.cash_receipt_id
2288: FROM ar_receivable_applications ra
2289: WHERE ra.application_ref_id = p_cc_trx_id
2290: AND ra.applied_payment_schedule_id = -6);
2291:
2292: Raise_RefundReverse_Event(p_misc_cash_receipt_id => p_cc_trx_id,