ALTER TABLE ERP_O_WORKORDER
ADD (
 REASONCODE VARCHAR2(6),
 SEARCHNAME VARCHAR2(10),
 TOTALLINES NUMBER,
 TOTALQUANTITY NUMBER);
COMMENT ON COLUMN ERP_O_WORKORDER.REASONCODE IS 'Reason code of the WorkOrder';
COMMENT ON COLUMN ERP_O_WORKORDER.SEARCHNAME IS 'Customer Search Name';
COMMENT ON COLUMN ERP_O_WORKORDER.TOTALLINES IS 'Total number of products on the Workorder';
COMMENT ON COLUMN ERP_O_WORKORDER.TOTALQUANTITY IS 'Total number of pieces on the Workorder';

ALTER TABLE ERP_O_WORKORDERLINE
ADD (QUANTITYPICKED NUMBER,
WEARER_ID NUMBER,
WEARERINVENTORY_ID NUMBER);