INSERT INTO ITM2MENU 
(APPLICATION,LEVEL_1,LEVEL_2,LEVEL_3,LEVEL_4,LEVEL_5,WIN_NAME,DESCR,COMMENTS,MENU_PATH,ICON_PATH,CHG_USER,CHG_TERM,CHG_DATE,OBJ_TYPE) 
VALUES ('WMS',1,61,0,0,0,'w_invholdrelgen_quality','InvHoldRelGen For Quality','InvHoldRelGen For Quality','WMS.1.61.0.0.0',null,'mahendra','mahendra',SYSDATE,'P');

INSERT INTO ITM2MENU 
(APPLICATION,LEVEL_1,LEVEL_2,LEVEL_3,LEVEL_4,LEVEL_5,WIN_NAME,DESCR,COMMENTS,MENU_PATH,ICON_PATH,CHG_USER,CHG_TERM,CHG_DATE,OBJ_TYPE) 
VALUES ('WMS',1,62,0,0,0,'w_invholdrelgen_adm','InvHoldRelGen For Administrative','InvHoldRelGen For Administrative','WMS.1.62.0.0.0',null,'mahendra','mahendra',SYSDATE,'P');


INSERT INTO obj_forms(WIN_NAME,TITLE,OBJ_BROW_NAME,OBJ_EDIT_NAME,FORM_NO,DEFAULT_VIEW)
VALUES ('w_invholdrelgen_quality','Header',null,null,'1','A');

INSERT INTO obj_forms(WIN_NAME,TITLE,OBJ_BROW_NAME,OBJ_EDIT_NAME,FORM_NO,DEFAULT_VIEW)
VALUES ('w_invholdrelgen_quality','Data',null,null,'2','A');


INSERT INTO obj_forms(WIN_NAME,TITLE,OBJ_BROW_NAME,OBJ_EDIT_NAME,FORM_NO,DEFAULT_VIEW)
VALUES ('w_invholdrelgen_adm','Header',null,null,'1','A');

INSERT INTO obj_forms(WIN_NAME,TITLE,OBJ_BROW_NAME,OBJ_EDIT_NAME,FORM_NO,DEFAULT_VIEW)
VALUES ('w_invholdrelgen_adm','Data',null,null,'2','A');

INSERT INTO OBJ_ACTIONS (OBJ_NAME,LINE_NO,RIGHTS_CHAR,INTERACTIVE,SERVICE_CODE,DESCRIPTION,TITLE,IMAGE,FORM_NO,ACTION_TYPE,SERVICE_HANDLER)
VALUES ('invholdrelgen_quality',9,'R','a','get_data','Action Button for getting data','GetData',null,'2','U','3');

INSERT INTO OBJ_ACTIONS (OBJ_NAME,LINE_NO,RIGHTS_CHAR,INTERACTIVE,SERVICE_CODE,DESCRIPTION,TITLE,IMAGE,FORM_NO,ACTION_TYPE,SERVICE_HANDLER)
VALUES ('invholdrelgen_quality',10,'R','a','process','Action Button for processing the data','Process',null,'2','U','3');



INSERT INTO OBJ_ACTIONS (OBJ_NAME,LINE_NO,RIGHTS_CHAR,INTERACTIVE,SERVICE_CODE,DESCRIPTION,TITLE,IMAGE,FORM_NO,ACTION_TYPE,SERVICE_HANDLER)
VALUES ('invholdrelgen_adm',11,'R','a','get_data','Action Button for getting data','GetData',null,'2','U','3');

INSERT INTO OBJ_ACTIONS (OBJ_NAME,LINE_NO,RIGHTS_CHAR,INTERACTIVE,SERVICE_CODE,DESCRIPTION,TITLE,IMAGE,FORM_NO,ACTION_TYPE,SERVICE_HANDLER)
VALUES ('invholdrelgen_adm',12,'R','a','process','Action Button for processing the data','Process',null,'2','U','3');

INSERT INTO obj_itemchange (obj_name,form_no,field_name,mandatory)
VALUES ('invholdrelgen_quality','1','itm_default',null);

INSERT INTO obj_itemchange (obj_name,form_no,field_name,mandatory)
VALUES ('invholdrelgen_adm','1','itm_default',null);

INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_adm','get_data','1','data_invholdrelgen_adm','0',SYSDATE,'mahendra','mahendra','2','EJB','InvHoldRelGen');


INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_adm','post_item_change','1','poic_default_ejb','0',SYSDATE,'mahendra','mahendra','2','EJB','IncHoldRelGenIC');

INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_adm','pre_validate','1','prv_default_ejb','0',SYSDATE,'mahendra','mahendra','2','EJB','IncHoldRelGenIC');

INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_adm','process','1','prc_inv_hold_rel','0',SYSDATE,'mahendra','mahendra','2','EJB','InvHoldRelGen');



INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_quality','get_data','1','data_invholdrelgen_qul','0',SYSDATE,'mahendra','mahendra','2','EJB','InvHoldRelGen');


INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_quality','post_item_change','1','poic_default_ejb','0',SYSDATE,'mahendra','mahendra','2','EJB','IncHoldRelGenIC');

INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_quality','pre_validate','1','prv_default_ejb','0',SYSDATE,'mahendra','mahendra','2','EJB','IncHoldRelGenIC');

INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_quality','process','1','prc_inv_hold_rel','0',SYSDATE,'mahendra','mahendra','2','EJB','InvHoldRelGen');





INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_qul','1','COMPONENT_TYPE','I','Component Type','S',SYSDATE,'mahendra','BASE','EJB');


INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_qul','2','COMPONENT_NAME','I','Component Name','S',SYSDATE,'mahendra','BASE','TaxFormRecoMulti');


INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_qul','3','XML_DATA','I','XML data of form no 1','S',SYSDATE,'mahendra','BASE',null);


INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_qul','4','XML_DATA_1','I','XML data of form no All','S',SYSDATE,'mahendra','BASE',null);

INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_qul','5','WINDOW_NAME','I','Window Name','S',SYSDATE,'mahendra','BASE','w_invholdrelgen_quality');

INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_qul','6','XTRA_PARAMS','I','Extra Arguments','S',SYSDATE,'mahendra','BASE',null);


/*******/

INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_adm','1','COMPONENT_TYPE','I','Component Type','S',SYSDATE,'mahendra','BASE','EJB');


INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_adm','2','COMPONENT_NAME','I','Component Name','S',SYSDATE,'mahendra','BASE','TaxFormRecoMulti');


INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_adm','3','XML_DATA','I','XML data of form no 1','S',SYSDATE,'mahendra','BASE',null);


INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_adm','4','XML_DATA_1','I','XML data of form no All','S',SYSDATE,'mahendra','BASE',null);

INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_adm','5','WINDOW_NAME','I','Window Name','S',SYSDATE,'mahendra','BASE','w_invholdrelgen_adm');

INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_adm','6','XTRA_PARAMS','I','Extra Arguments','S',SYSDATE,'mahendra','BASE',null);


INSERT INTO system_event_services (service_code,service_descr ,service_uri ,service_provider ,method_name ,return_value ,return_type ,return_descr ,return_xfrm ,chg_date ,chg_user ,chg_term)
VALUES('data_invholdrelgen_adm','Action To get the Data','http://localhost/axis/services/ProcessService','BASE','getData','String','S',NULL,NULL,TO_TIMESTAMP('28-05-2014 00:00:00','DD-MM-YYYY HH24:MI:SS'),'mahendra','User');


INSERT INTO system_event_services (service_code,service_descr ,service_uri ,service_provider ,method_name ,return_value ,return_type ,return_descr ,return_xfrm ,chg_date ,chg_user ,chg_term)
VALUES('data_invholdrelgen_qul','Action To get the Data','http://localhost/axis/services/ProcessService','BASE','getData','String','S',NULL,NULL,TO_TIMESTAMP('28-05-2014 00:00:00','DD-MM-YYYY HH24:MI:SS'),'mahendra','User');


INSERT INTO pophelp (FIELD_NAME,MOD_NAME,SQL_STR,MSG_TITLE,WIDTH,HEIGHT,CHG_DATE,CHG_USER,CHG_TERM) 
VALUES ('TRAN_ID__FROM','W_INVHOLDRELGEN_ADM','select ihold.tran_id, ihold.lock_code, ilock.descr from inv_hold ihold ,inv_lock ilock, inv_hold_det ihdet where ihold.lock_code = ilock.lock_code and ihold.tran_id = ihdet.tran_id and ihold.confirmed = ''Y'' and ihdet.HOLD_STATUS <> ''R'' and ihold.lock_code = ilock.lock_code order by ihold.tran_id ', null, 0, 0, SYSDATE, 'mahendra', 'BASE');


INSERT INTO pophelp (FIELD_NAME,MOD_NAME,SQL_STR,MSG_TITLE,WIDTH,HEIGHT,CHG_DATE,CHG_USER,CHG_TERM) 
VALUES ('TRAN_ID__FROM','W_INVHOLDRELGEN_QUALITY','select ihold.tran_id, ihold.lock_code, ilock.descr from inv_hold ihold ,inv_lock ilock, inv_hold_det ihdet where ihold.lock_code = ilock.lock_code and ihold.tran_id = ihdet.tran_id and ihold.confirmed = ''Y'' and ihdet.HOLD_STATUS <> ''R'' and ihold.lock_code = ilock.lock_code order by ihold.tran_id ', null, 0, 0, SYSDATE, 'mahendra', 'BASE');


INSERT INTO pophelp (FIELD_NAME,MOD_NAME,SQL_STR,MSG_TITLE,WIDTH,HEIGHT,CHG_DATE,CHG_USER,CHG_TERM) 
VALUES ('TRAN_ID__TO','W_INVHOLDRELGEN_ADM','select ihold.tran_id, ihold.lock_code, ilock.descr from inv_hold ihold ,inv_lock ilock, inv_hold_det ihdet where ihold.lock_code = ilock.lock_code and ihold.tran_id = ihdet.tran_id and ihold.confirmed = ''Y'' and ihdet.HOLD_STATUS <> ''R'' and ihold.lock_code = ilock.lock_code order by ihold.tran_id ', null, 0, 0, SYSDATE, 'mahendra', 'BASE');


INSERT INTO pophelp (FIELD_NAME,MOD_NAME,SQL_STR,MSG_TITLE,WIDTH,HEIGHT,CHG_DATE,CHG_USER,CHG_TERM) 
VALUES ('TRAN_ID__TO','W_INVHOLDRELGEN_QUALITY','select ihold.tran_id, ihold.lock_code, ilock.descr from inv_hold ihold ,inv_lock ilock, inv_hold_det ihdet where ihold.lock_code = ilock.lock_code and ihold.tran_id = ihdet.tran_id and ihold.confirmed = ''Y'' and ihdet.HOLD_STATUS <> ''R'' and ihold.lock_code = ilock.lock_code order by ihold.tran_id ', null, 0, 0, SYSDATE, 'mahendra', 'BASE');

INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('INVLKCDTP', 'Invalid Lock Code','Invalid Lock Code,Lock Code Should Not System Managed Lock Type', 'E', 'Y', SYSDATE, 'BASE', 'BASE');




/*--------------------------changes on 15-NOV-2014--------------------------*/

INSERT INTO ITM2MENU 
(APPLICATION,LEVEL_1,LEVEL_2,LEVEL_3,LEVEL_4,LEVEL_5,WIN_NAME,DESCR,COMMENTS,MENU_PATH,ICON_PATH,CHG_USER,CHG_TERM,CHG_DATE,OBJ_TYPE) 
VALUES ('WMS',3,5,0,0,0,'w_invholdrelgen_wh','InvHoldRelGen For Warehouse','InvHoldRelGen For Warehouse','WMS.3.5.0.0.0','e12_logo.gif','System','System',SYSDATE,'P');


INSERT INTO obj_forms(WIN_NAME,TITLE,OBJ_BROW_NAME,OBJ_EDIT_NAME,FORM_NO,DEFAULT_VIEW)
VALUES ('w_invholdrelgen_wh','Header',null,null,'1','A');

INSERT INTO obj_forms(WIN_NAME,TITLE,OBJ_BROW_NAME,OBJ_EDIT_NAME,FORM_NO,DEFAULT_VIEW)
VALUES ('w_invholdrelgen_wh','Data',null,null,'2','A');


INSERT INTO OBJ_ACTIONS (OBJ_NAME,LINE_NO,RIGHTS_CHAR,INTERACTIVE,SERVICE_CODE,DESCRIPTION,TITLE,IMAGE,FORM_NO,ACTION_TYPE,SERVICE_HANDLER)
VALUES ('invholdrelgen_wh',13,'R','a','get_data','Action Button for getting data','GetData',null,'2','U','3');

INSERT INTO OBJ_ACTIONS (OBJ_NAME,LINE_NO,RIGHTS_CHAR,INTERACTIVE,SERVICE_CODE,DESCRIPTION,TITLE,IMAGE,FORM_NO,ACTION_TYPE,SERVICE_HANDLER)
VALUES ('invholdrelgen_wh',14,'R','a','process','Action Button for processing the data','Process',null,'2','U','3');


INSERT INTO obj_itemchange (obj_name,form_no,field_name,mandatory)
VALUES ('invholdrelgen_wh','1','itm_default',null);



INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_wh','get_data','1','data_invholdrelgen_wh','0',SYSDATE,'mahendra','mahendra','2','EJB','InvHoldRelGen');

INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_wh','post_item_change','1','poic_default_ejb','0',SYSDATE,'mahendra','mahendra','2','EJB','IncHoldRelGenIC');

INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_wh','pre_validate','1','prv_default_ejb','0',SYSDATE,'mahendra','mahendra','2','EJB','IncHoldRelGenIC');

INSERT INTO system_events(OBJ_NAME,EVENT_CODE,EVENT_CONTEXT,SERVICE_CODE,OVERWRITE_CORE,CHG_DATE,CHG_USER,CHG_TERM,RESULT_HANDLE,COMP_TYPE,COMP_NAME)
VALUES ('invholdrelgen_wh','process','1','prc_inv_hold_rel','0',SYSDATE,'mahendra','mahendra','2','EJB','InvHoldRelGen');





INSERT INTO system_event_services (service_code,service_descr ,service_uri ,service_provider ,method_name ,return_value ,return_type ,return_descr ,return_xfrm ,chg_date ,chg_user ,chg_term)
VALUES('data_invholdrelgen_wh','Action To get the Data','http://localhost/axis/services/ProcessService','BASE','getData','String','S',NULL,NULL,TO_TIMESTAMP('28-05-2014 00:00:00','DD-MM-YYYY HH24:MI:SS'),'Base','User');



INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_wh','1','COMPONENT_TYPE','I','Component Type','S',SYSDATE,'mahendra','BASE','EJB');


INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_wh','2','COMPONENT_NAME','I','Component Name','S',SYSDATE,'mahendra','BASE','TaxFormRecoMulti');


INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_wh','3','XML_DATA','I','XML data of form no 1','S',SYSDATE,'mahendra','BASE',null);


INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_wh','4','XML_DATA_1','I','XML data of form no All','S',SYSDATE,'mahendra','BASE',null);

INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_wh','5','WINDOW_NAME','I','Window Name','S',SYSDATE,'mahendra','BASE','w_invholdrelgen_wh');

INSERT INTO system_service_args(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES('data_invholdrelgen_wh','6','XTRA_PARAMS','I','Extra Arguments','S',SYSDATE,'mahendra','BASE',null);




INSERT INTO pophelp (FIELD_NAME,MOD_NAME,SQL_STR,MSG_TITLE,WIDTH,HEIGHT,CHG_DATE,CHG_USER,CHG_TERM) 
VALUES ('TRAN_ID__FROM','W_INVHOLDRELGEN_WH','select ihold.tran_id, ihold.lock_code, ilock.descr from inv_hold ihold ,inv_lock ilock, inv_hold_det ihdet where ihold.lock_code = ilock.lock_code and ihold.tran_id = ihdet.tran_id and ihold.confirmed = ''Y'' and ihdet.HOLD_STATUS <> ''R'' and ihold.lock_code = ilock.lock_code order by ihold.tran_id ', null, 0, 0, SYSDATE, 'mahendra', 'BASE');


INSERT INTO pophelp (FIELD_NAME,MOD_NAME,SQL_STR,MSG_TITLE,WIDTH,HEIGHT,CHG_DATE,CHG_USER,CHG_TERM) 
VALUES ('TRAN_ID__TO','W_INVHOLDRELGEN_WH','select ihold.tran_id, ihold.lock_code, ilock.descr from inv_hold ihold ,inv_lock ilock, inv_hold_det ihdet where ihold.lock_code = ilock.lock_code and ihold.tran_id = ihdet.tran_id and ihold.confirmed = ''Y'' and ihdet.HOLD_STATUS <> ''R'' and ihold.lock_code = ilock.lock_code order by ihold.tran_id ', null, 0, 0, SYSDATE, 'mahendra', 'BASE');



INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMEMTLTNO', 'Empty Lot No','Empty Lot No,Please enter Lot No for lot level lock code', 'E', 'Y', SYSDATE, 'BASE', 'BASE');


/*-----------------changes done by mahendra dated 18-11-2014----------------------------------*/



INSERT INTO MESSAGES (msg_no , msg_str , msg_descr , msg_type , msg_opt , chg_date , chg_user , chg_term )
VALUES ('VMINVLCCD', 'Loc Code should be empty','Loc Code should be empty in Item/Lot level lock', '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 ('VMINVLTNO', 'Lot No should be empty','Lot No should be empty in Item level lock', '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 ('VMINVLTSL', 'LPN NO should be empty','LPN NO should be empty in Item/Lot level lock', 'E', 'Y', SYSDATE, 'BASE', 'BASE');

DELETE FROM ITM2MENU WHERE WIN_NAME IN ('w_invholdrelgen_quality','w_invholdrelgen_adm','w_invholdrelgen_wh');

COMMIT;


INSERT INTO ITM2MENU VALUES (
	'WMS',
	8,
	12,
	0,
	0,
	0,
	'w_invholdrelgen_quality',
	'Inventory Hold Release Proces - Quality',
	'Inventory Hold Release Proces - Quality',
	'WMS.8.12.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'P',
	TO_DATE('15-11-2014 12:07:44','DD-MM-YYYY HH24:MI:SS'),
	'mahendra       ',
	'mahendra  ',
	NULL);
INSERT INTO ITM2MENU VALUES (
	'WMS',
	8,
	13,
	0,
	0,
	0,
	'w_invholdrelgen_adm',
	'Inventory Hold Release Proces - Admin',
	'Inventory Hold Release Proces - Admin',
	'WMS.8.13.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'P',
	TO_DATE('15-11-2014 12:07:52','DD-MM-YYYY HH24:MI:SS'),
	'mahendra       ',
	'mahendra  ',
	NULL);
INSERT INTO ITM2MENU VALUES (
	'WMS',
	8,
	14,
	0,
	0,
	0,
	'w_invholdrelgen_wh',
	'Inventory Hold Release Process - WH',
	'Inventory Hold Release Process - WH',
	'WMS.8.14.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'P',
	TO_DATE('18-11-2014 12:04:23','DD-MM-YYYY HH24:MI:SS'),
	'System         ',
	'System    ',
	NULL);




























