--Order 20013071 (Slow Movers and Purchase Request Procedure)


ALTER TABLE STOCKDEFINITIONPERITEM
	ADD  CONSTRAINT PRODCONSTYPE_valid  CHECK (PRODUCTCONSUMPTIONTYPE IN (1, 2, 3));


ALTER TABLE STOCKDEFINITIONPERITEM
	ADD  CONSTRAINT PRODCONSRANKING_valid  CHECK (PRODUCTCONSUMPTIONRANKING IN (1, 2));

ALTER TABLE WORKORDERLINEPURCHREQ
ADD CONSTRAINT XAK1WORKORDERLINEPURCHREQ UNIQUE (WORKORDERLINE_ID, PURCHASEREQUEST_ID);

DELETE FROM PROCESS P WHERE P.PROCESS_ID = 120;
 
INSERT INTO PROCESS(PROCESS_ID,DESCRIPTION,ACTIVE) VALUES ('120', 'Determine Slow and Fast Movers per Stockroom', 'Y');

COMMIT;

