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_MATCH_REV_COGS_GRP dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 233: ra_cust_trx_line_gl_dist_all gld,

229: INDEX(gld,RA_CUST_TRX_LINE_GL_DIST_N2)
230: USE_HASH(gld) USE_NL(gld2) ROWID(gld2) */
231: distinct l.sales_order, l.org_id
232: FROM ra_customer_trx_lines_all l,
233: ra_cust_trx_line_gl_dist_all gld,
234: ra_cust_trx_line_gl_dist_all gld2,
235: ar_system_parameters_all p
236: WHERE gld.gl_date between p_low_date and p_hi_date
237: AND gld2.account_set_flag = 'N'

Line 234: ra_cust_trx_line_gl_dist_all gld2,

230: USE_HASH(gld) USE_NL(gld2) ROWID(gld2) */
231: distinct l.sales_order, l.org_id
232: FROM ra_customer_trx_lines_all l,
233: ra_cust_trx_line_gl_dist_all gld,
234: ra_cust_trx_line_gl_dist_all gld2,
235: ar_system_parameters_all p
236: WHERE gld.gl_date between p_low_date and p_hi_date
237: AND gld2.account_set_flag = 'N'
238: AND gld.org_id = p.org_id

Line 250: ra_cust_trx_line_gl_dist_all gld

246: /* original cursor (not limited by sob_id) */
247: CURSOR so_number_c(p_low_date DATE, p_hi_date DATE) IS
248: SELECT distinct l.sales_order, l.org_id
249: FROM ra_customer_trx_lines_all l,
250: ra_cust_trx_line_gl_dist_all gld
251: WHERE gld.gl_date between p_low_date and p_hi_date
252: AND gld.account_set_flag = 'N'
253: AND gld.customer_trx_line_id = l.customer_trx_line_id
254: AND l.sales_order_line is NOT NULL

Line 364: ra_cust_trx_line_gl_dist_all tlgld,

360: tl.org_id,
361: tl.set_of_books_id
362: FROM ra_customer_trx_lines_all tl,
363: ra_customer_trx_lines_all tli,
364: ra_cust_trx_line_gl_dist_all tlgld,
365: gl_period_statuses gps
366: WHERE
367: tl.sales_order = so_numbers(i)
368: AND tl.org_id = so_orgs(i)