--order 502683      
      /*
      CHANGE REPORT for Table RAGGEDITEM
          - Adding a new relationship RAGGEDITEM_REPLACEMENTWORKORDE
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK RAGGEDITEM_REPLACEMENTWORKORDE of table RAGGEDITEM, which references table WORKORDER).
          - Adding column REPLACEMENTWORKORDER_ID
          - Adding index XIF15RAGGEDITEM
      ACTION is ALTER or modify Table RAGGEDITEM
      */

ALTER TABLE RAGGEDITEM ADD (REPLACEMENTWORKORDER_ID NUMBER NULL);

CREATE INDEX XIF16RAGGEDITEM ON RAGGEDITEM
(
       REPLACEMENTWORKORDER_ID        ASC
);


ALTER TABLE RAGGEDITEM
       ADD  ( CONSTRAINT RAGGEDITEM_REPLACEMENTWORKORDE
              FOREIGN KEY (REPLACEMENTWORKORDER_ID)
                             REFERENCES WORKORDER ) ;

