[Home] [Help] [Dependency Information]
Object Name: | CZ_IMP_RULES# |
---|---|
Object Type: | VIEW |
Owner: | CZ |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | (9) | ||
SUB_CONS_ID | NUMBER | (9) | ||
REASON_ID | NUMBER | (15) | ||
AMOUNT_ID | NUMBER | (9) | ||
GRID_ID | NUMBER | (9) | ||
RULE_FOLDER_ID | NUMBER | (9) | ||
DEVL_PROJECT_ID | NUMBER | (15) | ||
INVALID_FLAG | VARCHAR2 | (1) | ||
DESC_TEXT | VARCHAR2 | (2000) | ||
NAME | VARCHAR2 | (255) | ||
ANTECEDENT_ID | NUMBER | (9) | ||
CONSEQUENT_ID | NUMBER | (9) | ||
RULE_TYPE | NUMBER | (9) | ||
EXPR_RULE_TYPE | NUMBER | (9) | ||
COMPONENT_ID | NUMBER | (15) | ||
REASON_TYPE | NUMBER | (9) | ||
DISABLED_FLAG | VARCHAR2 | (1) | ||
ORIG_SYS_REF | VARCHAR2 | (255) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
DELETED_FLAG | VARCHAR2 | (1) | ||
EFF_FROM | DATE | |||
EFF_TO | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
SECURITY_MASK | VARCHAR2 | (40) | ||
EFF_MASK | VARCHAR2 | (40) | ||
CHECKOUT_USER | VARCHAR2 | (40) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
EFFECTIVE_USAGE_MASK | VARCHAR2 | (16) | ||
SEQ_NBR | NUMBER | (9) | ||
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) | ||
UI_DEF_ID | NUMBER | |||
UI_PAGE_ID | NUMBER | |||
UI_PAGE_ELEMENT_ID | VARCHAR2 | (255) | ||
MESSAGE | VARCHAR2 | (2000) | ||
RUN_ID | NUMBER | |||
DISPOSITION | VARCHAR2 | (1) | ||
REC_STATUS | VARCHAR2 | (4) | ||
FSK_DEVL_PROJECT | VARCHAR2 | (255) | ||
FSK_LOCALIZED_TEXT_1 | VARCHAR2 | (255) | ||
FSK_LOCALIZED_TEXT_2 | VARCHAR2 | (255) | ||
IMPORT_PROG_VERSION | NUMBER | |||
FSK_COMPONENT_ID | VARCHAR2 | (255) | ||
FSK_MODEL_REF_EXPL_ID | VARCHAR2 | (4000) | ||
RULE_CLASS | NUMBER | (15) | ||
CLASS_SEQ | NUMBER | (15) | ||
ACCUMULATOR_FLAG | VARCHAR2 | (1) | ||
TOP_LEVEL_CONSTRAINT_FLAG | VARCHAR2 | (1) | ||
CONFIG_ENGINE_TYPE | VARCHAR2 | (1) |
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
, MESSAGE
, RUN_ID
, DISPOSITION
, REC_STATUS
, FSK_DEVL_PROJECT
, FSK_LOCALIZED_TEXT_1
, FSK_LOCALIZED_TEXT_2
, IMPORT_PROG_VERSION
, FSK_COMPONENT_ID
, FSK_MODEL_REF_EXPL_ID
, RULE_CLASS
, CLASS_SEQ
, ACCUMULATOR_FLAG
, TOP_LEVEL_CONSTRAINT_FLAG
, CONFIG_ENGINE_TYPE
FROM CZ.CZ_IMP_RULES#;
|
|
|