APPS.AR_MATCH_REV_COGS_GRP dependencies on AR_TRX_COGS_GT

Line 35: FROM ar_trx_cogs_gt cogs

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
37: AND cogs.period_number <= p_period_number
38: AND cogs.customer_trx_id = l.customer_trx_id
39: AND cogs.customer_trx_line_id = l.customer_trx_line_id);

Line 261: FROM ar_trx_cogs_gt;

257:
258: /* debug - dump content of GT table */
259: CURSOR trx_gt IS
260: SELECT *
261: FROM ar_trx_cogs_gt;
262:
263: BEGIN
264:
265: IF PG_DEBUG in ('Y', 'C') THEN

Line 328: /* Step 2 - populate AR_TRX_COGS_GT with summarized data. Data is

324: CLOSE so_number_c;
325:
326: END IF;
327:
328: /* Step 2 - populate AR_TRX_COGS_GT with summarized data. Data is
329: recorded per invoice line and GL period. The potential revenue
330: (revenue_line_amount) is recorded in each period that a transaction
331: line effects but it must be considered only once in creating
332: the divisor for the final revenue percentage. This is currently

Line 336: INSERT INTO ar_trx_cogs_gt

332: the divisor for the final revenue percentage. This is currently
333: handled via a function call */
334:
335: FORALL i in 1 .. so_numbers.count
336: INSERT INTO ar_trx_cogs_gt
337: ( customer_trx_id,
338: customer_trx_line_id,
339: previous_customer_trx_line_id,
340: so_line_id,

Line 401: arp_util.debug('start - dump of ar_trx_cogs_gt');

397:
398: /* debug logic +/
399: IF PG_DEBUG in ('Y', 'C')
400: THEN
401: arp_util.debug('start - dump of ar_trx_cogs_gt');
402: FOR gt IN trx_gt LOOP
403: arp_util.debug(gt.customer_trx_id || '~' ||
404: gt.customer_trx_line_id || '~' ||
405: gt.previous_customer_trx_line_id || '~' ||

Line 408: arp_util.debug('end - dump of ar_trx_cogs_gt');

404: gt.customer_trx_line_id || '~' ||
405: gt.previous_customer_trx_line_id || '~' ||
406: gt.so_line_id);
407: END LOOP;
408: arp_util.debug('end - dump of ar_trx_cogs_gt');
409: END IF;
410: /+ end - debug logic */
411:
412: /* Step 3 - Now merge the resulting data into cst_reve_rec_lines.

Line 454: FROM ar_trx_cogs_gt rev,

450: gps.effective_period_num),4)))
451: rev_percent,
452: max(rev.org_id) org_id,
453: gps.set_of_books_id set_of_books_id
454: FROM ar_trx_cogs_gt rev,
455: gl_period_statuses gps
456: WHERE gps.application_id = 222
457: AND gps.set_of_books_id = rev.set_of_books_id
458: AND gps.start_date <= p_to_gl_date