/*ORDER 502398*/   
      /*
      CHANGE REPORT for Table INVOICELINEPRODUCT
          - Adding a new relationship INVOICELINEPRODUCT_CORRECTED_I
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK INVOICELINEPRODUCT_CORRECTED_I of table INVOICELINEPRODUCT, which references table INVOICEHEADER).
          - Adding column CORRECTED_INVOICEHEADER_ID
          - Adding index XIF8INVOICELINEPRODUCT
      ACTION is ALTER or modify Table INVOICELINEPRODUCT
      */

ALTER TABLE INVOICELINEPRODUCT ADD (CORRECTED_INVOICEHEADER_ID NUMBER NULL);

CREATE INDEX XIF8INVOICELINEPRODUCT ON INVOICELINEPRODUCT
(
       CORRECTED_INVOICEHEADER_ID     ASC
);


ALTER TABLE INVOICELINEPRODUCT
       ADD  ( CONSTRAINT INVOICELINEPRODUCT_CORRECTED_I
              FOREIGN KEY (CORRECTED_INVOICEHEADER_ID)
                             REFERENCES INVOICEHEADER ) ;

