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_REVENUE_ADJUSTMENT_PVT dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 493: FROM ra_cust_trx_line_salesreps ls

489: AND ((AR_RAAPI_UTIL.g_from_salesrep_id IS NULL AND
490: AR_RAAPI_UTIL.g_from_salesgroup_id IS NULL)
491: OR EXISTS
492: (SELECT 'X'
493: FROM ra_cust_trx_line_salesreps ls
494: WHERE ls.customer_trx_line_id = l.customer_trx_line_id
495: AND ls.salesrep_id =
496: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,ls.salesrep_id)
497: AND NVL(ls.revenue_salesgroup_id, -9999) =

Line 673: FROM ra_cust_trx_line_salesreps

669:
670: /* Check for salesreps for use later */
671: SELECT count(*)
672: INTO l_sr_count
673: FROM ra_cust_trx_line_salesreps
674: WHERE customer_trx_line_id = l_line_id
675: AND NVL(revenue_percent_split,0) <> 0
676: AND customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id;
677:

Line 967: FROM ra_cust_trx_line_salesreps s

963: invalid_ccid EXCEPTION;
964:
965: CURSOR c_trx_total IS
966: SELECT SUM(NVL(s.revenue_amount_split,0))
967: FROM ra_cust_trx_line_salesreps s
968: ,mtl_item_categories mic
969: ,ra_customer_trx_lines l
970: WHERE s.customer_trx_line_id = l.customer_trx_line_id
971: AND l.line_type = 'LINE'

Line 984: FROM ra_cust_trx_line_salesreps s1

980: DECODE(AR_RAAPI_UTIL.g_from_category_id,NULL,0,mic.category_id)
981: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id
982: AND EXISTS
983: (SELECT s1.salesrep_id
984: FROM ra_cust_trx_line_salesreps s1
985: WHERE s1.customer_trx_line_id = l.customer_trx_line_id
986: AND s1.salesrep_id =
987: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s1.salesrep_id)
988: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s1.non_revenue_salesgroup_id, -9999), NVL(s1.revenue_salesgroup_id, -9999)) =

Line 1015: FROM ra_cust_trx_line_salesreps s

1011: DECODE(AR_RAAPI_UTIL.g_from_category_id,NULL,0,mic.category_id)
1012: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id
1013: AND EXISTS
1014: (SELECT s.salesrep_id
1015: FROM ra_cust_trx_line_salesreps s
1016: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1017: AND s.salesrep_id =
1018: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1019: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =

Line 1030: ,ra_cust_trx_line_salesreps s

1026: CURSOR c_nonrev_trx_total IS
1027: SELECT SUM(NVL(s.non_revenue_amount_split,0))
1028: FROM ra_customer_trx_lines l
1029: ,mtl_item_categories mic
1030: ,ra_cust_trx_line_salesreps s
1031: WHERE l.customer_trx_line_id = s.customer_trx_line_id
1032: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
1033: l.customer_trx_line_id)
1034: AND NVL(l.inventory_item_id,0) =

Line 1062: FROM ra_cust_trx_line_salesreps s

1058: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id
1059: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1060: AND EXISTS
1061: (SELECT s.salesrep_id
1062: FROM ra_cust_trx_line_salesreps s
1063: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1064: AND NVL(s.non_revenue_percent_split,0) <> 0
1065: AND s.salesrep_id =
1066: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)

Line 1081: FROM ra_cust_trx_line_salesreps s

1077: ,l.inventory_item_id
1078: ,l.memo_line_id
1079: ,l.warehouse_id
1080: ,l.line_number
1081: FROM ra_cust_trx_line_salesreps s
1082: ,mtl_item_categories mic
1083: ,ra_customer_trx_lines l
1084: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1085: AND l.customer_trx_line_id = s.customer_trx_line_id

Line 1098: FROM ra_cust_trx_line_salesreps s1

1094: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id
1095: AND l.line_type = 'LINE'
1096: AND EXISTS
1097: (SELECT s1.salesrep_id
1098: FROM ra_cust_trx_line_salesreps s1
1099: WHERE s1.customer_trx_line_id = l.customer_trx_line_id
1100: AND s1.salesrep_id =
1101: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s1.salesrep_id)
1102: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s1.non_revenue_salesgroup_id, -9999), NVL(s1.revenue_salesgroup_id, -9999)) =

Line 1120: FROM ra_cust_trx_line_salesreps

1116: HAVING SUM(s.revenue_amount_split) <> 0;
1117:
1118: CURSOR c_line_rsc_amount IS
1119: SELECT NVL(SUM(revenue_amount_split),0)
1120: FROM ra_cust_trx_line_salesreps
1121: WHERE customer_trx_line_id = l_cust_trx_line_id
1122: and NVL(revenue_percent_split,0) <> 0
1123: AND customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1124: and salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,salesrep_id)

Line 1153: FROM ra_cust_trx_line_salesreps s

1149: AND d.account_class = 'REV';
1150:
1151: CURSOR c_line_nonrev_total IS
1152: SELECT SUM(NVL(s.non_revenue_amount_split,0))
1153: FROM ra_cust_trx_line_salesreps s
1154: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1155: AND s.salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1156: and NVL(s.non_revenue_salesgroup_id, -9999) = NVL(AR_RAAPI_UTIL.g_from_salesgroup_id,NVL(s.non_revenue_salesgroup_id, -9999));
1157:

Line 1163: FROM ra_cust_trx_line_salesreps s,

1159: SELECT SUM(NVL(s.revenue_amount_split,0)) revenue_amount_split,
1160: SUM(NVL(s.revenue_percent_split,0)) revenue_percent_split,
1161: SUM(NVL(s.non_revenue_amount_split,0)) nonrev_amount_split,
1162: SUM(NVL(s.non_revenue_percent_split,0)) nonrev_percent_split
1163: FROM ra_cust_trx_line_salesreps s,
1164: ra_customer_trx_lines l
1165: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1166: AND s.salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1167: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =

Line 1178: FROM ra_cust_trx_line_salesreps s,

1174: SELECT NVL(SUM(s.revenue_amount_split),0),
1175: NVL(SUM(s.revenue_percent_split),0),
1176: NVL(SUM(s.non_revenue_amount_split),0),
1177: NVL(SUM(s.non_revenue_percent_split),0)
1178: FROM ra_cust_trx_line_salesreps s,
1179: ra_customer_trx_lines l
1180: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1181: AND s.salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id
1182: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =

Line 1194: FROM ra_cust_trx_line_salesreps s

1190: SUM(s.revenue_amount_split) revenue_amount_split,
1191: SUM(s.revenue_percent_split) revenue_percent_split,
1192: SUM(s.non_revenue_amount_split) nonrev_amount_split,
1193: SUM(s.non_revenue_percent_split) nonrev_percent_split
1194: FROM ra_cust_trx_line_salesreps s
1195: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1196: AND s.salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1197: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =
1198: NVL(AR_RAAPI_UTIL.g_from_salesgroup_id, DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)))

Line 2060: FROM ra_cust_trx_line_salesreps s

2056: invalid_amount EXCEPTION;
2057:
2058: CURSOR c_trx_total IS
2059: SELECT SUM(NVL(s.revenue_amount_split,0))
2060: FROM ra_cust_trx_line_salesreps s
2061: ,mtl_item_categories mic
2062: ,ra_customer_trx_lines l
2063: WHERE s.customer_trx_line_id = l.customer_trx_line_id
2064: AND l.line_type = 'LINE'

Line 2097: ,ra_cust_trx_line_salesreps s

2093: SELECT l.customer_trx_line_id
2094: ,l.line_number
2095: ,SUM(NVL(s.revenue_amount_split,0)) amount
2096: FROM mtl_item_categories mic
2097: ,ra_cust_trx_line_salesreps s
2098: ,ra_customer_trx_lines l
2099: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2100: AND l.customer_trx_line_id = s.customer_trx_line_id
2101: AND l.customer_trx_line_id =

Line 2119: FROM ra_cust_trx_line_salesreps s,

2115: SELECT NVL(SUM(s.revenue_amount_split),0),
2116: NVL(SUM(s.revenue_percent_split),0),
2117: NVL(SUM(s.non_revenue_amount_split),0),
2118: NVL(SUM(s.non_revenue_percent_split),0)
2119: FROM ra_cust_trx_line_salesreps s,
2120: ra_customer_trx_lines l
2121: WHERE s.customer_trx_line_id = l_cust_trx_line_id
2122: AND s.salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id
2123: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =

Line 2936: FROM ra_cust_trx_line_salesreps

2932: SELECT COUNT(*)
2933: FROM ra_salesreps
2934: WHERE salesrep_id IN
2935: (SELECT salesrep_id
2936: FROM ra_cust_trx_line_salesreps
2937: WHERE customer_trx_line_id = p_customer_trx_line_id
2938: AND NVL(revenue_percent_split,0) <> 0
2939: GROUP by salesrep_id
2940: HAVING SUM(NVL(revenue_percent_split,0)) <> 0)

Line 2947: FROM ra_cust_trx_line_salesreps

2943: CURSOR c_salesrep IS
2944: SELECT salesrep_id,
2945: SUM(NVL(revenue_percent_split,0)) revenue_percent_split,
2946: MAX(cust_trx_line_salesrep_id) max_id
2947: FROM ra_cust_trx_line_salesreps
2948: WHERE customer_trx_line_id = p_customer_trx_line_id
2949: AND salesrep_id = NVL(p_salesrep_id,salesrep_id)
2950: AND NVL(revenue_percent_split,0) <> 0
2951: GROUP by salesrep_id

Line 2956: FROM ra_cust_trx_line_salesreps

2952: HAVING SUM(NVL(revenue_percent_split,0)) <> 0;
2953:
2954: CURSOR c_last_salescredit IS
2955: SELECT NVL(revenue_percent_split,0)
2956: FROM ra_cust_trx_line_salesreps
2957: WHERE customer_trx_line_id = p_customer_trx_line_id
2958: AND cust_trx_line_salesrep_id = l_last_salescredit_id;
2959:
2960: CURSOR c_line IS

Line 3360: FROM ra_cust_trx_line_salesreps

3356: SELECT COUNT(*)
3357: FROM ra_salesreps
3358: WHERE salesrep_id IN
3359: (SELECT salesrep_id
3360: FROM ra_cust_trx_line_salesreps
3361: WHERE customer_trx_line_id = p_customer_trx_line_id
3362: AND NVL(revenue_percent_split,0) <> 0
3363: GROUP by salesrep_id
3364: HAVING SUM(NVL(revenue_percent_split,0)) <> 0)

Line 3371: FROM ra_cust_trx_line_salesreps

3367: CURSOR c_salesrep IS
3368: SELECT salesrep_id,
3369: SUM(NVL(revenue_percent_split,0)) revenue_percent_split,
3370: MAX(cust_trx_line_salesrep_id) max_id
3371: FROM ra_cust_trx_line_salesreps
3372: WHERE customer_trx_line_id = p_customer_trx_line_id
3373: AND salesrep_id = NVL(p_salesrep_id,salesrep_id)
3374: AND NVL(revenue_percent_split,0) <> 0
3375: GROUP by salesrep_id

Line 3380: FROM ra_cust_trx_line_salesreps

3376: HAVING SUM(NVL(revenue_percent_split,0)) <> 0;
3377:
3378: CURSOR c_last_salescredit IS
3379: SELECT NVL(revenue_percent_split,0)
3380: FROM ra_cust_trx_line_salesreps
3381: WHERE customer_trx_line_id = p_customer_trx_line_id
3382: AND cust_trx_line_salesrep_id = l_last_salescredit_id;
3383:
3384: -- Bug 1930302

Line 4045: FROM ra_cust_trx_line_salesreps

4041: ,l.accounting_rule_id;
4042:
4043: CURSOR c_line_salesrep_amount IS
4044: SELECT SUM(NVL(revenue_amount_split,0))
4045: FROM ra_cust_trx_line_salesreps
4046: WHERE customer_trx_line_id = l_line_id
4047: AND customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4048: AND salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,salesrep_id)
4049: AND NVL(revenue_salesgroup_id, -9999) = NVL(AR_RAAPI_UTIL.g_from_salesgroup_id,NVL(revenue_salesgroup_id, -9999));

Line 4756: FROM ra_cust_trx_line_salesreps

4752: SELECT COUNT(*)
4753: FROM ra_salesreps
4754: WHERE salesrep_id IN
4755: (SELECT salesrep_id
4756: FROM ra_cust_trx_line_salesreps
4757: WHERE customer_trx_line_id = p_customer_trx_line_id
4758: AND NVL(revenue_percent_split,0) <> 0
4759: GROUP by salesrep_id
4760: HAVING SUM(NVL(revenue_percent_split,0)) <> 0);

Line 4771: FROM ra_cust_trx_line_salesreps

4767: CURSOR c_salesrep IS
4768: SELECT salesrep_id,
4769: SUM(NVL(revenue_percent_split,0)) revenue_percent_split,
4770: MAX(cust_trx_line_salesrep_id) max_id
4771: FROM ra_cust_trx_line_salesreps
4772: WHERE customer_trx_line_id = p_customer_trx_line_id
4773: AND NVL(revenue_percent_split,0) <> 0
4774: GROUP by salesrep_id
4775: HAVING SUM(NVL(revenue_percent_split,0)) <> 0;

Line 5115: SELECT ra_cust_trx_line_salesreps_s.NEXTVAL

5111: p_gl_date IN DATE)
5112: IS
5113:
5114: CURSOR get_salesrep_line_id IS
5115: SELECT ra_cust_trx_line_salesreps_s.NEXTVAL
5116: FROM dual;
5117:
5118: CURSOR get_gldist_line_id IS
5119: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL

Line 5154: INSERT INTO ra_cust_trx_line_salesreps

5150: ELSE
5151: l_user_id := FND_GLOBAL.USER_ID;
5152: END IF;
5153:
5154: INSERT INTO ra_cust_trx_line_salesreps
5155: (cust_trx_line_salesrep_id
5156: ,last_update_date
5157: ,last_updated_by
5158: ,creation_date