APPS.AR_RAAPI_UTIL dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 1938: FROM ra_cust_trx_line_gl_dist d

1934: l_all_line_total NUMBER;
1935:
1936: CURSOR c_all_line_total IS
1937: SELECT NVL(SUM(d.amount),0) amount
1938: FROM ra_cust_trx_line_gl_dist d
1939: ,mtl_item_categories mic
1940: ,ra_customer_trx_lines l
1941: WHERE d.customer_trx_line_id = l.customer_trx_line_id
1942: AND l.line_type = 'LINE'

Line 2136: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/

2132: ls.non_revenue_percent_split,ls.revenue_percent_split),0)) <> 0));
2133:
2134: /* Bug 7130380 : Added hint to improve performance */
2135: CURSOR c_line_amount (p_cust_trx_line_id NUMBER) IS
2136: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/
2137: NVL(SUM(d.amount),0) amount
2138: ,NVL(SUM(d.acctd_amount),0) acctd_amount
2139: FROM ra_cust_trx_line_gl_dist d,
2140: ra_cust_trx_line_salesreps s

Line 2139: FROM ra_cust_trx_line_gl_dist d,

2135: CURSOR c_line_amount (p_cust_trx_line_id NUMBER) IS
2136: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/
2137: NVL(SUM(d.amount),0) amount
2138: ,NVL(SUM(d.acctd_amount),0) acctd_amount
2139: FROM ra_cust_trx_line_gl_dist d,
2140: ra_cust_trx_line_salesreps s
2141: WHERE d.customer_trx_line_id = p_cust_trx_line_id
2142: AND d.customer_trx_id = p_customer_trx_id
2143: AND d.account_class = DECODE(p_adjustment_type,'EA','UNEARN','REV')

Line 2157: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/

2153: NVL(s.revenue_salesgroup_id, -9999));
2154:
2155: /* Bug 7130380 : Added hint to improve performanc */
2156: CURSOR c_cm_line_amount (p_cust_trx_line_id NUMBER) IS
2157: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/
2158: NVL(SUM(NVL(d.amount,0)),0) amount
2159: ,NVL(SUM(NVL(d.acctd_amount,0)),0) acctd_amount
2160: FROM ra_cust_trx_line_gl_dist d
2161: ,ra_customer_trx_lines l

Line 2160: FROM ra_cust_trx_line_gl_dist d

2156: CURSOR c_cm_line_amount (p_cust_trx_line_id NUMBER) IS
2157: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/
2158: NVL(SUM(NVL(d.amount,0)),0) amount
2159: ,NVL(SUM(NVL(d.acctd_amount,0)),0) acctd_amount
2160: FROM ra_cust_trx_line_gl_dist d
2161: ,ra_customer_trx_lines l
2162: ,ra_cust_trx_line_salesreps s
2163: WHERE l.previous_customer_trx_line_id = p_cust_trx_line_id
2164: AND d.customer_trx_id = l.customer_trx_id

Line 2367: FROM ra_cust_trx_line_gl_dist_all d

2363:
2364: CURSOR c_line_amount (p_trx_id NUMBER, p_line_id NUMBER,
2365: p_adj_type VARCHAR2, p_rev_adj_id NUMBER) IS
2366: SELECT SUM(NVL(d.amount,0)) amount
2367: FROM ra_cust_trx_line_gl_dist_all d
2368: WHERE d.customer_trx_line_id = NVL(p_line_id,
2369: d.customer_trx_line_id)
2370: AND d.customer_trx_id = p_trx_id
2371: AND d.account_class = DECODE(p_adj_type,'EA','UNEARN','REV')

Line 2379: FROM ra_cust_trx_line_gl_dist_all d,

2375:
2376: CURSOR c_cm_line_amount (p_trx_id NUMBER, p_line_id NUMBER,
2377: p_adj_type VARCHAR2, p_rev_adj_id NUMBER) IS
2378: SELECT NVL(SUM(NVL(d.amount,0)),0) amount
2379: FROM ra_cust_trx_line_gl_dist_all d,
2380: ra_customer_trx_lines_all l
2381: WHERE l.previous_customer_trx_line_id =
2382: NVL(p_line_id,
2383: l.previous_customer_trx_line_id)

Line 2468: FROM ra_cust_trx_line_gl_dist d

2464: adjusted_by_other_user EXCEPTION;
2465:
2466: CURSOR c_revenue_total IS
2467: SELECT NVL(SUM(d.amount),0) amount
2468: FROM ra_cust_trx_line_gl_dist d
2469: ,mtl_item_categories mic
2470: ,ra_customer_trx_lines l
2471: WHERE d.customer_trx_line_id = l.customer_trx_line_id
2472: AND d.account_class IN ('REV','UNEARN')

Line 2679: FROM ra_cust_trx_line_gl_dist

2675: l_err_mesg VARCHAR2(2000);
2676:
2677: CURSOR c_gl_date IS
2678: SELECT DISTINCT gl_date
2679: FROM ra_cust_trx_line_gl_dist
2680: WHERE revenue_adjustment_id = p_revenue_adjustment_id;
2681:
2682: BEGIN
2683: IF PG_DEBUG in ('Y', 'C') THEN

Line 2707: UPDATE ra_cust_trx_line_gl_dist

2703: error_message => l_err_mesg)
2704: THEN
2705: IF c1.gl_date <> l_gl_date
2706: THEN
2707: UPDATE ra_cust_trx_line_gl_dist
2708: SET gl_date = l_gl_date
2709: WHERE revenue_adjustment_id = p_revenue_adjustment_id
2710: AND gl_date = c1.gl_date;
2711: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');

Line 2975: FROM ra_cust_trx_line_gl_dist

2971: no dists exist, return FALSE if line is not zero or if
2972: it is zero and distributions exist */
2973: SELECT sum(percent)
2974: INTO l_unearned_zero_lines
2975: FROM ra_cust_trx_line_gl_dist
2976: WHERE customer_trx_id = p_customer_trx_id
2977: AND customer_trx_line_id = NVL(p_customer_trx_line_id,
2978: customer_trx_line_id)
2979: AND account_class = DECODE(p_adjustment_type,'EA','REV',