APPS.AR_MATCH_REV_COGS_GRP dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 259: ra_cust_trx_line_gl_dist_all gld,

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
263: AND gld.org_id = p_org_id

Line 290: ra_cust_trx_line_gl_dist_all gld,

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
294: AND gld.org_id = p_org_id

Line 324: FROM ra_cust_trx_line_gl_dist_all

320: -99, 'corrupt or missing line',
321: -98, 'null sales_order',
322: -97, 'null sales_order_line',
323: -96, 'null int_attr6 col') meaning
324: FROM ra_cust_trx_line_gl_dist_all
325: WHERE org_id = p_org_id
326: AND cogs_request_id BETWEEN -98 AND -1
327: AND gl_date BETWEEN p_from_date AND p_to_date
328: AND account_class = 'REV'

Line 494: UPDATE ra_cust_trx_line_gl_dist_all gld

490: mo_global.set_policy_context('S',c_org.org_id);
491:
492: /* Now update the gld rows with cogs_request_ids */
493: FORALL i in 1 .. gld_rowids.count
494: UPDATE ra_cust_trx_line_gl_dist_all gld
495: SET cogs_request_id = gld_cogs_request_ids(i)
496: WHERE rowid = gld_rowids(i);
497:
498: IF PG_DEBUG in ('Y', 'C')

Line 591: ra_cust_trx_line_gl_dist_all tlgld,

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)
595: AND tl.org_id = so_orgs(i)