APPS.AR_MATCH_REV_COGS_GRP dependencies on CST_REVENUE_RECOGNITION_LINES

Line 392: step 4 - merge data in cst_revenue_recognition_lines

388: Non sales order REV lines get a specific negative int (see below).
389: Currently fetches only 1000 rows at a time.
390: step 2 - collect unique sales orders for processing
391: step 3 - populate ar_trx_cogs_gt table with summarization of data
392: step 4 - merge data in cst_revenue_recognition_lines
393:
394: The detailed flow looks like this:
395:
396: FOR org in orgs(by sob_id) LOOP

Line 411: Merge into cst_revenue_recognition_lines

407:
408: Insert into ar_trx_cogs_gt
409: END LOOP
410:
411: Merge into cst_revenue_recognition_lines
412: <>
413: END LOOP
414: */
415:

Line 718: arp_debug.debug(' Merging into cst_revenue_recognition_lines');

714: */
715:
716: IF PG_DEBUG in ('Y','C')
717: THEN
718: arp_debug.debug(' Merging into cst_revenue_recognition_lines');
719: END IF;
720:
721: MERGE INTO cst_revenue_recognition_lines crrl
722: USING

Line 721: MERGE INTO cst_revenue_recognition_lines crrl

717: THEN
718: arp_debug.debug(' Merging into cst_revenue_recognition_lines');
719: END IF;
720:
721: MERGE INTO cst_revenue_recognition_lines crrl
722: USING
723: (
724: SELECT
725: rev.so_line_id,