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 1863: ra_customer_trx_lines l

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
1866: AND l.line_type = 'LINE'
1867: AND s.salesrep_id = NVL(p_salesrep_id,s.salesrep_id)

Line 1940: ,ra_customer_trx_lines l

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

Line 2004: FROM ra_customer_trx cmt

2000: RETURN BOOLEAN
2001: IS
2002: CURSOR c_unrec_cm(p_target_trx NUMBER) IS
2003: SELECT cmt.customer_trx_id
2004: FROM ra_customer_trx cmt
2005: WHERE cmt.previous_customer_trx_id = p_target_trx
2006: AND EXISTS ( SELECT 'Unrecognized CM'
2007: FROM ra_customer_trx_lines cmtl
2008: WHERE cmtl.customer_trx_id = cmt.customer_trx_id

Line 2007: FROM ra_customer_trx_lines cmtl

2003: SELECT cmt.customer_trx_id
2004: FROM ra_customer_trx cmt
2005: WHERE cmt.previous_customer_trx_id = p_target_trx
2006: AND EXISTS ( SELECT 'Unrecognized CM'
2007: FROM ra_customer_trx_lines cmtl
2008: WHERE cmtl.customer_trx_id = cmt.customer_trx_id
2009: AND cmtl.line_type = 'LINE'
2010: AND cmtl.autorule_complete_flag = 'N');
2011:

Line 2043: from ra_customer_trx

2039: p_adjustment_type in ('EA','UN')
2040: THEN
2041: select decode(previous_customer_trx_id, NULL,'N','Y')
2042: into l_cm_flag
2043: from ra_customer_trx
2044: where customer_trx_id = p_customer_trx_id;
2045:
2046: IF l_cm_flag = 'Y'
2047: THEN

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

2086: l_cm_flag VARCHAR2(1);
2087:
2088: /* Bug 2560048 - credit memo amounts included in adjustable revenue
2089: calculation */
2090: /* Bug 3431815 - removed unnecessary extra join to ra_customer_trx
2091: to get credit memos */
2092: /* Bug 3536944: c_line broken up into 3 separate queries to improve
2093: performance */
2094:

Line 2099: ,ra_customer_trx_lines l

2095: CURSOR c_line IS
2096: SELECT l.customer_trx_line_id,
2097: lr.deferred_revenue_flag
2098: FROM mtl_item_categories mic
2099: ,ra_customer_trx_lines l
2100: ,ra_rules lr
2101: WHERE l.customer_trx_id = p_customer_trx_id
2102: AND l.line_type = 'LINE'
2103: AND l.customer_trx_line_id = NVL(p_customer_trx_line_id,l.customer_trx_line_id)

Line 2161: ,ra_customer_trx_lines l

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

Line 2191: FROM ra_customer_trx_lines l

2187: NVL(s.revenue_adjustment_id,0) + 1);
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)

Line 2216: FROM ra_customer_trx_lines l

2212: NVL(s.revenue_adjustment_id,0) + 1);
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)

Line 2380: ra_customer_trx_lines_all l

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)
2384: AND l.previous_customer_trx_id = p_trx_id

Line 2470: ,ra_customer_trx_lines l

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

Line 2940: p_check_line_amt skips the test of ra_customer_trx_lines when

2936:
2937: returns TRUE if there are no REV lines for current zero line
2938: returns FALSE if line is not zero or is zero and has REV lines
2939:
2940: p_check_line_amt skips the test of ra_customer_trx_lines when
2941: that information has already been tested */
2942: FUNCTION unearned_zero_lines(p_customer_trx_id IN NUMBER,
2943: p_customer_trx_line_id IN NUMBER DEFAULT NULL,
2944: p_check_line_amt IN VARCHAR DEFAULT 'Y',

Line 2955: FROM ra_customer_trx_lines l

2951: THEN
2952: /* Are there any zero lines? */
2953: SELECT count(*)
2954: INTO l_zero_lines
2955: FROM ra_customer_trx_lines l
2956: WHERE l.customer_trx_id = p_customer_trx_id
2957: AND l.customer_trx_line_id = NVL(p_customer_trx_line_id,
2958: l.customer_trx_line_id)
2959: AND l.line_type = 'LINE'