CREATE TABLE ego_rl_user_rules_b (
    RULE_ID                         NUMBER(18, 0) ,
    RULE_SET_ID                     NUMBER(18, 0)     NOT NULL,
    SEQUENCE                        NUMBER(18, 0)     NOT NULL,
    RULE_NAME                       VARCHAR2(120)     NOT NULL,
    RUN_ON                          VARCHAR2(120) ,
    RETURN_TYPE                     VARCHAR2(60)  ,
    TARGET_BUS_ENT                  VARCHAR2(160) ,
    TARGET_ATTR_GROUP_TYPE          VARCHAR2(120) ,
    TARGET_ATTR_GROUP_NAME          VARCHAR2(320) ,
    TARGET_ATTR_NAME                VARCHAR2(120) ,
    SEVERITY                        VARCHAR2(200) ,
    DEFAULT_CHANGE_ORDER_TYPE       VARCHAR2(120) ,
    ENFORCE_CHANGE_ORDER_TYPE       VARCHAR2(4)   ,
    MAX_NUM_ASSIGNED_ORGS           NUMBER(5, 0)  ,
    HAS_ALTERNATE_CATALOGS          VARCHAR2(4)       NOT NULL,
    HAS_CONTEXT_ATTRS               VARCHAR2(4)       NOT NULL,
    HAS_MULTIROW_ATTRS              VARCHAR2(4)       NOT NULL,
    HAS_VARIANT_ATTRS               VARCHAR2(4)       NOT NULL,
    HAS_STRUCT_ATTRS                VARCHAR2(4)       NOT NULL,
    HAS_ASSIGNED_TO_ORG_FUNC        VARCHAR2(4)   ,
    HAS_ASSIGNED_TO_CATALOG_FUNC    VARCHAR2(4)   ,
    HAS_CLASS_CHANGE_FUNCTION       VARCHAR2(4)       NOT NULL,
    HAS_EXISTS_FUNCTION             VARCHAR2(4)   ,
    HIDE_USER_MESSAGE               VARCHAR2(4)   ,
    RULE_XML                        CLOB              NOT NULL,
    GROOVY_SCRIPT                   CLOB          ,
    GROOVY_BYTES                    BLOB          ,
    VERSION                         VARCHAR2(40)  ,
    HAS_ABORT_VALIDATION            VARCHAR2(4)   ,
    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,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    PRIMARY_IF_EXPRESSION           VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION1        VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION2        VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION3        VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION4        VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION5        VARCHAR2(4000),
    VALIDATION_CONDITION            VARCHAR2(4000),
    SECONDARY_IF_RETURN_VALUE1      VARCHAR2(3200),
    SECONDARY_IF_RETURN_VALUE2      VARCHAR2(3200),
    SECONDARY_IF_RETURN_VALUE3      VARCHAR2(3200),
    SECONDARY_IF_RETURN_VALUE4      VARCHAR2(3200),
    SECONDARY_IF_RETURN_VALUE5      VARCHAR2(3200),
    RULE_ID                         NUMBER(18, 0) ,
    RULE_SET_ID                     NUMBER(18, 0)     NOT NULL,
    SEQUENCE                        NUMBER(18, 0)     NOT NULL,
    RULE_NAME                       VARCHAR2(120)     NOT NULL,
    RUN_ON                          VARCHAR2(120) ,
    RETURN_TYPE                     VARCHAR2(60)  ,
    TARGET_BUS_ENT                  VARCHAR2(160) ,
    TARGET_ATTR_GROUP_TYPE          VARCHAR2(120) ,
    TARGET_ATTR_GROUP_NAME          VARCHAR2(320) ,
    TARGET_ATTR_NAME                VARCHAR2(120) ,
    SEVERITY                        VARCHAR2(200) ,
    HAS_ALTERNATE_CATALOGS          VARCHAR2(4)       NOT NULL,
    HAS_CONTEXT_ATTRS               VARCHAR2(4)       NOT NULL,
    HAS_MULTIROW_ATTRS              VARCHAR2(4)       NOT NULL,
    HAS_VARIANT_ATTRS               VARCHAR2(4)       NOT NULL,
    HAS_STRUCT_ATTRS                VARCHAR2(4)       NOT NULL,
    HAS_ASSIGNED_TO_ORG_FUNC        VARCHAR2(4)   ,
    HAS_ASSIGNED_TO_CATALOG_FUNC    VARCHAR2(4)   ,
    HAS_CLASS_CHANGE_FUNCTION       VARCHAR2(4)       NOT NULL,
    HAS_EXISTS_FUNCTION             VARCHAR2(4)   ,
    RULE_XML                        CLOB              NOT NULL,
    GROOVY_SCRIPT                   CLOB          ,
    VERSION                         VARCHAR2(40)  ,
    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,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)      NOT NULL,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    HAS_ABORT_VALIDATION            VARCHAR2(4)   ,
    HIDE_USER_MESSAGE               VARCHAR2(4)   ,
    PRIMARY_IF_EXPRESSION           VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION1        VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION2        VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION3        VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION4        VARCHAR2(4000),
    SECONDARY_IF_EXPRESSION5        VARCHAR2(4000),
    VALIDATION_CONDITION            VARCHAR2(4000),
    SECONDARY_IF_RETURN_VALUE1      VARCHAR2(3200),
    SECONDARY_IF_RETURN_VALUE2      VARCHAR2(3200),
    SECONDARY_IF_RETURN_VALUE3      VARCHAR2(3200),
    SECONDARY_IF_RETURN_VALUE4      VARCHAR2(3200),
    SECONDARY_IF_RETURN_VALUE5      VARCHAR2(3200),
    DEFAULT_CHANGE_ORDER_TYPE       VARCHAR2(120) ,
    ENFORCE_CHANGE_ORDER_TYPE       VARCHAR2(4)   ,
    GROOVY_BYTES                    BLOB          ,
    MAX_NUM_ASSIGNED_ORGS           NUMBER(5, 0)  ,
    CONSTRAINT pk_ego_rl_user_rules_b PRIMARY KEY (RULE_ID, RULE_ID)
);
