APPS.AR_MATCH_REV_COGS_GRP dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 32: FROM ra_customer_trx_lines_all l

28: p_period_number <> g_period_number
29: THEN
30: SELECT sum(l.revenue_amount)
31: INTO g_potential_revenue
32: FROM ra_customer_trx_lines_all l
33: WHERE EXISTS
34: (SELECT 'eligible transaction captured in GT table'
35: FROM ar_trx_cogs_gt cogs
36: WHERE cogs.so_line_id = p_so_line_id

Line 232: FROM ra_customer_trx_lines_all l,

228: SELECT /*+ LEADING(p,gld,gld2)
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

Line 249: FROM ra_customer_trx_lines_all l,

245:
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

Line 362: FROM ra_customer_trx_lines_all tl,

358: tl.revenue_amount, -- revenue_line_amount (not currently used)
359: MAX(tlgld.gl_date),-- latest_gl_date
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

Line 363: ra_customer_trx_lines_all tli,

359: MAX(tlgld.gl_date),-- latest_gl_date
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)