[Home] [Help]
[Dependency Information]
[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#;
CZ
CZ_RULES
APPS
CZ_RULES
CZ_RULES+
CZ_RULES_T1
CZ_RULES_T2
CZ_RULES_T3
CZ_RULES_TP1
|
|
|
|