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.OE_FLEX_COGS_PUB dependencies on OE_SALES_CREDITS

Line 1138: FROM OE_SALES_CREDITS

1134: IF (l_order_line_id IS NOT NULL) THEN
1135: BEGIN
1136: SELECT SALESREP_ID
1137: INTO l_salesrep_id
1138: FROM OE_SALES_CREDITS
1139: WHERE LINE_ID = L_ORDER_LINE_ID
1140: AND SALESREP_ID = (
1141: SELECT MIN(SALESREP_ID)
1142: FROM OE_SALES_CREDITS SC ,

Line 1142: FROM OE_SALES_CREDITS SC ,

1138: FROM OE_SALES_CREDITS
1139: WHERE LINE_ID = L_ORDER_LINE_ID
1140: AND SALESREP_ID = (
1141: SELECT MIN(SALESREP_ID)
1142: FROM OE_SALES_CREDITS SC ,
1143: OE_SALES_CREDIT_TYPES SCT
1144: WHERE SC.LINE_ID = L_ORDER_LINE_ID
1145: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1146: AND SCT.QUOTA_FLAG = 'Y'

Line 1149: FROM OE_SALES_CREDITS SC, --Bug4096083 start

1145: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1146: AND SCT.QUOTA_FLAG = 'Y'
1147: AND SC.PERCENT = (
1148: SELECT MAX(PERCENT)
1149: FROM OE_SALES_CREDITS SC, --Bug4096083 start
1150: OE_SALES_CREDIT_TYPES SCT
1151: WHERE SC.LINE_ID = L_ORDER_LINE_ID
1152: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1153: AND SCT.QUOTA_FLAG = 'Y' --Bug4096083 end

Line 1166: FROM OE_SALES_CREDITS

1162: END IF;
1163: BEGIN
1164: SELECT SALESREP_ID
1165: INTO l_salesrep_id
1166: FROM OE_SALES_CREDITS
1167: WHERE HEADER_ID = l_header_id
1168: AND LINE_ID IS NULL
1169: AND SALESREP_ID = (
1170: SELECT MIN(SALESREP_ID)

Line 1171: FROM OE_SALES_CREDITS SC ,

1167: WHERE HEADER_ID = l_header_id
1168: AND LINE_ID IS NULL
1169: AND SALESREP_ID = (
1170: SELECT MIN(SALESREP_ID)
1171: FROM OE_SALES_CREDITS SC ,
1172: OE_SALES_CREDIT_TYPES SCT
1173: WHERE SC.HEADER_ID = L_HEADER_ID
1174: AND SC.LINE_ID IS NULL
1175: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID

Line 1179: FROM OE_SALES_CREDITS SC, --Bug4096083 start

1175: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1176: AND SCT.QUOTA_FLAG = 'Y'
1177: AND SC.PERCENT = (
1178: SELECT MAX(PERCENT)
1179: FROM OE_SALES_CREDITS SC, --Bug4096083 start
1180: OE_SALES_CREDIT_TYPES SCT
1181: WHERE SC.HEADER_ID = L_HEADER_ID
1182: AND SC.LINE_ID IS NULL
1183: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID