CREATE TABLE inv_onhand_quantities_detail (
    INVENTORY_ITEM_ID                 NUMBER(18, 0)    NOT NULL,
    STANDARD_PACK_UOM                 VARCHAR2(12) ,
    STANDARD_PACK_QUANTITY            NUMBER       ,
    ORGANIZATION_ID                   NUMBER(18, 0)    NOT NULL,
    DATE_RECEIVED                     DATE         ,
    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),
    PRIMARY_TRANSACTION_QUANTITY      NUMBER           NOT NULL,
    SUBINVENTORY_CODE                 VARCHAR2(40)     NOT NULL,
    REVISION                          VARCHAR2(72) ,
    LOCATOR_ID                        NUMBER(18, 0),
    CREATE_TRANSACTION_ID             NUMBER(18, 0),
    UPDATE_TRANSACTION_ID             NUMBER(18, 0),
    LOT_NUMBER                        VARCHAR2(320),
    ORIG_DATE_RECEIVED                DATE         ,
    ONHAND_QUANTITIES_ID              NUMBER(18, 0),
    TRANSACTION_UOM_CODE              VARCHAR2(12)     NOT NULL,
    TRANSACTION_QUANTITY              NUMBER           NOT NULL,
    SECONDARY_UOM_CODE                VARCHAR2(12) ,
    SECONDARY_TRANSACTION_QUANTITY    NUMBER       ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)     NOT NULL,
    ORIG_SOURCE_TXN_ID                NUMBER(18, 0),
    OWNING_TYPE                       VARCHAR2(120),
    OWNING_ENTITY_ID                  NUMBER(18, 0),
    AGING_ONSET_DATE                  DATE         ,
    AGING_EXPIRATION_DATE             DATE         ,
    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),
    LPN_ID                            NUMBER(18, 0),
    INVENTORY_ITEM_ID                 NUMBER(18, 0)    NOT NULL,
    STANDARD_PACK_UOM                 VARCHAR2(12) ,
    STANDARD_PACK_QUANTITY            NUMBER       ,
    ORGANIZATION_ID                   NUMBER(18, 0)    NOT NULL,
    DATE_RECEIVED                     DATE         ,
    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),
    PRIMARY_TRANSACTION_QUANTITY      NUMBER           NOT NULL,
    SUBINVENTORY_CODE                 VARCHAR2(40)     NOT NULL,
    REVISION                          VARCHAR2(72) ,
    LOCATOR_ID                        NUMBER(18, 0),
    CREATE_TRANSACTION_ID             NUMBER(18, 0),
    UPDATE_TRANSACTION_ID             NUMBER(18, 0),
    LOT_NUMBER                        VARCHAR2(320),
    ORIG_DATE_RECEIVED                DATE         ,
    ONHAND_QUANTITIES_ID              NUMBER(18, 0),
    TRANSACTION_UOM_CODE              VARCHAR2(12)     NOT NULL,
    TRANSACTION_QUANTITY              NUMBER           NOT NULL,
    SECONDARY_UOM_CODE                VARCHAR2(12) ,
    SECONDARY_TRANSACTION_QUANTITY    NUMBER       ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)     NOT NULL,
    ORIG_SOURCE_TXN_ID                NUMBER(18, 0),
    OWNING_TYPE                       VARCHAR2(120),
    OWNING_ENTITY_ID                  NUMBER(18, 0),
    AGING_ONSET_DATE                  DATE         ,
    AGING_EXPIRATION_DATE             DATE         ,
    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),
    LPN_ID                            NUMBER(18, 0),
    CONSTRAINT pk_inv_onhand_quantities_detail PRIMARY KEY (ONHAND_QUANTITIES_ID, ONHAND_QUANTITIES_ID)
);
