CREATE TABLE doo_hold_task_instances (
    TASK_INSTANCE_ID           NUMBER(18, 0),
    FULFILL_LINE_ID            NUMBER(18, 0)    NOT NULL,
    HOLD_INSTANCE_ID           NUMBER(18, 0),
    PENDING_FLAG               VARCHAR2(4)  ,
    DELETED_FLAG               VARCHAR2(4)  ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    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),
    TRANSACTION_ENTITY_ID      NUMBER(18, 0),
    TRANSACTION_ENTITY_NAME    VARCHAR2(120),
    TASK_INSTANCE_ID           NUMBER(18, 0),
    FULFILL_LINE_ID            NUMBER(18, 0)    NOT NULL,
    HOLD_INSTANCE_ID           NUMBER(18, 0),
    PENDING_FLAG               VARCHAR2(4)  ,
    DELETED_FLAG               VARCHAR2(4)  ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    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),
    TRANSACTION_ENTITY_ID      NUMBER(18, 0),
    TRANSACTION_ENTITY_NAME    VARCHAR2(120),
    CONSTRAINT pk_doo_hold_task_instances PRIMARY KEY (TASK_INSTANCE_ID, HOLD_INSTANCE_ID, TRANSACTION_ENTITY_ID, TRANSACTION_ENTITY_NAME, TASK_INSTANCE_ID, HOLD_INSTANCE_ID, TRANSACTION_ENTITY_ID, TRANSACTION_ENTITY_NAME)
);
