UPDATE OBJ_FORMS SET SCAN_METADATA= '<SCAN_INFO><INPUT_SCAN ORDER="1"><SCAN_LABEL>Location Code To:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>loc_code__to</FIELD></FIELDS></INPUT_SCAN><INPUT_SCAN ORDER="2"><SCAN_LABEL>LPN No :</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>lot_sl__to</FIELD></FIELDS></INPUT_SCAN><INPUT_SCAN ORDER="3"><SCAN_LABEL>Quantity :</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>quantity</FIELD></FIELDS></INPUT_SCAN><SCAN_CONDITION field="lot_sl__to">ispartial.indexOf("Y") != -1</SCAN_CONDITION><SCAN_CONDITION field="quantity">ispartial.indexOf("Y") != -1</SCAN_CONDITION></SCAN_INFO>' WHERE WIN_NAME ='w_stock_transfer_grl' AND FORM_NO = 3;

INSERT INTO DISPARM 
(
	PRD_CODE,                                                                                                                                                                                        
	VAR_NAME,                                                                                                                                                                                     
	VAR_TYPE ,                                                                                                                                                                                        
	VAR_VALUE ,                                                                                                                                                                                
	DESCR ,                                                                                                                                                                                 
	VAR_SUBS,                                                                                                                                                                                     
	CHG_DATE ,                                                                                                                                                                                          
	CHG_USER ,                                                                                                                                                                                      
	CHG_TERM
)
VALUES
(
	'999999',
	'PGRL_INVSTAT',
	'S',
	'PGRL',
	'Partial GRL Location',
	NULL,
	sysdate,
	'BASE',
	'BASE'
);

INSERT INTO DISPARM 
(
	PRD_CODE,                                                                                                                                                                                        
	VAR_NAME,                                                                                                                                                                                     
	VAR_TYPE ,                                                                                                                                                                                        
	VAR_VALUE ,                                                                                                                                                                                
	DESCR ,                                                                                                                                                                                 
	VAR_SUBS,                                                                                                                                                                                     
	CHG_DATE ,                                                                                                                                                                                          
	CHG_USER ,                                                                                                                                                                                      
	CHG_TERM
)
VALUES
(
	'999999',
	'PRSRV_INVSTAT',
	'S',
	'PRSV',
	'Partial Reserve Location',
	NULL,
	sysdate,
	'BASE',
	'BASE'
);

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
(
	'VTLOCCOD11',
	'Invalid Location Code',
	'Entered or scanned location code is not a partial GRL location, please enter or scan valid location',
	'E',
	NULL,
	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
(
	'VTLOCCOD12',
	'Invalid Location Code',
	'Entered or scanned location code is not a partial reserve location, please enter or scan valid location',
	'E',
	NULL,
	NULL,
	NULL,
	NULL,
	sysdate,
	'BASE',
	'BASE',
	NULL,
	NULL
);

INSERT INTO LOCATION
(
	LOC_CODE,                                                                                                                                                                                       
	DESCR,                                                                                                                                                                                  
	SH_DESCR,                                                                                                                                                                                  
	LOC_TYPE,                                                                                                                                                                                   
	INV_STAT,                                                                                                                                                                                       
	ONE_ITEM ,                                                                                                                                                                                       
	CAPACITY ,                                                                                                                                                                                  
	CAP_UOM  ,                                                                                                                                                                                       
	LOC_GROUP ,                                                                                                                                                                                       
	TEMP,                                                                                                                                                                                       
	SITE_CODE,                                                                                                                                                                                       
	SITE_CODE__OWN,                                                                                                                                                                                       
	ITEM_CODE,                                                                                                                                                                                      
	EFF_FROM,                                                                                                                                                                                          
	VALID_UPTO,                                                                                                                                                                                          
	HIRE_CHARGE,                                                                                                                                                                                  
	USABLE,                                                                                                                                                                                       
	CHG_DATE,                                                                                                                                                                                          
	CHG_USER,                                                                                                                                                                                      
	CHG_TERM,                                                                                                                                                                                      
	ZONE,                                                                                                                                                                                   
	PALLET_BASED,                                                                                                                                                                                       
	SINGLE_LOT_SL,                                                                                                                                                                                       
	ITEM_LOT_OPT,                                                                                                                                                                                       
	CYCLE_COUNT_REQD,                                                                                                                                                                                       
	PHY_HAN_BASIS,                                                                                                                                                                                       
	PHY_HAN_UOM,                                                                                                                                                                                       
	DROP_GROUP,                                                                                                                                                                                       
	LOC_ZONE
)
VALUES 
(
	'PGRL',
	'Partial General Receipt',
	'PART GENERAL RECEIPT',
	'C',
	'PGRL',
	'Y',
	999999999,
	NULL,
	'S',
	'N',
	'TA821',
	NULL,
	NULL,
	TO_TIMESTAMP('31-05-2012 00:00:00','DD-MM-YYYY HH24:MI:SS'),
	TO_TIMESTAMP('1-01-1949 00:00:00','DD-MM-YYYY HH24:MI:SS'),
	NULL,
	'Y',
	SYSDATE,
	'BASE',
	'BASE',
	NULL,
	'Y',
	'Y',
	'0',
	'N',
	'I',
	NULL,
	NULL,
	NULL
);

INSERT INTO INVSTAT
(
	INV_STAT,                                                                                                                                                                                       
	DESCR,                                                                                                                                                                                  
	AVAILABLE,                                                                                                                                                                                       
	OVERISS,                                                                                                                                                                                       
	PLAN_PROD,                                                                                                                                                                                       
	RECORD ,                                                                                                                                                                                       
	CHG_DATE,                                                                                                                                                                                          
	CHG_USER ,                                                                                                                                                                                      
	CHG_TERM ,                                                                                                                                                                                      
	USABLE  ,                                                                                                                                                                                       
	STAT_TYPE,                                                                                                                                                                                       
	REPORT_TYPE
)
VALUES 
(
	'PGRL',
	'Part General receipt',
	'Y',
	'N',
	'N',
	'Y',
	sysdate,
	'BASE      ',
	'localhost.local',
	'Y',
	'M',
	NULL
);