Insert into itm2menu(APPLICATION,LEVEL_1,LEVEL_2,LEVEL_3,LEVEL_4,LEVEL_5,WIN_NAME,DESCR,COMMENTS,MENU_PATH,ICON_PATH,CLOSE_ICON,OPEN_ICON,OBJ_TYPE,CHG_DATE,CHG_TERM,CHG_USER,MOB_DEPLOY) 
values ('MRP',1,3,0,0,0,'/ibase/webitm/jsp/SelectMRPWiz.jsp','Select MRP Wizard',' Select MRP Wizard','MRP.1.3.0.0.0',null,null,null,'I',null,null,null,null);

Insert into system_events (OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,METHOD_RULE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME,COMM_FORMAT) 
values ('requirement','pre_validate','1','prv_requirement',null,'0',sysdate,'base','base','2','EJB','RequirementIC',null);


update SYSTEM_EVENTS set EVENT_CODE='pre_navigate' WHERE OBJ_NAME='requirement' and EVENT_CODE='pre_navigate_next' ;

Insert into itm2menu(APPLICATION,LEVEL_1,LEVEL_2,LEVEL_3,LEVEL_4,LEVEL_5,WIN_NAME,DESCR,COMMENTS,MENU_PATH,ICON_PATH,CLOSE_ICON,OPEN_ICON,OBJ_TYPE,CHG_DATE,CHG_TERM,CHG_USER,MOB_DEPLOY) values ('MRP',1,2,0,0,0,'/ibase/webitm/jsp/E12WizardPage.jsp?OBJ_NAME=requirement&amp;FORM_NO=1','Material Requirement','Material Requirement','MRP.1.2.0.0.0',null,null,null,'I',null,null,null,'Y');

Insert into USER_OBJ_FAV (OBJ_NAME,USER_ID,CHG_DATE,CHG_USER,CHG_TERM) 
values ('requirement','BASE',SYSDATE,'BASE','BASE');
UPDATE USER_RIGHTS SET FAV_OPTION = 'Y' where  OBJ_NAME='requirement' AND PROFILE_ID='SUN';


INSERT INTO MESSAGES (msg_no , msg_str , msg_descr ,  msg_type ,  msg_opt , chg_date , chg_user , chg_term  )
VALUES ('VMSITE11', 'Site Code From is blank!',  'Site code From can not be blank, please enter valid site code',   'E',   'Y',  SYSDATE,  'BASE ', 'BASE ');

INSERT INTO MESSAGES (msg_no , msg_str , msg_descr ,  msg_type ,  msg_opt , chg_date , chg_user , chg_term  )
VALUES ('VMSITE12', 'Site Code To is blank!',  'Site code To can not be blank, please enter valid site code',   'E',   'Y',  SYSDATE,  'BASE ', 'BASE ');
