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

Line 284: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

280: l_gt_line_count NUMBER;
281: l_line_count NUMBER;
282: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
283: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
284: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
285: l_output_msg VARCHAR2(2000);
286: l_no_data_flag VARCHAR2(1) := 'N';
287: l_report xmltype;
288: l_summary xmltype;

Line 306: ,ra_customer_trx_all rct

302: ,jgth.SOURCE
303: ,rct.customer_trx_id
304: FROM
305: ar_gta_trx_headers_all jgth
306: ,ra_customer_trx_all rct
307: WHERE jgth.org_id = l_org_id
308: AND jgth.status IN ('FAILED', 'COMPLETED', 'CANCELLED')
309: AND jgth.bill_to_customer_name LIKE nvl(p_customer_name,'%')
310: AND jgth.ra_gl_date >= l_gl_date_from