CREATE TABLE egp_ic_hierarchy (
    IC_HIERARCHY_ID           NUMBER(18, 0) ,
    ITEM_CLASS_ID             NUMBER(18, 0)     NOT NULL,
    ITEM_CLASS_CODE           VARCHAR2(3200)    NOT NULL,
    PARENT_ITEM_CLASS_ID      NUMBER(18, 0) ,
    PARENT_ITEM_CLASS_CODE    VARCHAR2(3200),
    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,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    ITEM_CLASS_LEVEL          NUMBER(9, 0)  ,
    IC_HIERARCHY_ID           NUMBER(18, 0) ,
    ITEM_CLASS_ID             NUMBER(18, 0)     NOT NULL,
    ITEM_CLASS_CODE           VARCHAR2(3200)    NOT NULL,
    PARENT_ITEM_CLASS_ID      NUMBER(18, 0) ,
    PARENT_ITEM_CLASS_CODE    VARCHAR2(3200),
    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,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)      NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128) ,
    ITEM_CLASS_LEVEL          NUMBER(9, 0)  ,
    CONSTRAINT pk_egp_ic_hierarchy PRIMARY KEY (IC_HIERARCHY_ID, IC_HIERARCHY_ID)
);
