ALTER TABLE PORCPDET ADD PART_QTY NUMBER(14,3);
UPDATE OBJ_FORMS SET SCAN_METADATA= '<SCAN_INFO><INPUT_SCAN ORDER="1"><SCAN_LABEL>ASN No:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>asn_no</FIELD></FIELDS></INPUT_SCAN><INPUT_SCAN ORDER="2"><SCAN_LABEL>Location Code:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>loc_code</FIELD></FIELDS></INPUT_SCAN></SCAN_INFO>' WHERE WIN_NAME ='w_porcp_wiz' AND FORM_NO = 1;
UPDATE OBJ_FORMS SET SCAN_METADATA= '<SCAN_INFO><MAPPING_SCAN ORDER="1"><SCAN_LABEL>Item Code:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>item_code</FIELD></FIELDS></MAPPING_SCAN><MAPPING_SCAN ORDER="2"><SCAN_LABEL>Lot No:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>lot_no</FIELD></FIELDS></MAPPING_SCAN><INPUT_SCAN ORDER="1"><SCAN_LABEL>LPN No:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>lot_sl</FIELD></FIELDS></INPUT_SCAN><INPUT_SCAN ORDER="2"><SCAN_LABEL>Number of Cases:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>no_art</FIELD></FIELDS></INPUT_SCAN><INPUT_SCAN ORDER="3"><SCAN_LABEL>Partial Quantity:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>part_qty</FIELD></FIELDS></INPUT_SCAN><INPUT_SCAN ORDER="4"><SCAN_LABEL>Quantity:</SCAN_LABEL><FIELDS SEPARATOR="" DELIMITER=""><FIELD>quantity</FIELD></FIELDS></INPUT_SCAN></SCAN_INFO>' WHERE WIN_NAME ='w_porcp_wiz' AND FORM_NO = 3;


/*Date 3-Aug-12 [START]*/
INSERT INTO DISPARM 
(
	PRD_CODE,                                                                                                                                                                                        
	VAR_NAME,                                                                                                                                                                                     
	VAR_TYPE ,                                                                                                                                                                                        
	VAR_VALUE ,                                                                                                                                                                                
	DESCR ,                                                                                                                                                                                 
	VAR_SUBS,                                                                                                                                                                                     
	CHG_DATE ,                                                                                                                                                                                          
	CHG_USER ,                                                                                                                                                                                      
	CHG_TERM
)
VALUES
(
	'999999',
	'MAINTAIN_LOT_MASTER',
	'S',
	'Y',
	'For maintaining lot master ie. ITEM_LOT_INFO',
	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
(
	'INVLOTNMST',
	'Invalid Lot No',
	'Lot No Does not exist in lot master ',
	'E',
	NULL,
	NULL,
	NULL,
	NULL,
	sysdate,
	'BASE',
	'BASE',
	NULL,
	NULL
);
/*Date 3-Aug-12 [END]*/

/* Date 07-Aug-12 [START] */
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
(
	'VTNTCNF',
	'Receipt can not be confirm',
	'Receipt can not be confirm as Quantity is not matching with ASN quantity',
	'P',
	NULL,
	NULL,
	NULL,
	NULL,
	sysdate,
	'BASE',
	'BASE',
	NULL,
	NULL
);

UPDATE MESSAGES SET MSG_DESCR ='Quantity is greater than ASN quantity' WHERE MSG_NO ='VTQMM';

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 can not be null',
	'Location Code can not be null , Please specify appropriate location code ',
	'P',
	NULL,
	NULL,
	NULL,
	NULL,
	sysdate,
	'BASE',
	'BASE',
	NULL,
	NULL
);


/* Date 07-Aug-12 [END] */

/* Date 08-Aug-12 [START] */
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
(
	'NULLLPNNO',
	'LPN No can not be null',
	'LPN No can not be null , Please specify appropriate LPN Number ',
	'E',
	NULL,
	NULL,
	NULL,
	NULL,
	sysdate,
	'BASE',
	'BASE',
	NULL,
	NULL
);

/* Date 08-Aug-12 [END] */