APPS.AR_MATCH_REV_COGS_GRP dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 34: FROM ra_customer_trx_lines_all l

30: p_period_number <> g_period_number
31: THEN
32: SELECT sum(l.revenue_amount)
33: INTO g_potential_revenue
34: FROM ra_customer_trx_lines_all l
35: WHERE EXISTS
36: (SELECT /*+ INDEX (cogs AR_TRX_COGS_N1) */
37: 'eligible transaction captured in GT table'
38: FROM ar_trx_cogs_gt cogs

Line 258: FROM ra_customer_trx_lines_all l,

254: l.org_id,
255: row_number() over
256: (partition by l.sales_order,l.org_id
257: order by l.sales_order, l.org_id) rn
258: FROM ra_customer_trx_lines_all l,
259: ra_cust_trx_line_gl_dist_all gld,
260: gl_date_period_map gl_map,
261: gl_sets_of_books gl_sob
262: WHERE gld.cogs_request_id = p_request_id

Line 289: FROM ra_customer_trx_lines_all l,

285: Decode(l.sales_order, NULL, -98,
286: Decode(l.sales_order_line, NULL, -97,
287: Decode(l.interface_line_attribute6, NULL, -96,
288: p_request_id))),-100)) cogs_request_id
289: FROM ra_customer_trx_lines_all l,
290: ra_cust_trx_line_gl_dist_all gld,
291: gl_date_period_map gl_map,
292: gl_sets_of_books gl_sob
293: WHERE gld.cogs_request_id IS NULL

Line 589: FROM ra_customer_trx_lines_all tl,

585: sum(tlgld.percent),-- revenue_line_amount (storing rev percent)
586: MAX(tlgld.gl_date),-- latest_gl_date
587: tl.org_id,
588: tl.set_of_books_id
589: FROM ra_customer_trx_lines_all tl,
590: ra_customer_trx_lines_all tli,
591: ra_cust_trx_line_gl_dist_all tlgld,
592: gl_period_statuses gps
593: WHERE

Line 590: ra_customer_trx_lines_all tli,

586: MAX(tlgld.gl_date),-- latest_gl_date
587: tl.org_id,
588: tl.set_of_books_id
589: FROM ra_customer_trx_lines_all tl,
590: ra_customer_trx_lines_all tli,
591: ra_cust_trx_line_gl_dist_all tlgld,
592: gl_period_statuses gps
593: WHERE
594: tl.sales_order = so_numbers(i)