spool C:\wms_log\WM1HSUN007.txt

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 )
VALUES (
	'SFA',
	1,
	30,
	0,
	0,
	0,
	'w_master_pick',
	'Master Picking',
	'Master Picking',
	'SFA.1.30.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'W',
	fn_sysdate(),
	'BASE141',
	'Gulzar');
INSERT INTO transetup (
	tran_window ,
	save_flag ,
	val_flag ,
	key_flag ,
	key_string,
	repeate_add ,
	chg_date ,
	chg_user ,
	chg_term ,
	edi_option ,
	confirm_mode ,
	mail_option ,
	garbage_opt ,
	table_name,
	application,
	ref_ser,
	tran_id_col,
	confirm_col,
	confirm_val)
VALUES (
	'w_master_pick',
	'2',
	'2',
	'A',
	'MP,seq08',
	'N',
	fn_sysdate(),
	'Gulzar',
	'BASE ',
	'0',
	'0',
	'0',
	'N',
	'pick_iss_hdr',
	'WMS',
	'M-PICK',
	'TRAN_ID',
	'',
	'');
INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	chg_date ,
	chg_term ,
	chg_user)
VALUES (
	'master_pick',
	 1,
	'S',
	'',
	'',
	'Saving',
	'Finish',
	'',
	'U',
	'3',
	fn_sysdate(),
	'BASE ',
	'Gulzar');
INSERT INTO obj_forms  (
	win_name ,
	title ,
	obj_brow_name ,
	obj_edit_name ,
	cross_update_expr ,
	expr_fld_info ,
	target_fld_info,
	expr_comment ,
	form_no ,
	scr_flag ,
	scan_flag ,
	scan_metadata ,
	auto_accept_scan ,
	property_info ,
	ext_com ,
	ext_metadata ,
	ext_setup ,
	after_save ,
	column_on_save ,
	scan_delimiter ,
	auto_accept_weighdata ,
	form_type ,
	disp_metadata ,
	parent_key_col,
	assisted_mode)
VALUES (
	'w_master_pick',
	'Master Picking Task',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	'F',
	NULL,
	'<SCAN_INFO><INPUT_SCAN ORDER="1"><SCAN_LABEL>Pick Order:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>pick_order</FIELD></FIELDS></INPUT_SCAN></SCAN_INFO>',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'E');
INSERT INTO obj_forms  (
	win_name ,
	title ,
	obj_brow_name ,
	obj_edit_name ,
	cross_update_expr ,
	expr_fld_info ,
	target_fld_info,
	expr_comment ,
	form_no ,
	scr_flag ,
	scan_flag ,
	scan_metadata ,
	auto_accept_scan ,
	property_info ,
	ext_com ,
	ext_metadata ,
	ext_setup ,
	after_save ,
	column_on_save ,
	scan_delimiter ,
	auto_accept_weighdata ,
	form_type ,
	disp_metadata ,
	parent_key_col)
VALUES (
	'w_master_pick',
	'Header',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'2',
	'F',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
INSERT INTO obj_forms (
	win_name ,
	title ,
	obj_brow_name ,
	obj_edit_name ,
	cross_update_expr ,
	expr_fld_info ,
	target_fld_info,
	expr_comment ,
	form_no ,
	scr_flag ,
	scan_flag ,
	scan_metadata ,
	auto_accept_scan ,
	property_info ,
	ext_com ,
	ext_metadata ,
	ext_setup ,
	after_save ,
	column_on_save ,
	scan_delimiter ,
	auto_accept_weighdata ,
	form_type ,
	disp_metadata ,
	parent_key_col,
	assisted_mode)
VALUES (
	'w_master_pick',
	'Detail',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'3',
	'T',
	NULL,
	'<SCAN_INFO><MAPPING_SCAN ORDER="1"><SCAN_LABEL>Lot No:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>lot_no</FIELD></FIELDS></MAPPING_SCAN><MAPPING_SCAN ORDER="2"><SCAN_LABEL>LPN No:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>lot_sl</FIELD></FIELDS></MAPPING_SCAN><INPUT_SCAN ORDER="1"><SCAN_LABEL>Case Label:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>case_label</FIELD></FIELDS></INPUT_SCAN><INPUT_SCAN ORDER="2"><SCAN_LABEL>Loc Code To:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>loc_code__to</FIELD></FIELDS></INPUT_SCAN><INPUT_SCAN ORDER="3"><SCAN_LABEL>Carton No:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>carton_no</FIELD></FIELDS></INPUT_SCAN></SCAN_INFO>',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'<item_descr>(<item_code>), <lot_no>, <lot_sl>, <quantity> <unit>=<loc_code__to>, <case_label>, <carton_no>',
	NULL,
	'E');
INSERT INTO system_events (
	obj_name ,
	event_code ,
	event_context,
	service_code ,
	chg_date ,
	chg_user ,
	chg_term ,
	result_handle ,
	overwrite_core ,
	comp_type ,
	comp_name)
VALUES (
	'master_pick',
	'pre_validate',
	'1',
	'prv_pick_iss',
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'2',
	'0',
	'EJB',
	'PickIssIC');
INSERT INTO system_events (
	obj_name ,
	event_code ,
	event_context,
	service_code ,
	chg_date ,
	chg_user ,
	chg_term ,
	result_handle ,
	overwrite_core ,
	comp_type ,
	comp_name)
VALUES (
	'master_pick',
	'pre_navigate',
	'1',
	'prv_pick_iss',
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'2',
	'0',
	'EJB',
	'PickIssIC');
INSERT INTO system_events (
	obj_name ,
	event_code ,
	event_context,
	service_code ,
	chg_date ,
	chg_user ,
	chg_term ,
	result_handle ,
	overwrite_core ,
	comp_type ,
	comp_name)
VALUES (
	'master_pick',
	'default_data_wiz',
	'1',
	'pick_iss_default_data',
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'2',
	'0',
	'EJB',
	'PickIssIC');
INSERT INTO system_events (
	obj_name ,
	event_code ,
	event_context ,
	service_code ,
	method_rule ,
	chg_date ,
	chg_user ,
	chg_term ,
	result_handle ,
	overwrite_core ,
	comp_type ,
	comp_name ,
	comm_format )
VALUES (
	'master_pick',
	'pre_save',
	'1',
	'prsr_pick_iss',
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'2',
	'0',
	'EJB',
	'PickIssPrs',
	NULL);
INSERT INTO system_events (
	obj_name ,
	event_code ,
	event_context,
	service_code ,
	chg_date ,
	chg_user ,
	chg_term ,
	result_handle ,
	overwrite_core ,
	comp_type ,
	comp_name)
VALUES (
	'master_pick',
	'post_save',
	'1',
	'pos_pick_iss',
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'2',
	'0',
	'EJB',
	'PickIssPos');

INSERT INTO MESSAGES (
	msg_no,
	msg_str,
	msg_descr,
	msg_type,
	msg_opt,
	msg_time,
	alarm,
	err_source,
	chg_date,
	chg_user,
	chg_term,
	override_input,
	mail_option)
VALUES (
	'DUPCASELBL',
	'Case label already assigned',
	'Case label entered or scanned is already asigned .',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE92',
	NULL,
	NULL);

alter table pick_ord_det
add lot_sl__new char(15);

alter table repl_iss_det
add lot_sl__new char(15);

insert into messages(
MSG_NO,         
MSG_STR ,       
MSG_DESCR,      
MSG_TYPE,
MSG_OPT,
chg_date,
chg_user,
chg_term
)
values(
'LPNORDTYPE',
'Invalid New LPN NO',
' New LPN NO it can not be plan',
'E',
'Y',
sysdate,
'base',
'base'
);