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_CUSTOMER_TRX

Line 138: FROM ra_customer_trx t

134: ,t.exchange_rate
135: ,NVL(c.precision,0) -- Bug 3480443
136: ,t.trx_date
137: ,t.invoicing_rule_id
138: FROM ra_customer_trx t
139: ,fnd_currencies c
140: WHERE t.invoice_currency_code = c.currency_code
141: AND t.customer_trx_id = p_customer_trx_id;
142:

Line 293: FROM ra_customer_trx t

289: l_prev_trx_id NUMBER;
290:
291: CURSOR c_trx_num IS
292: SELECT t.customer_trx_id
293: FROM ra_customer_trx t
294: ,ra_batch_sources bs
295: WHERE t.batch_source_id = bs.batch_source_id
296: AND t.trx_number = p_rev_adj_rec.trx_number
297: AND bs.name = NVL(p_rev_adj_rec.batch_source_name,bs.name)

Line 300: FROM ra_customer_trx_lines l

296: AND t.trx_number = p_rev_adj_rec.trx_number
297: AND bs.name = NVL(p_rev_adj_rec.batch_source_name,bs.name)
298: AND NVL(t.invoicing_rule_id,0) <> -3
299: AND NOT EXISTS (SELECT 'X'
300: FROM ra_customer_trx_lines l
301: WHERE l.customer_trx_id = t.customer_trx_id
302: AND l.line_type = 'LINE'
303: AND autorule_complete_flag IS NOT NULL);
304:

Line 307: FROM ra_customer_trx t

303: AND autorule_complete_flag IS NOT NULL);
304:
305: CURSOR c_trx_id IS
306: SELECT t.customer_trx_id
307: FROM ra_customer_trx t
308: WHERE t.customer_trx_id = p_rev_adj_rec.customer_trx_id
309: AND NVL(t.invoicing_rule_id,0) <> -3
310: AND NOT EXISTS (SELECT 'X'
311: FROM ra_customer_trx_lines l

Line 311: FROM ra_customer_trx_lines l

307: FROM ra_customer_trx t
308: WHERE t.customer_trx_id = p_rev_adj_rec.customer_trx_id
309: AND NVL(t.invoicing_rule_id,0) <> -3
310: AND NOT EXISTS (SELECT 'X'
311: FROM ra_customer_trx_lines l
312: WHERE l.customer_trx_id = t.customer_trx_id
313: AND l.line_type = 'LINE'
314: AND autorule_complete_flag IS NOT NULL);
315:

Line 320: ra_customer_trx t

316: CURSOR c_trx_type IS
317: SELECT tt.type,
318: t.previous_customer_trx_id
319: FROM ra_cust_trx_types tt,
320: ra_customer_trx t
321: WHERE tt.cust_trx_type_id = t.cust_trx_type_id
322: AND t.customer_trx_id = g_customer_trx_id;
323:
324: CURSOR c_invoice_total IS

Line 326: FROM ra_customer_trx_lines l

322: AND t.customer_trx_id = g_customer_trx_id;
323:
324: CURSOR c_invoice_total IS
325: SELECT SUM(l.extended_amount)
326: FROM ra_customer_trx_lines l
327: WHERE l.customer_trx_id = g_customer_trx_id
328: AND l.line_type = 'LINE';
329:
330: CURSOR c_cm_total IS

Line 332: FROM ra_customer_trx_lines l,

328: AND l.line_type = 'LINE';
329:
330: CURSOR c_cm_total IS
331: SELECT sum(l.extended_amount)
332: FROM ra_customer_trx_lines l,
333: ra_cust_trx_types tt,
334: ra_customer_trx cm
335: WHERE l.customer_trx_id = cm.customer_trx_id
336: AND cm.cust_trx_type_id = tt.cust_trx_type_id

Line 334: ra_customer_trx cm

330: CURSOR c_cm_total IS
331: SELECT sum(l.extended_amount)
332: FROM ra_customer_trx_lines l,
333: ra_cust_trx_types tt,
334: ra_customer_trx cm
335: WHERE l.customer_trx_id = cm.customer_trx_id
336: AND cm.cust_trx_type_id = tt.cust_trx_type_id
337: AND l.line_type = 'LINE'
338: AND tt.type = 'CM'

Line 596: FROM ra_customer_trx_lines

592: /* END bug 3067675 */
593:
594: CURSOR c_line_num (p_line_number NUMBER) IS
595: SELECT customer_trx_line_id
596: FROM ra_customer_trx_lines
597: WHERE line_number = p_line_number
598: AND customer_trx_id = g_customer_trx_id
599: AND line_type = 'LINE';
600:

Line 603: FROM ra_customer_trx_lines

599: AND line_type = 'LINE';
600:
601: CURSOR c_line_id (p_line_id NUMBER) IS
602: SELECT customer_trx_line_id
603: FROM ra_customer_trx_lines
604: WHERE customer_trx_line_id = p_line_id
605: AND line_type = 'LINE';
606:
607: BEGIN

Line 884: ra_customer_trx_lines l

880:
881: CURSOR c_cat_exists_on_trx(p_category_id NUMBER) IS
882: SELECT COUNT(*)
883: FROM mtl_item_categories c,
884: ra_customer_trx_lines l
885: WHERE c.inventory_item_id = l.inventory_item_id
886: AND l.customer_trx_id = g_customer_trx_id
887: AND c.category_id = p_category_id
888: AND l.line_type = 'LINE'

Line 1207: FROM ra_customer_trx_lines

1203: AND organization_id = g_inv_org_id;
1204:
1205: CURSOR c_item_exists_on_trx(p_item_id NUMBER) IS
1206: SELECT COUNT(*)
1207: FROM ra_customer_trx_lines
1208: WHERE customer_trx_id = g_customer_trx_id
1209: AND inventory_item_id = p_item_id
1210: AND line_type = 'LINE';
1211:

Line 1491: FROM ra_customer_trx_lines

1487: IS
1488:
1489: CURSOR c_line_num (p_line_number NUMBER) IS
1490: SELECT customer_trx_line_id
1491: FROM ra_customer_trx_lines
1492: WHERE line_number = p_line_number
1493: AND customer_trx_id = g_customer_trx_id
1494: AND line_type = 'LINE';
1495:

Line 1498: FROM ra_customer_trx_lines

1494: AND line_type = 'LINE';
1495:
1496: CURSOR c_line_id (p_line_id NUMBER) IS
1497: SELECT customer_trx_line_id
1498: FROM ra_customer_trx_lines
1499: WHERE customer_trx_line_id = p_line_id
1500: AND customer_trx_id = g_customer_trx_id
1501: AND line_type = 'LINE';
1502:

Line 1862: ra_customer_trx_lines l

1858: SELECT NVL(SUM(s.revenue_percent_split),0),
1859: NVL(SUM(s.non_revenue_percent_split),0)
1860: FROM ra_cust_trx_line_salesreps s,
1861: mtl_item_categories mic,
1862: ra_customer_trx_lines l
1863: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1864: AND l.customer_trx_id = p_customer_trx_id
1865: AND l.line_type = 'LINE'
1866: AND s.salesrep_id = NVL(p_salesrep_id,s.salesrep_id)

Line 1939: ,ra_customer_trx_lines l

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'
1942: AND l.customer_trx_id = p_customer_trx_id
1943: AND d.account_class IN ('REV','UNEARN')

Line 2023: /* Bug 3431815 - removed unnecessary extra join to ra_customer_trx

2019: l_cm_flag VARCHAR2(1);
2020:
2021: /* Bug 2560048 - credit memo amounts included in adjustable revenue
2022: calculation */
2023: /* Bug 3431815 - removed unnecessary extra join to ra_customer_trx
2024: to get credit memos */
2025: /* Bug 3536944: c_line broken up into 3 separate queries to improve
2026: performance */
2027:

Line 2032: ,ra_customer_trx_lines l

2028: CURSOR c_line IS
2029: SELECT l.customer_trx_line_id,
2030: lr.deferred_revenue_flag
2031: FROM mtl_item_categories mic
2032: ,ra_customer_trx_lines l
2033: ,ra_rules lr
2034: WHERE l.customer_trx_id = p_customer_trx_id
2035: AND l.line_type = 'LINE'
2036: AND l.customer_trx_line_id = NVL(p_customer_trx_line_id,l.customer_trx_line_id)

Line 2093: ,ra_customer_trx_lines l

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
2097: AND d.customer_trx_line_id = l.customer_trx_line_id

Line 2123: FROM ra_customer_trx_lines l

2119: NVL(s.revenue_adjustment_id,0) + 1);
2120:
2121: CURSOR c_cm_line_nr_amount (p_cust_trx_line_id NUMBER) IS
2122: SELECT NVL(SUM(NVL(s.non_revenue_amount_split,0)),0) amount
2123: FROM ra_customer_trx_lines l
2124: ,ra_cust_trx_line_salesreps s
2125: WHERE l.previous_customer_trx_line_id = p_cust_trx_line_id
2126: AND l.customer_trx_line_id = s.customer_trx_line_id
2127: AND s.salesrep_id = NVL(p_salesrep_id /* sr_id */,s.salesrep_id)

Line 2134: FROM ra_customer_trx cmt

2130: NVL(s.non_revenue_salesgroup_id, -9999));
2131:
2132: CURSOR c_unrec_cm(p_target_trx NUMBER) IS
2133: SELECT cmt.customer_trx_id
2134: FROM ra_customer_trx cmt
2135: WHERE cmt.previous_customer_trx_id = p_target_trx
2136: AND EXISTS ( SELECT 'Unrecognized CM'
2137: FROM ra_customer_trx_lines cmtl
2138: WHERE cmtl.customer_trx_id = cmt.customer_trx_id

Line 2137: FROM ra_customer_trx_lines cmtl

2133: SELECT cmt.customer_trx_id
2134: FROM ra_customer_trx cmt
2135: WHERE cmt.previous_customer_trx_id = p_target_trx
2136: AND EXISTS ( SELECT 'Unrecognized CM'
2137: FROM ra_customer_trx_lines cmtl
2138: WHERE cmtl.customer_trx_id = cmt.customer_trx_id
2139: AND cmtl.line_type = 'LINE'
2140: AND cmtl.autorule_complete_flag = 'N');
2141:

Line 2191: from ra_customer_trx

2187: p_adjustment_type in ('EA','UN')
2188: THEN
2189: select decode(previous_customer_trx_id, NULL,'N','Y')
2190: into l_cm_flag
2191: from ra_customer_trx
2192: where customer_trx_id = p_customer_trx_id;
2193:
2194: IF l_cm_flag = 'Y'
2195: THEN

Line 2312: ,ra_customer_trx_lines l

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