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.JAI_CMN_RGM_PROCESSING_PKG dependencies on AP_CHECKS_ALL

Line 300: FROM ap_invoice_payments_all a, ap_checks_all b

296: a.org_id, b.status_lookup_code, b.check_date, b.void_date, b.future_pay_due_date,
297: a.accounting_date, a.reversal_inv_pmt_id, discount_taken,
298: -- Added the following for Bug 8294236
299: b.currency_code, b.exchange_rate, b.exchange_date, b.exchange_rate_type
300: FROM ap_invoice_payments_all a, ap_checks_all b
301: WHERE a.check_id = b.check_id
302: AND a.invoice_payment_id = cp_invoice_payment_id;
303:
304: -- code ported from BL12.1.3 by zhiwei.xin on 23-JAN-2013 begin

Line 2151: FROM ap_invoice_payments_all a, ap_checks_all b

2147:
2148: CURSOR c_previous_payments_of_inv(cp_invoice_id IN NUMBER, cp_start_date IN DATE) IS
2149: SELECT a.invoice_payment_id, a.check_id, a.amount, a.payment_base_amount, a.reversal_flag,
2150: a.reversal_inv_pmt_id, a.org_id
2151: FROM ap_invoice_payments_all a, ap_checks_all b
2152: WHERE a.invoice_id = cp_invoice_id
2153: AND a.check_id = b.check_id
2154: AND a.creation_date < cp_start_date
2155: AND nvl(b.future_pay_due_date, v_today) <= v_today

Line 2197: ap_checks_all apc ,

2193: apinvp.org_id,
2194: ainvd.accounting_date -- Xiao for POT change, reg bug#12533434
2195: FROM
2196: ap_invoice_payments_all apinvp,
2197: ap_checks_all apc ,
2198: ap_invoice_distributions_all ainvd ,
2199: jai_rgm_trx_refs jrtr /* second table is used for join just to take IL records */
2200: WHERE
2201: apinvp.org_id = p_org_id