APPS.ARP_AUTO_RULE dependencies on AR_REVENUE_ASSIGNMENTS

Line 693: | that uses ar_revenue_assignments view. |

689: | revenue account assignments by trx_id |
690: | 04-OCT-00 Jon Beckett Assignments not created if revenue |
691: | deferred(bug 1551488 Rev Mgmt phase II)|
692: | 10-DEC-01 M Raymond Added ORDERED hint to gl_date sql |
693: | that uses ar_revenue_assignments view. |
694: | See bug 2143064 for details. |
695: | 13-Aug-02 Debbie Jancis Modified for MRC Trigger replacement |
696: | added calls for |
697: | ra_cust_trx_line_gl_dist processing |

Line 751: ar_revenue_assignments

747: INTO
748: min_gl_date,
749: max_gl_date
750: FROM
751: ar_revenue_assignments
752: WHERE
753: customer_trx_id = p_trx_id
754: AND period_set_name = p_period_set_name ;
755:

Line 906: ar_revenue_assignments ass

902: ra_rules acc_rule,
903: ra_cust_trx_line_gl_dist rec,
904: ra_cust_trx_line_gl_dist dist,
905: ra_cust_trx_line_salesreps cmsrep,
906: ar_revenue_assignments ass
907: WHERE
908: header.customer_trx_id = p_trx_id
909: AND ass.customer_trx_id = p_trx_id /* 5752668 */
910: AND header.complete_flag = 'Y'