eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RAAPI_UTIL dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 1937: FROM ra_cust_trx_line_gl_dist d

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

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

2064: HAVING SUM(NVL(DECODE(p_sales_credit_type,'N',
2065: ls.non_revenue_percent_split,ls.revenue_percent_split),0)) <> 0));
2066: /* Bug 7130380 : Added hint to improve performance */
2067: CURSOR c_line_amount (p_cust_trx_line_id NUMBER) IS
2068: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/
2069: NVL(SUM(d.amount),0) amount
2070: ,NVL(SUM(d.acctd_amount),0) acctd_amount
2071: FROM ra_cust_trx_line_gl_dist d,
2072: ra_cust_trx_line_salesreps s

Line 2071: FROM ra_cust_trx_line_gl_dist d,

2067: CURSOR c_line_amount (p_cust_trx_line_id NUMBER) IS
2068: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/
2069: NVL(SUM(d.amount),0) amount
2070: ,NVL(SUM(d.acctd_amount),0) acctd_amount
2071: FROM ra_cust_trx_line_gl_dist d,
2072: ra_cust_trx_line_salesreps s
2073: WHERE d.customer_trx_line_id = p_cust_trx_line_id
2074: AND d.customer_trx_id = p_customer_trx_id
2075: AND d.account_class = DECODE(p_adjustment_type,'EA','UNEARN','REV')

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

2085: NVL(s.revenue_salesgroup_id, -9999));
2086:
2087: /* Bug 7130380 : Added hint to improve performanc */
2088: CURSOR c_cm_line_amount (p_cust_trx_line_id NUMBER) IS
2089: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/
2090: NVL(SUM(NVL(d.amount,0)),0) amount
2091: ,NVL(SUM(NVL(d.acctd_amount,0)),0) acctd_amount
2092: FROM ra_cust_trx_line_gl_dist d
2093: ,ra_customer_trx_lines l

Line 2092: FROM ra_cust_trx_line_gl_dist d

2088: CURSOR c_cm_line_amount (p_cust_trx_line_id NUMBER) IS
2089: SELECT /*+ index(d ra_cust_trx_line_gl_dist_n1) push_pred(s)*/
2090: NVL(SUM(NVL(d.amount,0)),0) amount
2091: ,NVL(SUM(NVL(d.acctd_amount,0)),0) acctd_amount
2092: FROM ra_cust_trx_line_gl_dist d
2093: ,ra_customer_trx_lines l
2094: ,ra_cust_trx_line_salesreps s
2095: WHERE l.previous_customer_trx_line_id = p_cust_trx_line_id
2096: AND d.customer_trx_id = l.customer_trx_id

Line 2310: FROM ra_cust_trx_line_gl_dist d

2306: adjusted_by_other_user EXCEPTION;
2307:
2308: CURSOR c_revenue_total IS
2309: SELECT NVL(SUM(d.amount),0) amount
2310: FROM ra_cust_trx_line_gl_dist d
2311: ,mtl_item_categories mic
2312: ,ra_customer_trx_lines l
2313: WHERE d.customer_trx_line_id = l.customer_trx_line_id
2314: AND d.account_class IN ('REV','UNEARN')

Line 2520: FROM ra_cust_trx_line_gl_dist

2516: l_err_mesg VARCHAR2(2000);
2517:
2518: CURSOR c_gl_date IS
2519: SELECT DISTINCT gl_date
2520: FROM ra_cust_trx_line_gl_dist
2521: WHERE revenue_adjustment_id = p_revenue_adjustment_id;
2522:
2523: BEGIN
2524: IF PG_DEBUG in ('Y', 'C') THEN

Line 2548: UPDATE ra_cust_trx_line_gl_dist

2544: error_message => l_err_mesg)
2545: THEN
2546: IF c1.gl_date <> l_gl_date
2547: THEN
2548: UPDATE ra_cust_trx_line_gl_dist
2549: SET gl_date = l_gl_date
2550: WHERE revenue_adjustment_id = p_revenue_adjustment_id
2551: AND gl_date = c1.gl_date;
2552: FND_MESSAGE.set_name('AR','AR_RA_GL_DATE_CHANGED');