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_SALESREPS

Line 580: FROM ra_cust_trx_line_salesreps

576: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
577: ,org_id
578: /* Multi-Org Access Control Changes for SSA;end;anukumar;11/01/2002*/
579: --end anuj
580: FROM ra_cust_trx_line_salesreps
581: WHERE customer_trx_id = g_customer_trx_id
582: AND customer_trx_line_id IS NOT NULL
583: /* BEGIN bug 3067675 */
584: --AND salesrep_id = g_from_salesrep_id

Line 1861: FROM ra_cust_trx_line_salesreps s,

1857:
1858: CURSOR c_salesrep_totals IS
1859: SELECT NVL(SUM(s.revenue_percent_split),0),
1860: NVL(SUM(s.non_revenue_percent_split),0)
1861: FROM ra_cust_trx_line_salesreps s,
1862: mtl_item_categories mic,
1863: ra_customer_trx_lines l
1864: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1865: AND l.customer_trx_id = p_customer_trx_id

Line 1958: FROM ra_cust_trx_line_salesreps ls

1954: AND ((p_salesrep_id IS NULL AND p_salesgroup_id IS NULL AND
1955: p_sales_credit_type IS NULL)
1956: OR EXISTS
1957: (SELECT 'X'
1958: FROM ra_cust_trx_line_salesreps ls
1959: WHERE ls.customer_trx_line_id = l.customer_trx_line_id
1960: AND ls.salesrep_id = NVL(p_salesrep_id,ls.salesrep_id)
1961: AND DECODE(p_sales_credit_type,'N',NVL(ls.non_revenue_salesgroup_id, -9999), NVL(ls.revenue_salesgroup_id, -9999)) =
1962: NVL(p_salesgroup_id, DECODE(p_sales_credit_type,'N',NVL(ls.non_revenue_salesgroup_id, -9999), NVL(ls.revenue_salesgroup_id, -9999)))

Line 2122: FROM ra_cust_trx_line_salesreps ls

2118: AND ((p_salesrep_id IS NULL AND p_salesgroup_id IS NULL)
2119: /* AND p_sales_credit_type IS NULL) */
2120: OR EXISTS
2121: (SELECT 'X'
2122: FROM ra_cust_trx_line_salesreps ls
2123: WHERE ls.customer_trx_line_id = l.customer_trx_line_id
2124: AND ls.salesrep_id = NVL(p_salesrep_id,ls.salesrep_id)
2125: AND DECODE(p_sales_credit_type,'N',NVL(ls.non_revenue_salesgroup_id, -9999), NVL(ls.revenue_salesgroup_id, -9999)) =
2126: NVL(p_salesgroup_id, DECODE(p_sales_credit_type,'N',NVL(ls.non_revenue_salesgroup_id, -9999), NVL(ls.revenue_salesgroup_id, -9999)))

Line 2140: ra_cust_trx_line_salesreps s

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')
2144: AND NVL(d.revenue_adjustment_id,0) <> NVL(p_revenue_adjustment_id,

Line 2162: ,ra_cust_trx_line_salesreps 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
2165: AND d.customer_trx_line_id = l.customer_trx_line_id
2166: AND d.account_class = DECODE(p_adjustment_type,'EA','UNEARN','REV')

Line 2180: FROM ra_cust_trx_line_salesreps s

2176: NVL(s.revenue_salesgroup_id, -9999));
2177:
2178: CURSOR c_line_nr_amount (p_cust_trx_line_id NUMBER) IS
2179: SELECT SUM(NVL(s.non_revenue_amount_split,0)) amount
2180: FROM ra_cust_trx_line_salesreps s
2181: WHERE s.customer_trx_line_id = p_cust_trx_line_id
2182: AND s.salesrep_id = NVL(p_salesrep_id,s.salesrep_id)
2183: AND NVL(s.non_revenue_salesgroup_id, -9999) =
2184: NVL(p_salesgroup_id,

Line 2192: ,ra_cust_trx_line_salesreps s

2188:
2189: CURSOR c_cm_line_nr_amount (p_cust_trx_line_id NUMBER) IS
2190: SELECT NVL(SUM(NVL(s.non_revenue_amount_split,0)),0) amount
2191: FROM ra_customer_trx_lines l
2192: ,ra_cust_trx_line_salesreps s
2193: WHERE l.previous_customer_trx_line_id = p_cust_trx_line_id
2194: AND l.customer_trx_line_id = s.customer_trx_line_id
2195: AND s.salesrep_id = NVL(p_salesrep_id /* sr_id */,s.salesrep_id)
2196: AND NVL(s.non_revenue_salesgroup_id, -9999) =

Line 2205: FROM ra_cust_trx_line_salesreps s

2201: we'll need to get salescredit revenue from salescredits
2202: table instead of gl_dist */
2203: CURSOR c_line_rnsr_amount (p_cust_trx_line_id NUMBER) IS
2204: SELECT SUM(NVL(s.revenue_amount_split,0)) amount
2205: FROM ra_cust_trx_line_salesreps s
2206: WHERE s.customer_trx_line_id = p_cust_trx_line_id
2207: AND s.salesrep_id = NVL(p_salesrep_id,s.salesrep_id)
2208: AND NVL(s.revenue_salesgroup_id, -9999) =
2209: NVL(p_salesgroup_id,

Line 2217: ,ra_cust_trx_line_salesreps s

2213:
2214: CURSOR c_cm_line_rnsr_amount (p_cust_trx_line_id NUMBER) IS
2215: SELECT NVL(SUM(NVL(s.revenue_amount_split,0)),0) amount
2216: FROM ra_customer_trx_lines l
2217: ,ra_cust_trx_line_salesreps s
2218: WHERE l.previous_customer_trx_line_id = p_cust_trx_line_id
2219: AND l.customer_trx_line_id = s.customer_trx_line_id
2220: AND s.salesrep_id = NVL(p_salesrep_id /* sr_id */,s.salesrep_id)
2221: AND NVL(s.revenue_salesgroup_id, -9999) =

Line 2495: FROM ra_cust_trx_line_salesreps ls

2491: AND ((p_salesrep_id IS NULL AND p_salesgroup_id IS NULL AND
2492: p_sales_credit_type IS NULL)
2493: OR EXISTS
2494: (SELECT 'X'
2495: FROM ra_cust_trx_line_salesreps ls
2496: WHERE ls.customer_trx_line_id = l.customer_trx_line_id
2497: AND ls.salesrep_id = NVL(p_salesrep_id,ls.salesrep_id)
2498: AND DECODE(p_sales_credit_type,'N',
2499: NVL(ls.non_revenue_salesgroup_id, -9999),