[Home] [Help]
394: select g.customer_trx_line_id, g.gl_date,
395: sum(g.amount), sum(g.acctd_amount), sum(g.percent),
396: nvl(g.revenue_adjustment_id, -99) revenue_adjustment_id
397: from ra_cust_trx_line_gl_dist g,
398: ar_line_rev_adj_gt gt,
399: ra_customer_trx h,
400: ra_customer_trx prev_h
401: where h.customer_trx_id = g.customer_trx_id
402: and h.previous_customer_trx_id = prev_h.customer_trx_id (+)
3947: | This function corrects rounding errors resulting from revenue
3948: | adjustments created via ar_revenue_adjustment_pvt.dists_by_model
3949: | routine. The logic contained below is almost identical to
3950: | correct_rule_records_by_line (although it has been altered to
3951: | drive from AR_LINE_REV_ADJ_GT table (capable of rounding
3952: | multiple transactions or adjustments at one time).
3953: |
3954: | See description of correct_rule_records_by_line for details about
3955: | the architecture of this function.
4004: * DECODE(g.account_class, 'REV', 1, -1) ROUND_ACCT_AMT,
4005: /* END ACCTD_AMOUNT LOGIC */
4006: gt.revenue_adjustment_id
4007: from ra_customer_trx_lines l,
4008: ar_line_rev_adj_gt gt,
4009: ra_cust_trx_line_gl_dist g,
4010: ra_customer_trx t
4011: where t.customer_trx_id = gt.customer_trx_id
4012: and l.customer_trx_id = t.customer_trx_id
4053: distributions. If there is a problem, we correct it
4054: on that date. */
4055:
4056: /* Passing null to this routine forces it to drive using a join
4057: to ar_line_rev_adj_gt table */
4058: true_lines_by_gl_date(null);
4059:
4060: /* This is phase 2 of rounding.
4061: With this cursor and subsequent UPDATE, we detect situations
4476:
4477: /* This call to the MRC wrapper will eventually call a clone of this
4478: routine that was designed to round MRC gld table data. The MRC
4479: call like the primary sob one utilizes the amounts and line_ids
4480: from ar_line_rev_adj_gt (global temporary table).
4481:
4482: Note that mrc_correct_rounding verifies that MRC is enabled before
4483: doing anything */
4484: ar_mrc_engine2.mrc_correct_rounding(
4494: );
4495: END IF;
4496:
4497: /* 9317102 - purge GT table to prevent re-processing of lines */
4498: DELETE from ar_line_rev_adj_gt;
4499:
4500: IF PG_DEBUG in ('Y', 'C') THEN
4501: arp_standard.debug('arp_rounding.correct_rev_adj_by_line()-');
4502: END IF;