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