CREATE TABLE inv_cycle_count_items (
    CYCLE_COUNT_ITEM_ID            NUMBER(18, 0) ,
    CYCLE_COUNT_HEADER_ID          NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID                NUMBER(18, 0)     NOT NULL,
    ABC_CLASS_ID                   NUMBER(18, 0)     NOT NULL,
    INVENTORY_ITEM_ID              NUMBER(18, 0)     NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)     NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)      NOT NULL,
    CREATED_BY                     VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    ITEM_LAST_SCHEDULE_DATE        DATE          ,
    SCHEDULE_ORDER                 NUMBER(18, 0) ,
    APPROVAL_TOLERANCE_POSITIVE    NUMBER        ,
    APPROVAL_TOLERANCE_NEGATIVE    NUMBER        ,
    COST_TOLERANCE_POSITIVE        NUMBER        ,
    COST_TOLERANCE_NEGATIVE        NUMBER        ,
    INCLUDE_IN_SCHEDULE            NUMBER(18, 0) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    JOB_DEFINITION_NAME            VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE         VARCHAR2(3600),
    ATTRIBUTE_CATEGORY             VARCHAR2(120) ,
    ATTRIBUTE1                     VARCHAR2(600) ,
    ATTRIBUTE2                     VARCHAR2(600) ,
    ATTRIBUTE3                     VARCHAR2(600) ,
    ATTRIBUTE4                     VARCHAR2(600) ,
    ATTRIBUTE5                     VARCHAR2(600) ,
    ATTRIBUTE6                     VARCHAR2(600) ,
    ATTRIBUTE7                     VARCHAR2(600) ,
    ATTRIBUTE8                     VARCHAR2(600) ,
    ATTRIBUTE9                     VARCHAR2(600) ,
    ATTRIBUTE10                    VARCHAR2(600) ,
    ATTRIBUTE11                    VARCHAR2(600) ,
    ATTRIBUTE12                    VARCHAR2(600) ,
    ATTRIBUTE13                    VARCHAR2(600) ,
    ATTRIBUTE14                    VARCHAR2(600) ,
    ATTRIBUTE15                    VARCHAR2(600) ,
    CYCLE_COUNT_ITEM_ID            NUMBER(18, 0) ,
    CYCLE_COUNT_HEADER_ID          NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID                NUMBER(18, 0)     NOT NULL,
    ABC_CLASS_ID                   NUMBER(18, 0)     NOT NULL,
    INVENTORY_ITEM_ID              NUMBER(18, 0)     NOT NULL,
    LAST_UPDATE_DATE               TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                VARCHAR2(256)     NOT NULL,
    CREATION_DATE                  TIMESTAMP(6)      NOT NULL,
    CREATED_BY                     VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)      NOT NULL,
    ITEM_LAST_SCHEDULE_DATE        DATE          ,
    SCHEDULE_ORDER                 NUMBER(18, 0) ,
    APPROVAL_TOLERANCE_POSITIVE    NUMBER        ,
    APPROVAL_TOLERANCE_NEGATIVE    NUMBER        ,
    COST_TOLERANCE_POSITIVE        NUMBER        ,
    COST_TOLERANCE_NEGATIVE        NUMBER        ,
    INCLUDE_IN_SCHEDULE            NUMBER(18, 0) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    JOB_DEFINITION_NAME            VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE         VARCHAR2(3600),
    ATTRIBUTE_CATEGORY             VARCHAR2(120) ,
    ATTRIBUTE1                     VARCHAR2(600) ,
    ATTRIBUTE2                     VARCHAR2(600) ,
    ATTRIBUTE3                     VARCHAR2(600) ,
    ATTRIBUTE4                     VARCHAR2(600) ,
    ATTRIBUTE5                     VARCHAR2(600) ,
    ATTRIBUTE6                     VARCHAR2(600) ,
    ATTRIBUTE7                     VARCHAR2(600) ,
    ATTRIBUTE8                     VARCHAR2(600) ,
    ATTRIBUTE9                     VARCHAR2(600) ,
    ATTRIBUTE10                    VARCHAR2(600) ,
    ATTRIBUTE11                    VARCHAR2(600) ,
    ATTRIBUTE12                    VARCHAR2(600) ,
    ATTRIBUTE13                    VARCHAR2(600) ,
    ATTRIBUTE14                    VARCHAR2(600) ,
    ATTRIBUTE15                    VARCHAR2(600) ,
    CONSTRAINT pk_inv_cycle_count_items PRIMARY KEY (CYCLE_COUNT_ITEM_ID, CYCLE_COUNT_ITEM_ID)
);
