
ALTER TABLE INV_HOLD ADD LOCK_CODE CHAR(10);
ALTER TABLE INV_HOLD ADD REF_ID CHAR(10);
ALTER TABLE INV_HOLD ADD REF_SER VARCHAR2(6);

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,
	3,
	0,
	0,
	0,
	'w_inv_hold',
	'Inventory Hold',
	'Detail',
	'SFA.1.3.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'T',
	fn_sysdate(),
	'BASE',
	'Dharmesh');
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,
	4,
	0,
	0,
	0,
	'w_inv_hold_rel',
	'Inventory Release',
	'Detail',
	'SFA.1.4.0.0.0',
	'e12_logo.gif',
	NULL,
	NULL,
	'T',
	fn_sysdate(),
	'BASE',
	'Dharmesh');
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_inv_hold',
	'2',
	'2',
	'A',
	'seq10',
	'N',
	fn_sysdate(),
	'Gulzar',
	'BASE ',
	'0',
	'0',
	'0',
	'N',
	'INV_HOLD',
	'DIS',
	'INVHOL',
	'TRAN_ID',
	'confirmed',
	'Y');
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_inv_hold',
	'2',
	'2',
	'A',
	'seq10',
	'N',
	fn_sysdate(),
	'Gulzar',
	'BASE ',
	'0',
	'0',
	'0',
	'N',
	'INV_HOLD',
	'DIS',
	'INVREL',
	'TRAN_ID',
	'CONFIRMED',
	'Y');
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 ,
	auto_accept_scan ,
	scan_metadata ,
	scan_flag ,
	scr_flag ,
	property_info ,
	ext_com ,
	ext_metadata ,
	ext_setup ,
	after_save ,
	column_on_save ,
	scan_delimiter ,
	auto_accept_weighdata ,
	rate_col ,
	qty_col ,
	form_type ,
	disp_metadata ,
	parent_key_col )
VALUES (
	'w_inv_hold',
	'Inventory Hold',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	NULL,
	NULL,
	NULL,
	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 ,
	auto_accept_scan ,
	scan_metadata ,
	scan_flag ,
	scr_flag ,
	property_info ,
	ext_com ,
	ext_metadata ,
	ext_setup ,
	after_save ,
	column_on_save ,
	scan_delimiter ,
	auto_accept_weighdata ,
	rate_col ,
	qty_col ,
	form_type ,
	disp_metadata ,
	parent_key_col )
VALUES (
	'w_inv_hold',
	'Detail',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'2',
	NULL,
	NULL,
	NULL,
	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 ,
	auto_accept_scan ,
	scan_metadata ,
	scan_flag ,
	scr_flag ,
	property_info ,
	ext_com ,
	ext_metadata ,
	ext_setup ,
	after_save ,
	column_on_save ,
	scan_delimiter ,
	auto_accept_weighdata ,
	rate_col ,
	qty_col ,
	form_type ,
	disp_metadata ,
	parent_key_col )
VALUES (
	'w_inv_hold_rel',
	'Inventory Release',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'1',
	NULL,
	NULL,
	NULL,
	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 ,
	auto_accept_scan ,
	scan_metadata ,
	scan_flag ,
	scr_flag ,
	property_info ,
	ext_com ,
	ext_metadata ,
	ext_setup ,
	after_save ,
	column_on_save ,
	scan_delimiter ,
	auto_accept_weighdata ,
	rate_col ,
	qty_col ,
	form_type ,
	disp_metadata ,
	parent_key_col )
VALUES (
	'w_inv_hold_rel',
	'Detail',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	'2',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	service_handler ,
	placement ,
	tran_type ,
	chg_date ,
	chg_term ,
	chg_user )
VALUES (
	'inv_hold_rel',
	1,
	'A',
	'a',
	'a',
	'Adding New',
	'Add',
	'add.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	service_handler ,
	placement ,
	tran_type ,
	chg_date ,
	chg_term ,
	chg_user )
VALUES (
	'inv_hold_rel',
	2,
	'E',
	'a',
	'a',
	'Editing Existing Record',
	'Edit',
	'edit.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	service_handler ,
	placement ,
	tran_type ,
	chg_date ,
	chg_term ,
	chg_user )
VALUES (
	'inv_hold_rel',
	3,
	'D',
	'a',
	'a',
	'Deleting',
	'Delete',
	'delete.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	service_handler ,
	placement ,
	tran_type ,
	chg_date ,
	chg_term ,
	chg_user )
VALUES (
	'inv_hold_rel',
	9,
	'R',
	'a',
	'pre_confirm',
	'Inventory Hold Confirmation',
	'Confirm',
	NULL,
	'U',
	'1',
	'2',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);

INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	service_handler ,
	placement ,
	tran_type ,
	chg_date ,
	chg_term ,
	chg_user )
VALUES (
	'inv_hold',
	1,
	'A',
	'a',
	'a',
	'Adding New',
	'Add',
	'add.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	service_handler ,
	placement ,
	tran_type ,
	chg_date ,
	chg_term ,
	chg_user )
VALUES (
	'inv_hold',
	2,
	'E',
	'a',
	'a',
	'Editing Existing Record',
	'Edit',
	'edit.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	service_handler ,
	placement ,
	tran_type ,
	chg_date ,
	chg_term ,
	chg_user )
VALUES (
	'inv_hold',
	3,
	'D',
	'a',
	'a',
	'Deleting',
	'Delete',
	'delete.gif',
	'S',
	'1',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
INSERT INTO obj_actions (
	obj_name ,
	line_no ,
	rights_char ,
	interactive ,
	service_code ,
	description ,
	title ,
	image ,
	action_type ,
	form_no ,
	service_handler ,
	placement ,
	tran_type ,
	chg_date ,
	chg_term ,
	chg_user )
VALUES (
	'inv_hold',
	9,
	'R',
	'a',
	'pre_confirm',
	'Inventory Hold Confirmation',
	'Confirm',
	NULL,
	'U',
	'1',
	'2',
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold',
	'1',
	'site_code',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold',
	'1',
	'emp_code__aprv',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold',
	'1',
	'itm_default',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold',
	'1',
	'role_code',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold',
	'1',
	'lock_code',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold',
	'2',
	'item_code',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold',
	'2',
	'itm_default',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold',
	'2',
	'loc_code',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold',
	'2',
	'site_code',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold_rel',
	'1',
	'site_code',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold_rel',
	'1',
	'itm_default',
	NULL);
INSERT INTO obj_itemchange (
	obj_name ,
	form_no ,
	field_name ,
	mandatory )
values (
	'inv_hold_rel',
	'1',
	'emp_code__aprv',
	NULL);
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 (
	'inv_hold_rel',
	'post_item_change',
	'1',
	'poic_inv_hold_rel',
	NULL,
	fn_sysdate(),
	'BASE',
	'SYSTEM',
	'2',
	'0',
	'EJB',
	'InvHoldRelIC',
	NULL);
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 (
	'inv_hold_rel',
	'pre_confirm',
	'1',
	'prcm_inv_hold_rel',
	NULL,
	fn_sysdate(),
	'Gulzar',
	'Gulzar',
	'2',
	'0',
	'EJB',
	'InvHoldRelConf',
	NULL);
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 (
	'inv_hold_rel',
	'pre_validate',
	'1',
	'prv_inv_hold_rel',
	NULL,
	fn_sysdate(),
	'BASE',
	'Base92',
	'2',
	'0',
	'EJB',
	'InvHoldRelIC',
	NULL);
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 (
	'inv_hold',
	'post_item_change',
	'1',
	'poic_inv_hold',
	NULL,
	fn_sysdate(),
	'BASE',
	'SYSTEM',
	'2',
	'0',
	'EJB',
	'InvHoldIC',
	NULL);
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 (
	'inv_hold',
	'pre_confirm',
	'1',
	'prcm_inv_hold',
	NULL,
	fn_sysdate(),
	'chaitali',
	'chaitali',
	'2',
	'0',
	'EJB',
	'InvHoldConf',
	NULL);
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 (
	'inv_hold',
	'pre_validate',
	'1',
	'prv_inv_hold',
	NULL,
	fn_sysdate(),
	'BASE',
	'Base92',
	'2',
	'0',
	'EJB',
	'InvHoldIC',
	NULL);
INSERT INTO system_event_services (
	service_code ,
	service_uri ,
	method_name ,
	chg_date ,
	chg_user ,
	chg_term )
VALUES (
	'poic_inv_hold',
	'http://localhost:9090/axis/services/ValidatorService',
	'itemChanged',
	fn_sysdate(),
	'BASE',
	'BASE');
INSERT INTO system_event_services (
	service_code ,
	service_uri ,
	method_name ,
	chg_date ,
	chg_user ,
	chg_term )
VALUES (
	'poic_inv_hold_rel',
	'http://localhost:9090/axis/services/ValidatorService',
	'itemChanged',
	fn_sysdate(),
	'Gulzar',
	'BASE');
INSERT INTO system_event_services (
	service_code ,
	service_uri ,
	method_name ,
	chg_date ,
	chg_user ,
	chg_term )
VALUES (
	'prcm_inv_hold',
	'http://localhost:9090/axis/services/ActionHandlerService',
	'confirm',
	fn_sysdate(),
	'chaitali',
	'chaitali');
INSERT INTO system_event_services (
	service_code ,
	service_uri ,
	method_name ,
	chg_date ,
	chg_user ,
	chg_term )
VALUES (
	'prcm_inv_hold_rel',
	'http://localhost:9090/axis/services/ActionHandlerService',
	'confirm',
	fn_sysdate(),
	'Gulzar',
	'Gulzar');
INSERT INTO system_event_services (
	service_code ,
	service_uri ,
	method_name ,
	chg_date ,
	chg_user ,
	chg_term )
VALUES (
	'prv_inv_hold',
	'http://localhost:9090/axis/services/ValidatorService',
	'wfValData',
	fn_sysdate(),
	'BASE',
	'BASE');
INSERT INTO system_event_services (
	service_code ,
	service_uri ,
	method_name ,
	chg_date ,
	chg_user ,
	chg_term )
VALUES (
	'prv_inv_hold_rel',
	'http://localhost:9090/axis/services/ValidatorService',
	'wfValData',
	fn_sysdate(),
	'Gulzar',
	'BASE');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	'EJB');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	'InvHoldIC');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold',
	3,
	'XML_DATA',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold',
	5,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold',
	7,
	'FOCUSED_COLUMN',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold',
	8,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold',
	9,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold_rel',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	'EJB');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold_rel',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	'InvHoldRelIC');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold_rel',
	3,
	'XML_DATA',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold_rel',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold_rel',
	5,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold_rel',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold_rel',
	7,
	'FOCUSED_COLUMN',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold_rel',
	8,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'poic_inv_hold_rel',
	9,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold',
	1,
	'COMPONENT_TYPE',
	'I',
	'COMPONENT_TYPE',
	'C.String',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	'EJB');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold',
	2,
	'COMPONENT_NAME',
	'I',
	'COMPONENT_NAME',
	'C.String',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	'InvHoldConf');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold',
	3,
	'<tran_id>',
	'I',
	'Tran id of inv hold',
	'C.String',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold',
	4,
	'XTRA_PARAMS',
	'I',
	'XTRA_PARAMS',
	'S',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold',
	5,
	'FORCED_FLAG',
	'I',
	'FORCED_FLAG',
	'S',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold_rel',
	1,
	'COMPONENT_TYPE',
	'I',
	'COMPONENT_TYPE',
	'C.String',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	'EJB');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold_rel',
	2,
	'COMPONENT_NAME',
	'I',
	'COMPONENT_NAME',
	'C.String',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	'InvHoldRelConf');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold_rel',
	3,
	'<tran_id>',
	'I',
	'Tran id of inv hold',
	'C.String',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold_rel',
	4,
	'XTRA_PARAMS',
	'I',
	'XTRA_PARAMS',
	'S',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prcm_inv_hold_rel',
	5,
	'FORCED_FLAG',
	'I',
	'FORCED_FLAG',
	'S',
	NULL,
	fn_sysdate(),
	'BASE',
	'BASE',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	'EJB');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	'InvHoldIC');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold',
	3,
	'XML_DATA',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold',
	5,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold',
	7,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold',
	8,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold_rel',
	1,
	'COMPONENT_TYPE',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	'EJB');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold_rel',
	2,
	'COMPONENT_NAME',
	'I',
	NULL,
	'C.String',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	'InvHoldRelIC');
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold_rel',
	3,
	'XML_DATA',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold_rel',
	4,
	'XML_DATA_1',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold_rel',
	5,
	'XML_DATA_ALL',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold_rel',
	6,
	'OBJ_CONTEXT',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold_rel',
	7,
	'EDIT_FLAG',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
INSERT INTO system_service_args (
	service_code ,
	line_no ,
	arg_name ,
	arg_mode ,
	descr ,
	arg_type ,
	arg_xfrm ,
	chg_date ,
	chg_user ,
	chg_term ,
	arg_value )
values (
	'prv_inv_hold_rel',
	8,
	'XTRA_PARAMS',
	'I',
	NULL,
	'S',
	NULL,
	fn_sysdate(),
	'Base',
	'System',
	NULL);
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 (
	'NULLLOCKCD',
	'Lock Code is blank!',
	'Lock code can not be blank, please enter valid lock code',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	NULL,
	NULL);
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 (
	'NULLSITECD',
	'Site Code is blank!',
	'Site code can not be blank, please enter valid site code',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	NULL,
	NULL);
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 (
	'INVLOCKCD',
	'Lock Code does not exist!',
	'Lock code entered does not exist, please enter valid lock code',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	NULL,
	NULL);
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 (
	'NULLLOCCD',
	'Location Code is blank!',
	'Location code can not be blank, please enter valid location code',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	NULL,
	NULL);
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 (
	'NULLLOTNO',
	'Lot No is blank!',
	'Lot no can not be blank, please enter valid lot no',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	NULL,
	NULL);
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 (
	'NULLLOTSL',
	'Lot serial is blank!',
	'Lot serial can not be blank, please enter valid Lot serial',
	'E',
	'Y',
	NULL,
	NULL,
	NULL,
	fn_sysdate(),
	'Gulzar',
	'BASE207',
	NULL,
	NULL);

INSERT INTO pophelp (
	field_name ,
	mod_name ,
	sql_str ,
	dw_object ,	
	width ,
	height ,
	chg_date,
	chg_user ,
	chg_term ,
	dist_opt) 	
VALUES (
	'TRAN_ID__HOLD',
	'W_INV_HOLD_REL',
	'select ihold.tran_id, ihold.lock_code, ilock.descr from inv_hold ihold ,inv_lock ilock, inv_hold_det ihdet where ihold.lock_code = lock.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 ',
	'inv_hold_rel',
	0,
	0,
	fn_sysdate(),
	'Gulzar',
	'BASE',
	'1');

INSERT INTO OBJ_ACTIONS 
(OBJ_NAME,LINE_NO,RIGHTS_CHAR,INTERACTIVE,SERVICE_CODE,DESCRIPTION,TITLE,
IMAGE,ACTION_TYPE,FORM_NO,SERVICE_HANDLER,PLACEMENT,TRAN_TYPE)
VALUES
('inv_hold_rel','4','R','a','act_impdbs','Import from Database','default','default.gif','U','2','3',null,null);

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 
('inv_hold_rel','act_impdbs','1','imp_from_dbs',null,fn_sysdate(),'Dipak','Dipak','2','0','EJB','HoldRelAct',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
('imp_from_dbs','import from DB','http://localhost:9090/axis/services/ActionHandlerService',
null,'actionHandler','String','S',null,null,to_timestamp('07-NOV-11','DD-MON-RR HH.MI.SSXFF AM'),'Dipak','System');


INSERT INTO SYSTEM_SERVICE_ARGS 
(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES 
('imp_from_dbs',1,'COMPONENT_TYPE','I','Component Type','C.String',null,to_timestamp('07-NOV-11','DD-MON-RR HH.MI.SSXFF AM'),'Dipak','BASE215','EJB');
INSERT INTO SYSTEM_SERVICE_ARGS 
(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES 
('imp_from_dbs',2,'COMPONENT_NAME','I','Component Name','C.String',null,to_timestamp('07-NOV-11','DD-MON-RR HH.MI.SSXFF AM'),'Dipak','BASE215','HoldRelAct');
INSERT INTO SYSTEM_SERVICE_ARGS 
(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES 
('imp_from_dbs',3,'ACTION_TYPE','I','Action Type','C.String',null,to_timestamp('07-NOV-11','DD-MON-RR HH.MI.SSXFF AM'),'Dipak','BASE215','IMP_FROM_DBS');
INSERT INTO SYSTEM_SERVICE_ARGS 
(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES
('imp_from_dbs',4,'XML_DATA_1','I','XML data of form no 1','S',null,to_timestamp('07-NOV-11','DD-MON-RR HH.MI.SSXFF AM'),'Dipak','BASE215',null);
INSERT INTO SYSTEM_SERVICE_ARGS 
(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE) 
VALUES 
('imp_from_dbs',5,'OBJ_CONTEXT','I','Extra Arguments','S',null,to_timestamp('07-NOV-11','DD-MON-RR HH.MI.SSXFF AM'),'Dipak','BASE215',null);
INSERT INTO SYSTEM_SERVICE_ARGS 
(SERVICE_CODE,LINE_NO,ARG_NAME,ARG_MODE,DESCR,ARG_TYPE,ARG_XFRM,CHG_DATE,CHG_USER,CHG_TERM,ARG_VALUE)
VALUES 
('imp_from_dbs',6,'XTRA_PARAMS','l',null,'S',null,to_timestamp('07-NOV-11','DD-MON-RR HH.MI.SSXFF AM'),'Dipak','BASE215',null);


INSERT INTO OBJ_LINKS(obj_name,form_no,field_name,target_obj_name,LINK_FORM_NAME,LINK_TITLE,LINK_URI,LINK_TYPE,LINK_ARG,UPDATE_FLAG,RIGHTS_CHAR,IMAGE,LINK_NAME) 
values ('inv_hold_rel','1','tran_id','inventorydet','inventorydet11','Inventory Detail',null,'1','tran_id.String','1','*',null,null) ;



ALTER TABLE inv_lock ADD std_days number(3);

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 ('VTINQTY09','Invalid Quantity.','Quantity against item code, site code, lot no, lot sl in stock should be greater than zero.','E','Y',null,null,null,sysdate,'BASE','BASE',null,null);

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 ('VMINVITMST','Invalid Item','Stock not found for this Item, Enter valid Item.','E','Y',null,null,null,sysdate,'BASE','BASE',null,null);

