CREATE TABLE cst_val_unit_combinations (
    VAL_UNIT_COMBINATION_ID      NUMBER(18, 0),
    STRUCTURE_INSTANCE_NUMBER    NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    COST_ORG_CODE                VARCHAR2(72)     NOT NULL,
    INV_ORG_CODE                 VARCHAR2(72) ,
    SUBINVENTORY_CODE            VARCHAR2(960),
    LOCATOR_ID                   NUMBER(18, 0),
    GRADE_CODE                   VARCHAR2(960),
    LOT_NUMBER                   VARCHAR2(960),
    SERIAL_NUMBER                VARCHAR2(960),
    PROJECT_NUMBER               VARCHAR2(100),
    TASK_NUMBER                  VARCHAR2(400),
    COUNTRY_OF_ORIGIN_CODE       VARCHAR2(8)  ,
    ENABLED_FLAG                 VARCHAR2(4)      NOT NULL,
    SUMMARY_FLAG                 VARCHAR2(4)      NOT NULL,
    START_DATE_ACTIVE            DATE         ,
    END_DATE_ACTIVE              DATE         ,
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    ATTRIBUTE_CATEGORY           VARCHAR2(120),
    ATTRIBUTE_CHAR1              VARCHAR2(600),
    ATTRIBUTE_CHAR2              VARCHAR2(600),
    ATTRIBUTE_CHAR3              VARCHAR2(600),
    ATTRIBUTE_CHAR4              VARCHAR2(600),
    ATTRIBUTE_CHAR5              VARCHAR2(600),
    ATTRIBUTE_CHAR6              VARCHAR2(600),
    ATTRIBUTE_CHAR7              VARCHAR2(600),
    ATTRIBUTE_CHAR8              VARCHAR2(600),
    ATTRIBUTE_CHAR9              VARCHAR2(600),
    ATTRIBUTE_CHAR10             VARCHAR2(600),
    ATTRIBUTE_CHAR11             VARCHAR2(600),
    ATTRIBUTE_CHAR12             VARCHAR2(600),
    ATTRIBUTE_CHAR13             VARCHAR2(600),
    ATTRIBUTE_CHAR14             VARCHAR2(600),
    ATTRIBUTE_CHAR15             VARCHAR2(600),
    ATTRIBUTE_CHAR16             VARCHAR2(600),
    ATTRIBUTE_CHAR17             VARCHAR2(600),
    ATTRIBUTE_CHAR18             VARCHAR2(600),
    ATTRIBUTE_CHAR19             VARCHAR2(600),
    ATTRIBUTE_CHAR20             VARCHAR2(600),
    ATTRIBUTE_NUMBER1            NUMBER       ,
    ATTRIBUTE_NUMBER2            NUMBER       ,
    ATTRIBUTE_NUMBER3            NUMBER       ,
    ATTRIBUTE_NUMBER4            NUMBER       ,
    ATTRIBUTE_NUMBER5            NUMBER       ,
    ATTRIBUTE_NUMBER6            NUMBER       ,
    ATTRIBUTE_NUMBER7            NUMBER       ,
    ATTRIBUTE_NUMBER8            NUMBER       ,
    ATTRIBUTE_NUMBER9            NUMBER       ,
    ATTRIBUTE_NUMBER10           NUMBER       ,
    ATTRIBUTE_DATE1              DATE         ,
    ATTRIBUTE_DATE2              DATE         ,
    ATTRIBUTE_DATE3              DATE         ,
    ATTRIBUTE_DATE4              DATE         ,
    ATTRIBUTE_DATE5              DATE         ,
    ATTRIBUTE_TIMESTAMP1         TIMESTAMP(6) ,
    ATTRIBUTE_TIMESTAMP2         TIMESTAMP(6) ,
    ATTRIBUTE_TIMESTAMP3         TIMESTAMP(6) ,
    ATTRIBUTE_TIMESTAMP4         TIMESTAMP(6) ,
    ATTRIBUTE_TIMESTAMP5         TIMESTAMP(6) ,
    VAL_UNIT_COMBINATION_ID      NUMBER(18, 0),
    STRUCTURE_INSTANCE_NUMBER    NUMBER(18, 0)    NOT NULL,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    COST_ORG_CODE                VARCHAR2(72)     NOT NULL,
    INV_ORG_CODE                 VARCHAR2(72) ,
    SUBINVENTORY_CODE            VARCHAR2(960),
    LOCATOR_ID                   NUMBER(18, 0),
    GRADE_CODE                   VARCHAR2(960),
    LOT_NUMBER                   VARCHAR2(960),
    SERIAL_NUMBER                VARCHAR2(960),
    ENABLED_FLAG                 VARCHAR2(4)      NOT NULL,
    SUMMARY_FLAG                 VARCHAR2(4)      NOT NULL,
    START_DATE_ACTIVE            DATE         ,
    END_DATE_ACTIVE              DATE         ,
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    ATTRIBUTE_CATEGORY           VARCHAR2(120),
    ATTRIBUTE_CHAR1              VARCHAR2(600),
    ATTRIBUTE_CHAR2              VARCHAR2(600),
    ATTRIBUTE_CHAR3              VARCHAR2(600),
    ATTRIBUTE_CHAR4              VARCHAR2(600),
    ATTRIBUTE_CHAR5              VARCHAR2(600),
    ATTRIBUTE_CHAR6              VARCHAR2(600),
    ATTRIBUTE_CHAR7              VARCHAR2(600),
    ATTRIBUTE_CHAR8              VARCHAR2(600),
    ATTRIBUTE_CHAR9              VARCHAR2(600),
    ATTRIBUTE_CHAR10             VARCHAR2(600),
    ATTRIBUTE_CHAR11             VARCHAR2(600),
    ATTRIBUTE_CHAR12             VARCHAR2(600),
    ATTRIBUTE_CHAR13             VARCHAR2(600),
    ATTRIBUTE_CHAR14             VARCHAR2(600),
    ATTRIBUTE_CHAR15             VARCHAR2(600),
    ATTRIBUTE_CHAR16             VARCHAR2(600),
    ATTRIBUTE_CHAR17             VARCHAR2(600),
    ATTRIBUTE_CHAR18             VARCHAR2(600),
    ATTRIBUTE_CHAR19             VARCHAR2(600),
    ATTRIBUTE_CHAR20             VARCHAR2(600),
    ATTRIBUTE_NUMBER1            NUMBER       ,
    ATTRIBUTE_NUMBER2            NUMBER       ,
    ATTRIBUTE_NUMBER3            NUMBER       ,
    ATTRIBUTE_NUMBER4            NUMBER       ,
    ATTRIBUTE_NUMBER5            NUMBER       ,
    ATTRIBUTE_NUMBER6            NUMBER       ,
    ATTRIBUTE_NUMBER7            NUMBER       ,
    ATTRIBUTE_NUMBER8            NUMBER       ,
    ATTRIBUTE_NUMBER9            NUMBER       ,
    ATTRIBUTE_NUMBER10           NUMBER       ,
    ATTRIBUTE_DATE1              DATE         ,
    ATTRIBUTE_DATE2              DATE         ,
    ATTRIBUTE_DATE3              DATE         ,
    ATTRIBUTE_DATE4              DATE         ,
    ATTRIBUTE_DATE5              DATE         ,
    ATTRIBUTE_TIMESTAMP1         TIMESTAMP(6) ,
    ATTRIBUTE_TIMESTAMP2         TIMESTAMP(6) ,
    ATTRIBUTE_TIMESTAMP3         TIMESTAMP(6) ,
    ATTRIBUTE_TIMESTAMP4         TIMESTAMP(6) ,
    ATTRIBUTE_TIMESTAMP5         TIMESTAMP(6) ,
    PROJECT_NUMBER               VARCHAR2(100),
    TASK_NUMBER                  VARCHAR2(400),
    COUNTRY_OF_ORIGIN_CODE       VARCHAR2(8)  ,
    CONSTRAINT pk_cst_val_unit_combinations PRIMARY KEY (VAL_UNIT_COMBINATION_ID, VAL_UNIT_COMBINATION_ID)
);
