CREATE TABLE inv_secondary_inventories (
    SECONDARY_INVENTORY_NAME     VARCHAR2(40)  ,
    STANDARD_PACK_TYPE           VARCHAR2(12)  ,
    STRUCTURE_INSTANCE_NUMBER    NUMBER(18, 0) ,
    ORGANIZATION_ID              NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 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) ,
    DESCRIPTION                  VARCHAR2(200) ,
    DISABLE_DATE                 DATE          ,
    INVENTORY_ATP_CODE           NUMBER(9, 0)      NOT NULL,
    AVAILABILITY_TYPE            NUMBER(9, 0)      NOT NULL,
    RESERVABLE_TYPE              NUMBER(9, 0)      NOT NULL,
    LOCATOR_TYPE                 VARCHAR2(120) ,
    PICKING_ORDER                NUMBER        ,
    QUANTITY_TRACKED             NUMBER(9, 0)      NOT NULL,
    SUBINVENTORY_ID              NUMBER(18, 0)     NOT NULL,
    ASSET_INVENTORY              NUMBER(9, 0)      NOT NULL,
    SOURCE_TYPE                  VARCHAR2(120) ,
    SOURCE_SUBINVENTORY          VARCHAR2(40)  ,
    SOURCE_ORGANIZATION_ID       NUMBER(18, 0) ,
    REQUISITION_APPROVAL_TYPE    NUMBER        ,
    FILL_KILL_TO_LOOKUP          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) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    PREPROCESSING_LEAD_TIME      NUMBER        ,
    PROCESSING_LEAD_TIME         NUMBER        ,
    POSTPROCESSING_LEAD_TIME     NUMBER        ,
    DEMAND_CLASS                 VARCHAR2(120) ,
    PROJECT_ID                   NUMBER(18, 0) ,
    TASK_ID                      NUMBER(18, 0) ,
    SUBINVENTORY_USAGE           NUMBER        ,
    LOCATION_ID                  NUMBER(18, 0) ,
    PICK_UOM_CODE                VARCHAR2(12)  ,
    DEPRECIABLE_FLAG             NUMBER(9, 0)  ,
    STATUS_ID                    NUMBER(18, 0) ,
    DEFAULT_LOC_STATUS_ID        NUMBER(18, 0) ,
    LPN_CONTROLLED_FLAG          NUMBER(9, 0)  ,
    PICK_METHODOLOGY             NUMBER(9, 0)  ,
    CARTONIZATION_FLAG           NUMBER(9, 0)  ,
    DROPPING_ORDER               NUMBER        ,
    SUBINVENTORY_TYPE            VARCHAR2(120) ,
    PLANNING_LEVEL               NUMBER(9, 0)  ,
    DEFAULT_COUNT_TYPE_CODE      VARCHAR2(120) ,
    COUNT_METHOD                 VARCHAR2(120) ,
    SUBINVENTORY_GROUP           VARCHAR2(400) ,
    ENABLE_BULK_PICK             VARCHAR2(4)   ,
    ENABLE_LOCATOR_ALIAS         VARCHAR2(4)   ,
    ENFORCE_ALIAS_UNIQUENESS     VARCHAR2(4)   ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    ORACLE_HEALTH_LOCATION       VARCHAR2(4)   ,
    USE_SUB_MFG_MNT_IN_WMS       VARCHAR2(4)   ,
    USE_PACK_UNIT_COMP_RET       VARCHAR2(4)   ,
    ALLOW_OFFLINE_MODE           VARCHAR2(4)   ,
    AUTO_CREATE_DELIVERIES       VARCHAR2(4)   ,
    FULL_LPN_FLAG                VARCHAR2(4)   ,
    NUMBER_OF_BINS               NUMBER        ,
    SECONDARY_INVENTORY_NAME     VARCHAR2(40)  ,
    STANDARD_PACK_TYPE           VARCHAR2(12)  ,
    STRUCTURE_INSTANCE_NUMBER    NUMBER(18, 0) ,
    ORGANIZATION_ID              NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 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) ,
    DESCRIPTION                  VARCHAR2(200) ,
    DISABLE_DATE                 DATE          ,
    INVENTORY_ATP_CODE           NUMBER(9, 0)      NOT NULL,
    AVAILABILITY_TYPE            NUMBER(9, 0)      NOT NULL,
    RESERVABLE_TYPE              NUMBER(9, 0)      NOT NULL,
    LOCATOR_TYPE                 VARCHAR2(120) ,
    PICKING_ORDER                NUMBER        ,
    QUANTITY_TRACKED             NUMBER(9, 0)      NOT NULL,
    SUBINVENTORY_ID              NUMBER(18, 0)     NOT NULL,
    ASSET_INVENTORY              NUMBER(9, 0)      NOT NULL,
    SOURCE_TYPE                  VARCHAR2(120) ,
    SOURCE_SUBINVENTORY          VARCHAR2(40)  ,
    SOURCE_ORGANIZATION_ID       NUMBER(18, 0) ,
    REQUISITION_APPROVAL_TYPE    NUMBER        ,
    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) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    PREPROCESSING_LEAD_TIME      NUMBER        ,
    PROCESSING_LEAD_TIME         NUMBER        ,
    POSTPROCESSING_LEAD_TIME     NUMBER        ,
    DEMAND_CLASS                 VARCHAR2(120) ,
    PROJECT_ID                   NUMBER(18, 0) ,
    TASK_ID                      NUMBER(18, 0) ,
    SUBINVENTORY_USAGE           NUMBER        ,
    LOCATION_ID                  NUMBER(18, 0) ,
    PICK_UOM_CODE                VARCHAR2(12)  ,
    DEPRECIABLE_FLAG             NUMBER(9, 0)  ,
    STATUS_ID                    NUMBER(18, 0) ,
    DEFAULT_LOC_STATUS_ID        NUMBER(18, 0) ,
    LPN_CONTROLLED_FLAG          NUMBER(9, 0)  ,
    PICK_METHODOLOGY             NUMBER(9, 0)  ,
    CARTONIZATION_FLAG           NUMBER(9, 0)  ,
    DROPPING_ORDER               NUMBER        ,
    SUBINVENTORY_TYPE            VARCHAR2(120) ,
    PLANNING_LEVEL               NUMBER(9, 0)  ,
    DEFAULT_COUNT_TYPE_CODE      VARCHAR2(120) ,
    ENABLE_BULK_PICK             VARCHAR2(4)   ,
    ENABLE_LOCATOR_ALIAS         VARCHAR2(4)   ,
    ENFORCE_ALIAS_UNIQUENESS     VARCHAR2(4)   ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    FILL_KILL_TO_LOOKUP          VARCHAR2(120) ,
    COUNT_METHOD                 VARCHAR2(120) ,
    SUBINVENTORY_GROUP           VARCHAR2(400) ,
    ORACLE_HEALTH_LOCATION       VARCHAR2(4)   ,
    USE_SUB_MFG_MNT_IN_WMS       VARCHAR2(4)   ,
    USE_PACK_UNIT_COMP_RET       VARCHAR2(4)   ,
    ALLOW_OFFLINE_MODE           VARCHAR2(4)   ,
    AUTO_CREATE_DELIVERIES       VARCHAR2(4)   ,
    FULL_LPN_FLAG                VARCHAR2(4)   ,
    NUMBER_OF_BINS               NUMBER        ,
    CONSTRAINT pk_inv_secondary_inventories PRIMARY KEY (SECONDARY_INVENTORY_NAME, ORGANIZATION_ID, SECONDARY_INVENTORY_NAME, ORGANIZATION_ID)
);
