VIEW: CZ.CZ_RULES#

Source

View Text - Preformatted

select RULE_ID RULE_ID, SUB_CONS_ID SUB_CONS_ID, REASON_ID REASON_ID, AMOUNT_ID AMOUNT_ID, GRID_ID GRID_ID, RULE_FOLDER_ID RULE_FOLDER_ID, DEVL_PROJECT_ID DEVL_PROJECT_ID, INVALID_FLAG INVALID_FLAG, DESC_TEXT DESC_TEXT, NAME NAME, ANTECEDENT_ID ANTECEDENT_ID, CONSEQUENT_ID CONSEQUENT_ID, RULE_TYPE RULE_TYPE, EXPR_RULE_TYPE EXPR_RULE_TYPE, COMPONENT_ID COMPONENT_ID, REASON_TYPE REASON_TYPE, DISABLED_FLAG DISABLED_FLAG, ORIG_SYS_REF ORIG_SYS_REF, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, EFF_MASK EFF_MASK, CHECKOUT_USER CHECKOUT_USER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EFFECTIVE_USAGE_MASK EFFECTIVE_USAGE_MASK, SEQ_NBR SEQ_NBR, EFFECTIVE_FROM EFFECTIVE_FROM, EFFECTIVE_UNTIL EFFECTIVE_UNTIL, PERSISTENT_RULE_ID PERSISTENT_RULE_ID, EFFECTIVITY_SET_ID EFFECTIVITY_SET_ID, RULE_FOLDER_TYPE RULE_FOLDER_TYPE, UNSATISFIED_MSG_ID UNSATISFIED_MSG_ID, UNSATISFIED_MSG_SOURCE UNSATISFIED_MSG_SOURCE, SIGNATURE_ID SIGNATURE_ID, TEMPLATE_PRIMITIVE_FLAG TEMPLATE_PRIMITIVE_FLAG, PRESENTATION_FLAG PRESENTATION_FLAG, TEMPLATE_TOKEN TEMPLATE_TOKEN, RULE_TEXT RULE_TEXT, NOTES NOTES, CLASS_NAME CLASS_NAME, INSTANTIATION_SCOPE INSTANTIATION_SCOPE, MODEL_REF_EXPL_ID MODEL_REF_EXPL_ID, MUTABLE_FLAG MUTABLE_FLAG, SEEDED_FLAG SEEDED_FLAG, UI_DEF_ID UI_DEF_ID, UI_PAGE_ID UI_PAGE_ID, UI_PAGE_ELEMENT_ID UI_PAGE_ELEMENT_ID, INSTANCE_SET_FLAG INSTANCE_SET_FLAG, CONFIG_ENGINE_TYPE CONFIG_ENGINE_TYPE, CLASS_SEQ CLASS_SEQ, ACCUMULATOR_FLAG ACCUMULATOR_FLAG, RULE_CLASS RULE_CLASS, TOP_LEVEL_CONSTRAINT_FLAG TOP_LEVEL_CONSTRAINT_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "CZ"."CZ_RULES"

View Text - HTML Formatted

SELECT RULE_ID RULE_ID
, SUB_CONS_ID SUB_CONS_ID
, REASON_ID REASON_ID
, AMOUNT_ID AMOUNT_ID
, GRID_ID GRID_ID
, RULE_FOLDER_ID RULE_FOLDER_ID
, DEVL_PROJECT_ID DEVL_PROJECT_ID
, INVALID_FLAG INVALID_FLAG
, DESC_TEXT DESC_TEXT
, NAME NAME
, ANTECEDENT_ID ANTECEDENT_ID
, CONSEQUENT_ID CONSEQUENT_ID
, RULE_TYPE RULE_TYPE
, EXPR_RULE_TYPE EXPR_RULE_TYPE
, COMPONENT_ID COMPONENT_ID
, REASON_TYPE REASON_TYPE
, DISABLED_FLAG DISABLED_FLAG
, ORIG_SYS_REF ORIG_SYS_REF
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, EFF_MASK EFF_MASK
, CHECKOUT_USER CHECKOUT_USER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EFFECTIVE_USAGE_MASK EFFECTIVE_USAGE_MASK
, SEQ_NBR SEQ_NBR
, EFFECTIVE_FROM EFFECTIVE_FROM
, EFFECTIVE_UNTIL EFFECTIVE_UNTIL
, PERSISTENT_RULE_ID PERSISTENT_RULE_ID
, EFFECTIVITY_SET_ID EFFECTIVITY_SET_ID
, RULE_FOLDER_TYPE RULE_FOLDER_TYPE
, UNSATISFIED_MSG_ID UNSATISFIED_MSG_ID
, UNSATISFIED_MSG_SOURCE UNSATISFIED_MSG_SOURCE
, SIGNATURE_ID SIGNATURE_ID
, TEMPLATE_PRIMITIVE_FLAG TEMPLATE_PRIMITIVE_FLAG
, PRESENTATION_FLAG PRESENTATION_FLAG
, TEMPLATE_TOKEN TEMPLATE_TOKEN
, RULE_TEXT RULE_TEXT
, NOTES NOTES
, CLASS_NAME CLASS_NAME
, INSTANTIATION_SCOPE INSTANTIATION_SCOPE
, MODEL_REF_EXPL_ID MODEL_REF_EXPL_ID
, MUTABLE_FLAG MUTABLE_FLAG
, SEEDED_FLAG SEEDED_FLAG
, UI_DEF_ID UI_DEF_ID
, UI_PAGE_ID UI_PAGE_ID
, UI_PAGE_ELEMENT_ID UI_PAGE_ELEMENT_ID
, INSTANCE_SET_FLAG INSTANCE_SET_FLAG
, CONFIG_ENGINE_TYPE CONFIG_ENGINE_TYPE
, CLASS_SEQ CLASS_SEQ
, ACCUMULATOR_FLAG ACCUMULATOR_FLAG
, RULE_CLASS RULE_CLASS
, TOP_LEVEL_CONSTRAINT_FLAG TOP_LEVEL_CONSTRAINT_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "CZ"."CZ_RULES"