[Home] [Help] [Dependency Information]
Object Name: | CZ_RULES# |
---|---|
Object Type: | VIEW |
Owner: | CZ |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | (9) | Yes | |
SUB_CONS_ID | NUMBER | (9) | ||
REASON_ID | NUMBER | (15) | ||
AMOUNT_ID | NUMBER | (9) | ||
GRID_ID | NUMBER | (9) | ||
RULE_FOLDER_ID | NUMBER | (9) | Yes | |
DEVL_PROJECT_ID | NUMBER | (15) | Yes | |
INVALID_FLAG | VARCHAR2 | (1) | Yes | |
DESC_TEXT | VARCHAR2 | (2000) | ||
NAME | VARCHAR2 | (255) | ||
ANTECEDENT_ID | NUMBER | (9) | ||
CONSEQUENT_ID | NUMBER | (9) | ||
RULE_TYPE | NUMBER | (9) | Yes | |
EXPR_RULE_TYPE | NUMBER | (9) | ||
COMPONENT_ID | NUMBER | (15) | ||
REASON_TYPE | NUMBER | (9) | ||
DISABLED_FLAG | VARCHAR2 | (1) | Yes | |
ORIG_SYS_REF | VARCHAR2 | (255) | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
DELETED_FLAG | VARCHAR2 | (1) | Yes | |
EFF_FROM | DATE | |||
EFF_TO | DATE | |||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
SECURITY_MASK | VARCHAR2 | (40) | ||
EFF_MASK | VARCHAR2 | (40) | ||
CHECKOUT_USER | VARCHAR2 | (40) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
EFFECTIVE_USAGE_MASK | VARCHAR2 | (16) | Yes | |
SEQ_NBR | NUMBER | (9) | Yes | |
EFFECTIVE_FROM | DATE | |||
EFFECTIVE_UNTIL | DATE | |||
PERSISTENT_RULE_ID | NUMBER | (9) | ||
EFFECTIVITY_SET_ID | NUMBER | (9) | ||
RULE_FOLDER_TYPE | NUMBER | (9) | ||
UNSATISFIED_MSG_ID | NUMBER | |||
UNSATISFIED_MSG_SOURCE | VARCHAR2 | (1) | ||
SIGNATURE_ID | NUMBER | |||
TEMPLATE_PRIMITIVE_FLAG | VARCHAR2 | (1) | ||
PRESENTATION_FLAG | VARCHAR2 | (1) | ||
TEMPLATE_TOKEN | VARCHAR2 | (30) | ||
RULE_TEXT | CLOB | (4000) | ||
NOTES | CLOB | (4000) | ||
CLASS_NAME | VARCHAR2 | (2000) | ||
INSTANTIATION_SCOPE | NUMBER | |||
MODEL_REF_EXPL_ID | NUMBER | |||
MUTABLE_FLAG | VARCHAR2 | (1) | ||
SEEDED_FLAG | VARCHAR2 | (1) | Yes | |
UI_DEF_ID | NUMBER | |||
UI_PAGE_ID | NUMBER | |||
UI_PAGE_ELEMENT_ID | VARCHAR2 | (255) | ||
INSTANCE_SET_FLAG | VARCHAR2 | (1) | ||
CONFIG_ENGINE_TYPE | VARCHAR2 | (1) | ||
CLASS_SEQ | NUMBER | |||
ACCUMULATOR_FLAG | VARCHAR2 | (1) | ||
RULE_CLASS | NUMBER | |||
TOP_LEVEL_CONSTRAINT_FLAG | VARCHAR2 | (1) | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, SUB_CONS_ID
, REASON_ID
, AMOUNT_ID
, GRID_ID
, RULE_FOLDER_ID
, DEVL_PROJECT_ID
, INVALID_FLAG
, DESC_TEXT
, NAME
, ANTECEDENT_ID
, CONSEQUENT_ID
, RULE_TYPE
, EXPR_RULE_TYPE
, COMPONENT_ID
, REASON_TYPE
, DISABLED_FLAG
, ORIG_SYS_REF
, CREATION_DATE
, LAST_UPDATE_DATE
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, EFF_MASK
, CHECKOUT_USER
, LAST_UPDATE_LOGIN
, EFFECTIVE_USAGE_MASK
, SEQ_NBR
, EFFECTIVE_FROM
, EFFECTIVE_UNTIL
, PERSISTENT_RULE_ID
, EFFECTIVITY_SET_ID
, RULE_FOLDER_TYPE
, UNSATISFIED_MSG_ID
, UNSATISFIED_MSG_SOURCE
, SIGNATURE_ID
, TEMPLATE_PRIMITIVE_FLAG
, PRESENTATION_FLAG
, TEMPLATE_TOKEN
, RULE_TEXT
, NOTES
, CLASS_NAME
, INSTANTIATION_SCOPE
, MODEL_REF_EXPL_ID
, MUTABLE_FLAG
, SEEDED_FLAG
, UI_DEF_ID
, UI_PAGE_ID
, UI_PAGE_ELEMENT_ID
, INSTANCE_SET_FLAG
, CONFIG_ENGINE_TYPE
, CLASS_SEQ
, ACCUMULATOR_FLAG
, RULE_CLASS
, TOP_LEVEL_CONSTRAINT_FLAG
, ZD_EDITION_NAME
FROM CZ.CZ_RULES#;
|
|
|