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_S

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 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 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