CREATE TABLE gtg_aar_approved_incidents (
    INCIDENT_ID                      NUMBER(18, 0) ,
    AAR_REQ_ID                       NUMBER(18, 0)     NOT NULL,
    GLOBAL_USER_ID                   NUMBER(18, 0)     NOT NULL,
    ROLE                             VARCHAR2(4000),
    ACCESS_POINT_NAME                VARCHAR2(1024),
    REQUEST_TYPE                     VARCHAR2(1024),
    ACCESS_PATH_ID                   VARCHAR2(1024),
    ACCESS_PATH_IDS                  VARCHAR2(4000),
    PATH_EXPRESSION                  VARCHAR2(4000),
    ACCESS_PATH_GROUPING             VARCHAR2(4000),
    CONFLICTING_ACCESS_POINT_ID      VARCHAR2(1024),
    CONFLICTING_ACCESS_POINT_NAME    VARCHAR2(1024),
    CONFLICTING_ACCESS_POINT_TYPE    VARCHAR2(1024),
    ROLE_GROUPING                    VARCHAR2(4000),
    ORIG_KEYPATH                     VARCHAR2(4000),
    HASHCODE                         VARCHAR2(4000),
    CONTROL_ID                       NUMBER(18, 0)     NOT NULL,
    IS_PROCESSED                     VARCHAR2(40)      NOT NULL,
    CREATED_BY                       VARCHAR2(256)     NOT NULL,
    CREATION_DATE                    TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                  VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    INCIDENT_ID                      NUMBER(18, 0) ,
    AAR_REQ_ID                       NUMBER(18, 0)     NOT NULL,
    GLOBAL_USER_ID                   NUMBER(18, 0)     NOT NULL,
    ROLE                             VARCHAR2(4000),
    ACCESS_POINT_NAME                VARCHAR2(1024),
    ACCESS_PATH_ID                   VARCHAR2(1024),
    ACCESS_PATH_IDS                  VARCHAR2(4000),
    PATH_EXPRESSION                  VARCHAR2(4000),
    ACCESS_PATH_GROUPING             VARCHAR2(4000),
    CONFLICTING_ACCESS_POINT_ID      VARCHAR2(1024),
    CONFLICTING_ACCESS_POINT_NAME    VARCHAR2(1024),
    CONFLICTING_ACCESS_POINT_TYPE    VARCHAR2(1024),
    ROLE_GROUPING                    VARCHAR2(4000),
    ORIG_KEYPATH                     VARCHAR2(4000),
    HASHCODE                         VARCHAR2(4000),
    CONTROL_ID                       NUMBER(18, 0)     NOT NULL,
    IS_PROCESSED                     VARCHAR2(40)      NOT NULL,
    CREATED_BY                       VARCHAR2(256)     NOT NULL,
    CREATION_DATE                    TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                  VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                 TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 0)      NOT NULL,
    REQUEST_TYPE                     VARCHAR2(1024),
    CONSTRAINT pk_gtg_aar_approved_incidents PRIMARY KEY (INCIDENT_ID, INCIDENT_ID)
);
