EGO_RL_USER_RULES_VL

Details

• Schema: FUSION

• Object owner: EGO

• Object type: VIEW

Columns

Name

RULE_ID RULE_SET_ID SEQUENCE RULE_NAME DESCRIPTION RUN_ON RETURN_TYPE TARGET_BUS_ENT TARGET_ATTR_GROUP_TYPE TARGET_ATTR_GROUP_NAME TARGET_ATTR_NAME SEVERITY DEFAULT_CHANGE_ORDER_TYPE ENFORCE_CHANGE_ORDER_TYPE MAX_NUM_ASSIGNED_ORGS HAS_ALTERNATE_CATALOGS HAS_CONTEXT_ATTRS HAS_MULTIROW_ATTRS HAS_VARIANT_ATTRS HAS_STRUCT_ATTRS HAS_ASSIGNED_TO_ORG_FUNC HAS_ASSIGNED_TO_CATALOG_FUNC HAS_CLASS_CHANGE_FUNCTION HAS_EXISTS_FUNCTION HIDE_USER_MESSAGE VERSION RULE_XML GROOVY_SCRIPT GROOVY_BYTES USER_EXPLANATION_MESSAGE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY OBJECT_VERSION_NUMBER LAST_UPDATE_LOGIN HAS_ABORT_VALIDATION PRIMARY_IF_EXPRESSION SECONDARY_IF_EXPRESSION1 SECONDARY_IF_EXPRESSION2 SECONDARY_IF_EXPRESSION3 SECONDARY_IF_EXPRESSION4 SECONDARY_IF_EXPRESSION5 VALIDATION_CONDITION SECONDARY_IF_RETURN_VALUE1 SECONDARY_IF_RETURN_VALUE2 SECONDARY_IF_RETURN_VALUE3 SECONDARY_IF_RETURN_VALUE4 SECONDARY_IF_RETURN_VALUE5 USER_MESSAGE

Query

SQL_Statement

SELECT EGO_RL_USER_RULES_B.RULE_ID RULE_ID, EGO_RL_USER_RULES_B.RULE_SET_ID RULE_SET_ID, EGO_RL_USER_RULES_B.SEQUENCE SEQUENCE, EGO_RL_USER_RULES_B.RULE_NAME RULE_NAME, EGO_RL_USER_RULES_TL.DESCRIPTION DESCRIPTION, EGO_RL_USER_RULES_B.RUN_ON RUN_ON, EGO_RL_USER_RULES_B.RETURN_TYPE RETURN_TYPE, EGO_RL_USER_RULES_B.TARGET_BUS_ENT TARGET_BUS_ENT, EGO_RL_USER_RULES_B.TARGET_ATTR_GROUP_TYPE TARGET_ATTR_GROUP_TYPE, EGO_RL_USER_RULES_B.TARGET_ATTR_GROUP_NAME TARGET_ATTR_GROUP_NAME, EGO_RL_USER_RULES_B.TARGET_ATTR_NAME TARGET_ATTR_NAME, EGO_RL_USER_RULES_B.SEVERITY SEVERITY, EGO_RL_USER_RULES_B.DEFAULT_CHANGE_ORDER_TYPE, EGO_RL_USER_RULES_B.ENFORCE_CHANGE_ORDER_TYPE, EGO_RL_USER_RULES_B.MAX_NUM_ASSIGNED_ORGS, EGO_RL_USER_RULES_B.HAS_ALTERNATE_CATALOGS HAS_ALTERNATE_CATALOGS, EGO_RL_USER_RULES_B.HAS_CONTEXT_ATTRS HAS_CONTEXT_ATTRS, EGO_RL_USER_RULES_B.HAS_MULTIROW_ATTRS HAS_MULTIROW_ATTRS, EGO_RL_USER_RULES_B.HAS_VARIANT_ATTRS HAS_VARIANT_ATTRS, EGO_RL_USER_RULES_B.HAS_STRUCT_ATTRS HAS_STRUCT_ATTRS, EGO_RL_USER_RULES_B.HAS_ASSIGNED_TO_ORG_FUNC HAS_ASSIGNED_TO_ORG_FUNC, EGO_RL_USER_RULES_B.HAS_ASSIGNED_TO_CATALOG_FUNC HAS_ASSIGNED_TO_CATALOG_FUNC, EGO_RL_USER_RULES_B.HAS_CLASS_CHANGE_FUNCTION, EGO_RL_USER_RULES_B.HAS_EXISTS_FUNCTION HAS_EXISTS_FUNCTION, EGO_RL_USER_RULES_B.HIDE_USER_MESSAGE, EGO_RL_USER_RULES_B.VERSION VERSION, EGO_RL_USER_RULES_B.RULE_XML RULE_XML, EGO_RL_USER_RULES_B.GROOVY_SCRIPT GROOVY_SCRIPT, EGO_RL_USER_RULES_B.GROOVY_BYTES GROOVY_BYTES, EGO_RL_USER_RULES_TL.USER_EXPLANATION_MESSAGE USER_EXPLANATION_MESSAGE, EGO_RL_USER_RULES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, EGO_RL_USER_RULES_B.LAST_UPDATED_BY LAST_UPDATED_BY, EGO_RL_USER_RULES_B.CREATION_DATE CREATION_DATE, EGO_RL_USER_RULES_B.CREATED_BY CREATED_BY, EGO_RL_USER_RULES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, EGO_RL_USER_RULES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EGO_RL_USER_RULES_B.HAS_ABORT_VALIDATION HAS_ABORT_VALIDATION, EGO_RL_USER_RULES_B.PRIMARY_IF_EXPRESSION PRIMARY_IF_EXPRESSION, EGO_RL_USER_RULES_B.SECONDARY_IF_EXPRESSION1 SECONDARY_IF_EXPRESSION1, EGO_RL_USER_RULES_B.SECONDARY_IF_EXPRESSION2 SECONDARY_IF_EXPRESSION2, EGO_RL_USER_RULES_B.SECONDARY_IF_EXPRESSION3 SECONDARY_IF_EXPRESSION3, EGO_RL_USER_RULES_B.SECONDARY_IF_EXPRESSION4 SECONDARY_IF_EXPRESSION4, EGO_RL_USER_RULES_B.SECONDARY_IF_EXPRESSION5 SECONDARY_IF_EXPRESSION5, EGO_RL_USER_RULES_B.VALIDATION_CONDITION VALIDATION_CONDITION, EGO_RL_USER_RULES_B.SECONDARY_IF_RETURN_VALUE1 SECONDARY_IF_RETURN_VALUE1, EGO_RL_USER_RULES_B.SECONDARY_IF_RETURN_VALUE2 SECONDARY_IF_RETURN_VALUE2, EGO_RL_USER_RULES_B.SECONDARY_IF_RETURN_VALUE3 SECONDARY_IF_RETURN_VALUE3, EGO_RL_USER_RULES_B.SECONDARY_IF_RETURN_VALUE4 SECONDARY_IF_RETURN_VALUE4, EGO_RL_USER_RULES_B.SECONDARY_IF_RETURN_VALUE5 SECONDARY_IF_RETURN_VALUE5, EGO_RL_USER_RULES_TL.USER_MESSAGE USER_MESSAGE FROM EGO_RL_USER_RULES_B, EGO_RL_USER_RULES_TL WHERE EGO_RL_USER_RULES_B.RULE_ID = EGO_RL_USER_RULES_TL.RULE_ID AND EGO_RL_USER_RULES_TL.LANGUAGE = USERENV('LANG')