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 502: FROM ra_cust_trx_line_salesreps ls

498: AND ((AR_RAAPI_UTIL.g_from_salesrep_id IS NULL AND
499: AR_RAAPI_UTIL.g_from_salesgroup_id IS NULL)
500: OR EXISTS
501: (SELECT 'X'
502: FROM ra_cust_trx_line_salesreps ls
503: WHERE ls.customer_trx_line_id = l.customer_trx_line_id
504: AND ls.salesrep_id =
505: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,ls.salesrep_id)
506: AND NVL(ls.revenue_salesgroup_id, -9999) =

Line 734: FROM ra_cust_trx_line_salesreps

730:
731: /* Check for salesreps for use later */
732: SELECT count(*)
733: INTO l_sr_count
734: FROM ra_cust_trx_line_salesreps
735: WHERE customer_trx_line_id = l_line_id
736: AND NVL(revenue_percent_split,0) <> 0
737: AND customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id;
738:

Line 1044: FROM ra_cust_trx_line_salesreps s

1040: invalid_ccid EXCEPTION;
1041:
1042: CURSOR c_trx_total IS
1043: SELECT SUM(NVL(s.revenue_amount_split,0))
1044: FROM ra_cust_trx_line_salesreps s
1045: ,mtl_item_categories mic
1046: ,ra_customer_trx_lines l
1047: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1048: AND l.line_type = 'LINE'

Line 1061: FROM ra_cust_trx_line_salesreps s1

1057: DECODE(AR_RAAPI_UTIL.g_from_category_id,NULL,0,mic.category_id)
1058: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id
1059: AND EXISTS
1060: (SELECT s1.salesrep_id
1061: FROM ra_cust_trx_line_salesreps s1
1062: WHERE s1.customer_trx_line_id = l.customer_trx_line_id
1063: AND s1.salesrep_id =
1064: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s1.salesrep_id)
1065: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s1.non_revenue_salesgroup_id, -9999), NVL(s1.revenue_salesgroup_id, -9999)) =

Line 1092: FROM ra_cust_trx_line_salesreps s

1088: DECODE(AR_RAAPI_UTIL.g_from_category_id,NULL,0,mic.category_id)
1089: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id
1090: AND EXISTS
1091: (SELECT s.salesrep_id
1092: FROM ra_cust_trx_line_salesreps s
1093: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1094: AND s.salesrep_id =
1095: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1096: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =

Line 1107: ,ra_cust_trx_line_salesreps s

1103: CURSOR c_nonrev_trx_total IS
1104: SELECT SUM(NVL(s.non_revenue_amount_split,0))
1105: FROM ra_customer_trx_lines l
1106: ,mtl_item_categories mic
1107: ,ra_cust_trx_line_salesreps s
1108: WHERE l.customer_trx_line_id = s.customer_trx_line_id
1109: AND l.customer_trx_line_id = NVL(AR_RAAPI_UTIL.g_from_cust_trx_line_id,
1110: l.customer_trx_line_id)
1111: AND NVL(l.inventory_item_id,0) =

Line 1139: FROM ra_cust_trx_line_salesreps s

1135: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id
1136: AND l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1137: AND EXISTS
1138: (SELECT 'nonrev salesrep' -- 9799882 -> was s.salesrep_id
1139: FROM ra_cust_trx_line_salesreps s
1140: WHERE s.customer_trx_line_id = l.customer_trx_line_id
1141: AND NVL(s.non_revenue_percent_split,0) <> 0
1142: AND s.salesrep_id =
1143: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)

Line 1158: FROM ra_cust_trx_line_salesreps s

1154: ,l.inventory_item_id
1155: ,l.memo_line_id
1156: ,l.warehouse_id
1157: ,l.line_number
1158: FROM ra_cust_trx_line_salesreps s
1159: ,mtl_item_categories mic
1160: ,ra_customer_trx_lines l
1161: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1162: AND l.customer_trx_line_id = s.customer_trx_line_id

Line 1175: FROM ra_cust_trx_line_salesreps s1

1171: AND mic.category_set_id(+) = AR_RAAPI_UTIL.g_category_set_id
1172: AND l.line_type = 'LINE'
1173: AND EXISTS
1174: (SELECT s1.salesrep_id
1175: FROM ra_cust_trx_line_salesreps s1
1176: WHERE s1.customer_trx_line_id = l.customer_trx_line_id
1177: AND s1.salesrep_id =
1178: NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s1.salesrep_id)
1179: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s1.non_revenue_salesgroup_id, -9999), NVL(s1.revenue_salesgroup_id, -9999)) =

Line 1197: FROM ra_cust_trx_line_salesreps

1193: HAVING SUM(s.revenue_amount_split) <> 0;
1194:
1195: CURSOR c_line_rsc_amount IS
1196: SELECT NVL(SUM(revenue_amount_split),0)
1197: FROM ra_cust_trx_line_salesreps
1198: WHERE customer_trx_line_id = l_cust_trx_line_id
1199: and NVL(revenue_percent_split,0) <> 0
1200: AND customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
1201: and salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,salesrep_id)

Line 1230: FROM ra_cust_trx_line_salesreps s

1226: AND d.account_class = 'REV';
1227:
1228: CURSOR c_line_nonrev_total IS
1229: SELECT SUM(NVL(s.non_revenue_amount_split,0))
1230: FROM ra_cust_trx_line_salesreps s
1231: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1232: AND s.salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1233: and NVL(s.non_revenue_salesgroup_id, -9999) = NVL(AR_RAAPI_UTIL.g_from_salesgroup_id,NVL(s.non_revenue_salesgroup_id, -9999));
1234:

Line 1240: FROM ra_cust_trx_line_salesreps s,

1236: SELECT SUM(NVL(s.revenue_amount_split,0)) revenue_amount_split,
1237: SUM(NVL(s.revenue_percent_split,0)) revenue_percent_split,
1238: SUM(NVL(s.non_revenue_amount_split,0)) nonrev_amount_split,
1239: SUM(NVL(s.non_revenue_percent_split,0)) nonrev_percent_split
1240: FROM ra_cust_trx_line_salesreps s,
1241: ra_customer_trx_lines l
1242: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1243: AND s.salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1244: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =

Line 1255: FROM ra_cust_trx_line_salesreps s,

1251: SELECT NVL(SUM(s.revenue_amount_split),0),
1252: NVL(SUM(s.revenue_percent_split),0),
1253: NVL(SUM(s.non_revenue_amount_split),0),
1254: NVL(SUM(s.non_revenue_percent_split),0)
1255: FROM ra_cust_trx_line_salesreps s,
1256: ra_customer_trx_lines l
1257: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1258: AND s.salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id
1259: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =

Line 1271: FROM ra_cust_trx_line_salesreps s

1267: SUM(s.revenue_amount_split) revenue_amount_split,
1268: SUM(s.revenue_percent_split) revenue_percent_split,
1269: SUM(s.non_revenue_amount_split) nonrev_amount_split,
1270: SUM(s.non_revenue_percent_split) nonrev_percent_split
1271: FROM ra_cust_trx_line_salesreps s
1272: WHERE s.customer_trx_line_id = l_cust_trx_line_id
1273: AND s.salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,s.salesrep_id)
1274: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =
1275: 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 2137: FROM ra_cust_trx_line_salesreps s

2133: invalid_amount EXCEPTION;
2134:
2135: CURSOR c_trx_total IS
2136: SELECT SUM(NVL(s.revenue_amount_split,0))
2137: FROM ra_cust_trx_line_salesreps s
2138: ,mtl_item_categories mic
2139: ,ra_customer_trx_lines l
2140: WHERE s.customer_trx_line_id = l.customer_trx_line_id
2141: AND l.line_type = 'LINE'

Line 2174: ,ra_cust_trx_line_salesreps s

2170: SELECT l.customer_trx_line_id
2171: ,l.line_number
2172: ,SUM(NVL(s.revenue_amount_split,0)) amount
2173: FROM mtl_item_categories mic
2174: ,ra_cust_trx_line_salesreps s
2175: ,ra_customer_trx_lines l
2176: WHERE l.customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
2177: AND l.customer_trx_line_id = s.customer_trx_line_id
2178: AND l.customer_trx_line_id =

Line 2196: FROM ra_cust_trx_line_salesreps s,

2192: SELECT NVL(SUM(s.revenue_amount_split),0),
2193: NVL(SUM(s.revenue_percent_split),0),
2194: NVL(SUM(s.non_revenue_amount_split),0),
2195: NVL(SUM(s.non_revenue_percent_split),0)
2196: FROM ra_cust_trx_line_salesreps s,
2197: ra_customer_trx_lines l
2198: WHERE s.customer_trx_line_id = l_cust_trx_line_id
2199: AND s.salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id
2200: AND DECODE(p_rev_adj_rec.sales_credit_type,'N', NVL(s.non_revenue_salesgroup_id, -9999), NVL(s.revenue_salesgroup_id, -9999)) =

Line 2846: ra_cust_trx_line_salesreps srep,

2842: ra_customer_trx_lines l,
2843: ra_customer_trx h,
2844: fnd_currencies fc,
2845: ra_cust_trx_line_gl_dist dist,
2846: ra_cust_trx_line_salesreps srep,
2847: ar_revenue_assignments ra
2848: WHERE
2849: l.customer_trx_line_id = p_customer_trx_line_id
2850: AND fc.currency_code = h.invoice_currency_code

Line 3121: FROM ra_cust_trx_line_salesreps

3117: SELECT COUNT(*)
3118: FROM ra_salesreps
3119: WHERE salesrep_id IN
3120: (SELECT salesrep_id
3121: FROM ra_cust_trx_line_salesreps
3122: WHERE customer_trx_line_id = p_customer_trx_line_id
3123: AND NVL(revenue_percent_split,0) <> 0
3124: GROUP by salesrep_id
3125: HAVING SUM(NVL(revenue_percent_split,0)) <> 0)

Line 3132: FROM ra_cust_trx_line_salesreps

3128: CURSOR c_salesrep IS
3129: SELECT salesrep_id,
3130: SUM(NVL(revenue_percent_split,0)) revenue_percent_split,
3131: MAX(cust_trx_line_salesrep_id) max_id
3132: FROM ra_cust_trx_line_salesreps
3133: WHERE customer_trx_line_id = p_customer_trx_line_id
3134: AND salesrep_id = NVL(p_salesrep_id,salesrep_id)
3135: AND NVL(revenue_percent_split,0) <> 0
3136: GROUP by salesrep_id

Line 3141: FROM ra_cust_trx_line_salesreps

3137: HAVING SUM(NVL(revenue_percent_split,0)) <> 0;
3138:
3139: CURSOR c_last_salescredit IS
3140: SELECT NVL(revenue_percent_split,0)
3141: FROM ra_cust_trx_line_salesreps
3142: WHERE customer_trx_line_id = p_customer_trx_line_id
3143: AND cust_trx_line_salesrep_id = l_last_salescredit_id;
3144:
3145: CURSOR c_line IS

Line 3553: FROM ra_cust_trx_line_salesreps

3549: SELECT COUNT(*)
3550: FROM ra_salesreps
3551: WHERE salesrep_id IN
3552: (SELECT salesrep_id
3553: FROM ra_cust_trx_line_salesreps
3554: WHERE customer_trx_line_id = p_customer_trx_line_id
3555: AND NVL(revenue_percent_split,0) <> 0
3556: GROUP by salesrep_id
3557: HAVING SUM(NVL(revenue_percent_split,0)) <> 0)

Line 3564: FROM ra_cust_trx_line_salesreps

3560: CURSOR c_salesrep IS
3561: SELECT salesrep_id,
3562: SUM(NVL(revenue_percent_split,0)) revenue_percent_split,
3563: MAX(cust_trx_line_salesrep_id) max_id
3564: FROM ra_cust_trx_line_salesreps
3565: WHERE customer_trx_line_id = p_customer_trx_line_id
3566: AND salesrep_id = NVL(p_salesrep_id,salesrep_id)
3567: AND NVL(revenue_percent_split,0) <> 0
3568: GROUP by salesrep_id

Line 3573: FROM ra_cust_trx_line_salesreps

3569: HAVING SUM(NVL(revenue_percent_split,0)) <> 0;
3570:
3571: CURSOR c_last_salescredit IS
3572: SELECT NVL(revenue_percent_split,0)
3573: FROM ra_cust_trx_line_salesreps
3574: WHERE customer_trx_line_id = p_customer_trx_line_id
3575: AND cust_trx_line_salesrep_id = l_last_salescredit_id;
3576:
3577: -- Bug 1930302

Line 4261: FROM ra_cust_trx_line_salesreps

4257: ,l.accounting_rule_id;
4258:
4259: CURSOR c_line_salesrep_amount IS
4260: SELECT SUM(NVL(revenue_amount_split,0))
4261: FROM ra_cust_trx_line_salesreps
4262: WHERE customer_trx_line_id = l_line_id
4263: AND customer_trx_id = AR_RAAPI_UTIL.g_customer_trx_id
4264: AND salesrep_id = NVL(AR_RAAPI_UTIL.g_from_salesrep_id,salesrep_id)
4265: AND NVL(revenue_salesgroup_id, -9999) = NVL(AR_RAAPI_UTIL.g_from_salesgroup_id,NVL(revenue_salesgroup_id, -9999));

Line 4981: FROM ra_cust_trx_line_salesreps

4977: SELECT COUNT(*)
4978: FROM ra_salesreps
4979: WHERE salesrep_id IN
4980: (SELECT salesrep_id
4981: FROM ra_cust_trx_line_salesreps
4982: WHERE customer_trx_line_id = p_customer_trx_line_id
4983: AND NVL(revenue_percent_split,0) <> 0
4984: GROUP by salesrep_id
4985: HAVING SUM(NVL(revenue_percent_split,0)) <> 0);

Line 4996: FROM ra_cust_trx_line_salesreps

4992: CURSOR c_salesrep IS
4993: SELECT salesrep_id,
4994: SUM(NVL(revenue_percent_split,0)) revenue_percent_split,
4995: MAX(cust_trx_line_salesrep_id) max_id
4996: FROM ra_cust_trx_line_salesreps
4997: WHERE customer_trx_line_id = p_customer_trx_line_id
4998: AND NVL(revenue_percent_split,0) <> 0
4999: GROUP by salesrep_id
5000: HAVING SUM(NVL(revenue_percent_split,0)) <> 0;

Line 5336: SELECT ra_cust_trx_line_salesreps_s.NEXTVAL

5332: p_gl_date IN DATE)
5333: IS
5334:
5335: CURSOR get_salesrep_line_id IS
5336: SELECT ra_cust_trx_line_salesreps_s.NEXTVAL
5337: FROM dual;
5338:
5339: CURSOR get_gldist_line_id IS
5340: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL

Line 5375: INSERT INTO ra_cust_trx_line_salesreps

5371: ELSE
5372: l_user_id := FND_GLOBAL.USER_ID;
5373: END IF;
5374:
5375: INSERT INTO ra_cust_trx_line_salesreps
5376: (cust_trx_line_salesrep_id
5377: ,last_update_date
5378: ,last_updated_by
5379: ,creation_date