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.AS_INT_TYP_COD_MIGRATION dependencies on AS_PROD_WORKSHEET_LINES

Line 1151: from AS_PROD_WORKSHEET_LINES;

1147: l_debug BOOLEAN := false;
1148:
1149: CURSOR Get_Min_Id IS
1150: select min(PROD_WORKSHEET_LINE_ID)
1151: from AS_PROD_WORKSHEET_LINES;
1152:
1153: CURSOR Get_Max_Id IS
1154: select max(PROD_WORKSHEET_LINE_ID)
1155: from AS_PROD_WORKSHEET_LINES;

Line 1155: from AS_PROD_WORKSHEET_LINES;

1151: from AS_PROD_WORKSHEET_LINES;
1152:
1153: CURSOR Get_Max_Id IS
1154: select max(PROD_WORKSHEET_LINE_ID)
1155: from AS_PROD_WORKSHEET_LINES;
1156:
1157: CURSOR Get_Next_Val IS
1158: select AS_PROD_WORKSHEET_LINES_S.nextval
1159: from dual;

Line 1158: select AS_PROD_WORKSHEET_LINES_S.nextval

1154: select max(PROD_WORKSHEET_LINE_ID)
1155: from AS_PROD_WORKSHEET_LINES;
1156:
1157: CURSOR Get_Next_Val IS
1158: select AS_PROD_WORKSHEET_LINES_S.nextval
1159: from dual;
1160:
1161: BEGIN
1162: -- First load the schema name

Line 1191: Create_Temp_Index('AS_PROD_WORKSHEET_LINES','PROD_WORKSHEET_LINE_ID,INTEREST_TYPE_ID',l_debug);

1187: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Maximum Id found:' || l_max_id);
1188: end if;
1189:
1190: -- Create temporary index to improve the performance
1191: Create_Temp_Index('AS_PROD_WORKSHEET_LINES','PROD_WORKSHEET_LINE_ID,INTEREST_TYPE_ID',l_debug);
1192:
1193: -- Initialize counter
1194: l_count := l_min_id;
1195:

Line 1203: update AS_PROD_WORKSHEET_LINES pwl

1199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Current loop count:' || l_count);
1200: end if;
1201:
1202: -- Update interest type
1203: update AS_PROD_WORKSHEET_LINES pwl
1204: set (product_category_id, product_cat_set_id) =
1205: (select int.product_category_id, int.product_cat_set_id
1206: from as_interest_types_b int
1207: where pwl.interest_type_id = int.interest_type_id)

Line 1220: Drop_Temp_Index('AS_PROD_WORKSHEET_LINES',l_debug);

1216: end loop;
1217: commit;
1218:
1219: -- Drop temporary index
1220: Drop_Temp_Index('AS_PROD_WORKSHEET_LINES',l_debug);
1221:
1222: If l_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1223: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','Migration for Forecast Product Worksheet finished successfully');
1224: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 1451: update as_prod_worksheet_lines set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;

1447: update as_sales_credits_denorm set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1448: update as_lead_lines_log set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1449: update as_fst_sales_categories set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1450: update as_opp_worksheet_lines set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1451: update as_prod_worksheet_lines set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1452: commit;
1453: */
1454:
1455: END AS_INT_TYP_COD_MIGRATION;