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.JMF_GTA_CONC_PROG dependencies on RA_CUSTOMER_TRX_ALL

Line 265: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

261: l_gt_line_count NUMBER;
262: l_line_count NUMBER;
263: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;
264: l_source jmf_gta_trx_headers_all.SOURCE%TYPE;
265: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
266: l_output_msg VARCHAR2(2000);
267: l_no_data_flag VARCHAR2(1) := 'N';
268: l_report xmltype;
269: l_summary xmltype;

Line 287: ,ra_customer_trx_all rct

283: ,jgth.SOURCE
284: ,rct.customer_trx_id
285: FROM
286: jmf_gta_trx_headers_all jgth
287: ,ra_customer_trx_all rct
288: WHERE jgth.org_id = l_org_id
289: AND jgth.status IN ('FAILED', 'COMPLETED', 'CANCELLED')
290: AND jgth.bill_to_customer_name LIKE nvl(p_customer_name,'%')
291: AND jgth.ra_gl_date >= l_gl_date_from