CREATE TABLE inv_lot_item_controls (
    INVENTORY_ITEM_ID        NUMBER(18, 0),
    ORGANIZATION_ID          NUMBER(18, 0),
    AUTO_LOT_ALPHA_PREFIX    VARCHAR2(320),
    START_AUTO_LOT_NUMBER    VARCHAR2(320),
    NEXT_AUTO_LOT_NUMBER     VARCHAR2(320),
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    INVENTORY_ITEM_ID        NUMBER(18, 0),
    ORGANIZATION_ID          NUMBER(18, 0),
    AUTO_LOT_ALPHA_PREFIX    VARCHAR2(320),
    START_AUTO_LOT_NUMBER    VARCHAR2(320),
    NEXT_AUTO_LOT_NUMBER     VARCHAR2(320),
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    CONSTRAINT pk_inv_lot_item_controls PRIMARY KEY (INVENTORY_ITEM_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID)
);
