APPS.ARP_CREDIT_MEMO_MODULE dependencies on AR_REVENUE_ASSIGNMENTS_GT

Line 1662: table called ar_revenue_assignments_gt */

1658: ara.amount) )';
1659:
1660: /* Bug 2347001 - Added ORDERED hint and changed ar_revenue_assignments to
1661: ar_revenue_assignments_v (which in turn uses a global temporary
1662: table called ar_revenue_assignments_gt */
1663:
1664:
1665: /* Bug 2837488 - Changed ctls.cust_trx_line_salesrep_id to
1666: ctls.prev_cust_trx_line_salesrep_id */

Line 1670: INDEX (ara.ragt ar_revenue_assignments_gt_n1)

1666: ctls.prev_cust_trx_line_salesrep_id */
1667:
1668: l_rule_insert_dist_sql := l_rule_insert_dist_sql || CRLF ||
1669: '(SELECT /*+ ORDERED
1670: INDEX (ara.ragt ar_revenue_assignments_gt_n1)
1671: INDEX (inv_rec ra_cust_trx_line_gl_dist_n6) */
1672: ra_cust_trx_line_gl_dist_s.nextval, /* cust_trx_line_dist_id */
1673: ctl.created_by, /* created_by */
1674: sysdate, /* creation_date */

Line 4699: FROM AR_REVENUE_ASSIGNMENTS_GT

4695: IF p_select_rec.partial_period_flag = 'Y' THEN
4696:
4697: SELECT NVL(SUM(PPRR_AMOUNT), 0)
4698: INTO l_prev_line_tot_rev_amt
4699: FROM AR_REVENUE_ASSIGNMENTS_GT
4700: WHERE CUSTOMER_TRX_LINE_ID = p_select_rec.prev_cust_trx_line_id
4701: AND SESSION_ID = g_session_id
4702: AND ACCOUNT_CLASS = 'REV';
4703:

Line 5011: -- Populate ar_revenue_assignments_gt

5007: END;
5008: END IF;
5009:
5010: ---------------------------------------------------------------
5011: -- Populate ar_revenue_assignments_gt
5012: -- per bug 2347001
5013: ---------------------------------------------------------------
5014: BEGIN
5015: /* Increment session ID */