CREATE TABLE inv_cycle_count_entries (
    CYCLE_COUNT_ENTRY_ID              NUMBER(18, 0) ,
    FLOW_SOURCE                       VARCHAR2(4)   ,
    ZONE_ID                           NUMBER(18, 0) ,
    ZONE_TASK_ID                      NUMBER(18, 0) ,
    INV_STRIPING_CATEGORY             VARCHAR2(160) ,
    PROJECT_ID                        NUMBER(18, 0) ,
    TASK_ID                           NUMBER(18, 0) ,
    COUNTRY_OF_ORIGIN_CODE            VARCHAR2(8)   ,
    INV_RESERVED_ATTRIBUTE1           VARCHAR2(600) ,
    INV_RESERVED_ATTRIBUTE2           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE1           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE2           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE3           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE4           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE5           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE6           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE7           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE8           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE9           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE10          VARCHAR2(600) ,
    OWNING_TYPE                       VARCHAR2(120) ,
    OWNING_ENTITY_ID                  NUMBER(18, 0) ,
    JOB_DEFINITION_PACKAGE            VARCHAR2(3600),
    JOB_DEFINITION_NAME               VARCHAR2(400) ,
    CYCLE_COUNT_HEADER_ID             NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID                   NUMBER(18, 0)     NOT NULL,
    COUNT_LIST_SEQUENCE               NUMBER(18, 0) ,
    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,
    INVENTORY_ITEM_ID                 NUMBER(18, 0)     NOT NULL,
    SUBINVENTORY                      VARCHAR2(40)      NOT NULL,
    LOCATOR_ID                        NUMBER(18, 0) ,
    REVISION                          VARCHAR2(72)  ,
    LOT_NUMBER                        VARCHAR2(320) ,
    SERIAL_NUMBER                     VARCHAR2(320) ,
    SERIAL_DETAIL                     NUMBER(18, 0) ,
    ENTRY_STATUS_CODE                 VARCHAR2(120) ,
    COUNT_DATE                        DATE          ,
    COUNT_DUE_DATE                    DATE          ,
    COUNTED_BY_EMPLOYEE_ID            NUMBER(18, 0) ,
    COUNT_UOM                         VARCHAR2(12)  ,
    COUNT_SECONDARY_UOM               VARCHAR2(12)  ,
    COUNT_QUANTITY                    NUMBER        ,
    PRIMARY_UOM_QUANTITY              NUMBER        ,
    SECONDARY_UOM_QUANTITY            NUMBER        ,
    SYSTEM_QUANTITY                   NUMBER        ,
    SECONDARY_SYSTEM_QTY              NUMBER        ,
    ADJUSTMENT_QUANTITY               NUMBER        ,
    SECONDARY_ADJUSTMENT_QUANTITY     NUMBER        ,
    ADJUSTMENT_DATE                   DATE          ,
    ADJUSTMENT_AMOUNT                 NUMBER        ,
    ITEM_UNIT_COST                    NUMBER        ,
    NUMBER_OF_COUNTS                  NUMBER(18, 0) ,
    APPROVAL_TYPE                     NUMBER(18, 0) ,
    APPROVAL_DATE                     DATE          ,
    APPROVER_EMPLOYEE_ID              NUMBER(18, 0) ,
    TRANSACTION_REASON_ID             NUMBER(18, 0) ,
    COMMENTS                          VARCHAR2(960) ,
    COUNT_TYPE_CODE                   VARCHAR2(120) ,
    REQUEST_ID                        NUMBER(18, 0) ,
    EXPORT_FLAG                       NUMBER(18, 0) ,
    PARENT_LPN_ID                     NUMBER(18, 0) ,
    OUTERMOST_LPN_ID                  NUMBER(18, 0) ,
    LPN_SUMMARY_COUNT_FLAG            VARCHAR2(4)   ,
    STANDARD_OPERATION_ID             NUMBER(18, 0) ,
    TASK_PRIORITY                     NUMBER(18, 0) ,
    ITEM_REVISION_QTY_CONTROL_CODE    VARCHAR2(120) ,
    ITEM_SERIAL_CONTROL_CODE          VARCHAR2(120) ,
    ITEM_LOT_CONTROL_CODE             VARCHAR2(120) ,
    LPN_ADJUSTMENT_TYPE               NUMBER(18, 0) ,
    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) ,
    STANDARD_PACK_UOM_FLAG            VARCHAR2(4)   ,
    ATTRIBUTE16                       VARCHAR2(600) ,
    ATTRIBUTE17                       VARCHAR2(600) ,
    ATTRIBUTE18                       VARCHAR2(600) ,
    ATTRIBUTE19                       VARCHAR2(600) ,
    ATTRIBUTE20                       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)  ,
    ADJUSTMENT_QUANTITY_PUOM          NUMBER        ,
    CYCLE_COUNT_ENTRY_ID              NUMBER(18, 0) ,
    JOB_DEFINITION_PACKAGE            VARCHAR2(3600),
    JOB_DEFINITION_NAME               VARCHAR2(400) ,
    CYCLE_COUNT_HEADER_ID             NUMBER(18, 0)     NOT NULL,
    ORGANIZATION_ID                   NUMBER(18, 0)     NOT NULL,
    COUNT_LIST_SEQUENCE               NUMBER(18, 0) ,
    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,
    INVENTORY_ITEM_ID                 NUMBER(18, 0)     NOT NULL,
    SUBINVENTORY                      VARCHAR2(40)      NOT NULL,
    LOCATOR_ID                        NUMBER(18, 0) ,
    REVISION                          VARCHAR2(72)  ,
    LOT_NUMBER                        VARCHAR2(320) ,
    SERIAL_NUMBER                     VARCHAR2(320) ,
    SERIAL_DETAIL                     NUMBER(18, 0) ,
    ENTRY_STATUS_CODE                 VARCHAR2(120) ,
    COUNT_DATE                        DATE          ,
    COUNT_DUE_DATE                    DATE          ,
    COUNTED_BY_EMPLOYEE_ID            NUMBER(18, 0) ,
    COUNT_UOM                         VARCHAR2(12)  ,
    COUNT_SECONDARY_UOM               VARCHAR2(12)  ,
    COUNT_QUANTITY                    NUMBER        ,
    PRIMARY_UOM_QUANTITY              NUMBER        ,
    SECONDARY_UOM_QUANTITY            NUMBER        ,
    SYSTEM_QUANTITY                   NUMBER        ,
    SECONDARY_SYSTEM_QTY              NUMBER        ,
    ADJUSTMENT_QUANTITY               NUMBER        ,
    SECONDARY_ADJUSTMENT_QUANTITY     NUMBER        ,
    ADJUSTMENT_DATE                   DATE          ,
    ADJUSTMENT_AMOUNT                 NUMBER        ,
    ITEM_UNIT_COST                    NUMBER        ,
    NUMBER_OF_COUNTS                  NUMBER(18, 0) ,
    APPROVAL_TYPE                     NUMBER(18, 0) ,
    APPROVAL_DATE                     DATE          ,
    APPROVER_EMPLOYEE_ID              NUMBER(18, 0) ,
    TRANSACTION_REASON_ID             NUMBER(18, 0) ,
    COMMENTS                          VARCHAR2(960) ,
    COUNT_TYPE_CODE                   VARCHAR2(120) ,
    REQUEST_ID                        NUMBER(18, 0) ,
    EXPORT_FLAG                       NUMBER(18, 0) ,
    PARENT_LPN_ID                     NUMBER(18, 0) ,
    OUTERMOST_LPN_ID                  NUMBER(18, 0) ,
    STANDARD_OPERATION_ID             NUMBER(18, 0) ,
    TASK_PRIORITY                     NUMBER(18, 0) ,
    ITEM_REVISION_QTY_CONTROL_CODE    VARCHAR2(120) ,
    ITEM_SERIAL_CONTROL_CODE          VARCHAR2(120) ,
    ITEM_LOT_CONTROL_CODE             VARCHAR2(120) ,
    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) ,
    STANDARD_PACK_UOM_FLAG            VARCHAR2(4)   ,
    ATTRIBUTE16                       VARCHAR2(600) ,
    ATTRIBUTE17                       VARCHAR2(600) ,
    ATTRIBUTE18                       VARCHAR2(600) ,
    ATTRIBUTE19                       VARCHAR2(600) ,
    ATTRIBUTE20                       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)  ,
    OWNING_TYPE                       VARCHAR2(120) ,
    OWNING_ENTITY_ID                  NUMBER(18, 0) ,
    INV_STRIPING_CATEGORY             VARCHAR2(160) ,
    PROJECT_ID                        NUMBER(18, 0) ,
    TASK_ID                           NUMBER(18, 0) ,
    COUNTRY_OF_ORIGIN_CODE            VARCHAR2(8)   ,
    INV_RESERVED_ATTRIBUTE1           VARCHAR2(600) ,
    INV_RESERVED_ATTRIBUTE2           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE1           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE2           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE3           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE4           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE5           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE6           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE7           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE8           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE9           VARCHAR2(600) ,
    INV_USER_DEF_ATTRIBUTE10          VARCHAR2(600) ,
    ZONE_ID                           NUMBER(18, 0) ,
    ZONE_TASK_ID                      NUMBER(18, 0) ,
    LPN_SUMMARY_COUNT_FLAG            VARCHAR2(4)   ,
    LPN_ADJUSTMENT_TYPE               NUMBER(18, 0) ,
    FLOW_SOURCE                       VARCHAR2(4)   ,
    ADJUSTMENT_QUANTITY_PUOM          NUMBER        ,
    CONSTRAINT pk_inv_cycle_count_entries PRIMARY KEY (CYCLE_COUNT_ENTRY_ID, CYCLE_COUNT_ENTRY_ID)
);
