CREATE TABLE grc_asmt_actvtstplan (
    ASSESSMENT_ID              NUMBER(18, 0),
    PLAN_EFFECTIVE_SEQUENCE    NUMBER(4, 0)     NOT NULL,
    TEST_PLAN_ID               NUMBER(18, 0),
    ACTIVITY_CODE              VARCHAR2(120),
    CONTROL_RESULT_ID          NUMBER(18, 0),
    CONTROL_ID                 NUMBER(18, 0)    NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    ASSESSMENT_ID              NUMBER(18, 0),
    TEST_PLAN_ID               NUMBER(18, 0),
    ACTIVITY_CODE              VARCHAR2(120),
    CONTROL_ID                 NUMBER(18, 0)    NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    CONTROL_RESULT_ID          NUMBER(18, 0),
    PLAN_EFFECTIVE_SEQUENCE    NUMBER(4, 0)     NOT NULL,
    CONSTRAINT pk_grc_asmt_actvtstplan PRIMARY KEY (ASSESSMENT_ID, TEST_PLAN_ID, ACTIVITY_CODE, CONTROL_RESULT_ID, ASSESSMENT_ID, TEST_PLAN_ID, ACTIVITY_CODE, CONTROL_RESULT_ID)
);
