[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 (+)
3938: | This function corrects rounding errors resulting from revenue
3939: | adjustments created via ar_revenue_adjustment_pvt.dists_by_model
3940: | routine. The logic contained below is almost identical to
3941: | correct_rule_records_by_line (although it has been altered to
3942: | drive from AR_LINE_REV_ADJ_GT table (capable of rounding
3943: | multiple transactions or adjustments at one time).
3944: |
3945: | See description of correct_rule_records_by_line for details about
3946: | the architecture of this function.
3995: * DECODE(g.account_class, 'REV', 1, -1) ROUND_ACCT_AMT,
3996: /* END ACCTD_AMOUNT LOGIC */
3997: gt.revenue_adjustment_id
3998: from ra_customer_trx_lines l,
3999: ar_line_rev_adj_gt gt,
4000: ra_cust_trx_line_gl_dist g,
4001: ra_customer_trx t
4002: where t.customer_trx_id = gt.customer_trx_id
4003: and l.customer_trx_id = t.customer_trx_id
4044: distributions. If there is a problem, we correct it
4045: on that date. */
4046:
4047: /* Passing null to this routine forces it to drive using a join
4048: to ar_line_rev_adj_gt table */
4049: true_lines_by_gl_date(null);
4050:
4051: /* This is phase 2 of rounding.
4052: With this cursor and subsequent UPDATE, we detect situations
4467:
4468: /* This call to the MRC wrapper will eventually call a clone of this
4469: routine that was designed to round MRC gld table data. The MRC
4470: call like the primary sob one utilizes the amounts and line_ids
4471: from ar_line_rev_adj_gt (global temporary table).
4472:
4473: Note that mrc_correct_rounding verifies that MRC is enabled before
4474: doing anything */
4475: ar_mrc_engine2.mrc_correct_rounding(