[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CZ_RULES |
|---|---|
| Object Type: | TABLE |
| Owner: | CZ |
| FND Design Data: |  CZ.CZ_RULES
|
| Subobject Name: | |
| Status: | VALID |
This table is used to identify configuration Rules in Oracle Configurator. The rules can be logic or numeric rules, explicit compatibilities, property-based compatibilities, design charts, or functional companions.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
RULE_ID| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CZ_RULES_PK | NORMAL | UNIQUE |
APPS_TS_SEED
|
RULE_ID
|
| CZ_RULES_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
RULE_FOLDER_ID
DELETED_FLAG
RULE_ID
|
| SYS_IL0000032944C00043$$ | LOB | UNIQUE |
APPS_TS_SEED
|
|
| SYS_IL0000032944C00044$$ | LOB | UNIQUE |
APPS_TS_SEED
|
|
| CZ_RULES_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
REASON_ID
|
| CZ_RULES_N10 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
DELETED_FLAG
RULE_TYPE
SIGNATURE_ID
|
| CZ_RULES_N11 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
UI_DEF_ID
UI_PAGE_ID
UI_PAGE_ELEMENT_ID
|
| CZ_RULES_N12 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
UNSATISFIED_MSG_ID
DELETED_FLAG
|
| CZ_RULES_N13 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
EFFECTIVITY_SET_ID
|
| CZ_RULES_N2 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
COMPONENT_ID
|
| CZ_RULES_N3 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
CONSEQUENT_ID
|
| CZ_RULES_N4 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
ANTECEDENT_ID
|
| CZ_RULES_N5 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
AMOUNT_ID
|
| CZ_RULES_N6 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
GRID_ID
|
| CZ_RULES_N7 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
DEVL_PROJECT_ID
DELETED_FLAG
|
| CZ_RULES_N8 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
SUB_CONS_ID
|
| CZ_RULES_N9 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
DEVL_PROJECT_ID
COMPONENT_ID
RULE_TYPE
DELETED_FLAG
|
| CZ_RULES_NF1 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_SEED
|
UPPER("TEMPLATE_TOKEN")
|
| CZ_RULES_NF2 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_SEED
|
UPPER("NAME")
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RULE_ID | NUMBER | (9) | Yes | Associates this record with a modelling Rule |
| SUB_CONS_ID | NUMBER | (9) | UNUSED | |
| REASON_ID | NUMBER | (15) | Contains a reference to a CZ_LOCALIZED_TEXTS record containing a message to be presented to the user when this rule is violated | |
| AMOUNT_ID | NUMBER | (9) | UNUSED | |
| GRID_ID | NUMBER | (9) | Associates an Explicity Compatibility definition with this record | |
| RULE_FOLDER_ID | NUMBER | (9) | Yes | Locates this rule within a rule folder/sequence |
| DEVL_PROJECT_ID | NUMBER | (15) | Yes | Identifies the project/model associated with this record |
| INVALID_FLAG | VARCHAR2 | (1) | Yes | '1' indicates this rule is invalid; '0' indicates it is valid |
| DESC_TEXT | VARCHAR2 | (2000) | Descriptive text | |
| NAME | VARCHAR2 | (255) | The name of this object | |
| ANTECEDENT_ID | NUMBER | (9) | Identifies the expression that is the antecedent of this rule. | |
| CONSEQUENT_ID | NUMBER | (9) | This field specifies the expression that is the consequent of this rule. | |
| RULE_TYPE | NUMBER | (9) | Yes | 21 - Logic Rule; 22 - Numeric Rule; 23 - Compat Rule; 24 - Compat Table; 25 - Func Preselect; 26 - Func Validate; 27 - Comparison Rule; 28 - RULETYPE; 29 - Func Comp; 30 - Design Chart Rule |
| EXPR_RULE_TYPE | NUMBER | (9) | Describes the operation of this rule (logic, numeric, or comparison). 1 - 'Requires'; 2 - 'Implies'; 3 - 'Excludes'; 4 - 'Negates'; 5 - 'Defaults'; 6 - 'NumSelections'; 7 - 'Sets'; 8 - 'Contributes'; 9 - 'Supplies'; 10 -'Consumes' | |
| COMPONENT_ID | NUMBER | (15) | UNUSED | |
| REASON_TYPE | NUMBER | (9) | Indicates the type of message referenced by REASON_ID: 0 - Name of the rule; 1- a declarative statement; 2 - the description of the rule; 3 - custom rule type | |
| DISABLED_FLAG | VARCHAR2 | (1) | Yes | '1' indicates this rule is not to be used during runtime; default '0' indicates rule is active |
| ORIG_SYS_REF | VARCHAR2 | (255) | Holds the key information by which an imported record can be identified in its source database | |
| CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
| LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
| DELETED_FLAG | VARCHAR2 | (1) | Yes | Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved |
| EFF_FROM | DATE | UNUSED | ||
| EFF_TO | DATE | UNUSED | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that created this record |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that last updated this record |
| SECURITY_MASK | VARCHAR2 | (40) | UNUSED | |
| EFF_MASK | VARCHAR2 | (40) | UNUSED | |
| CHECKOUT_USER | VARCHAR2 | (40) | UNUSED | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Records the login ID under which this record was last updated | |
| EFFECTIVE_USAGE_MASK | VARCHAR2 | (16) | Yes | Hexadecimal-encoded bit map identifying Usages for which this record is INEFFECTIVE |
| SEQ_NBR | NUMBER | (9) | Yes | Provides an ordering among rules within a rule folder |
| EFFECTIVE_FROM | DATE | Date beginning on which this data is effective | ||
| EFFECTIVE_UNTIL | DATE | Date at which this data is no longer effective. Note this is EXCLUSIVE. | ||
| PERSISTENT_RULE_ID | NUMBER | (9) | Persistent ID (preserved in copies) of this rule | |
| EFFECTIVITY_SET_ID | NUMBER | (9) | Identifies the named effectivity set associated with this record | |
| RULE_FOLDER_TYPE | NUMBER | (9) | Indicates the type of rule folder in which this rule resides: 0 - standard rule folder; 1 - rule sequence. Denormalization from cz_rule_folders. Indicates whether this rule is in a standard rule folder or rule sequence. | |
| UNSATISFIED_MSG_ID | NUMBER | FK to CZ_LOCALIZED_TEXTS. Holds description of rule to be used in displaying a message about the rule being unsatisfied. | ||
| UNSATISFIED_MSG_SOURCE | VARCHAR2 | (1) | Indicates where the message text comes from -- rule name (1), rule description (2), custom (3) or none (0). | |
| SIGNATURE_ID | NUMBER | In case of TEMPLATE_DEFINITION this points to the signature definition of the template | ||
| TEMPLATE_PRIMITIVE_FLAG | VARCHAR2 | (1) | In case of TEMPLATE_DEFINITION this field specifies whether this template is a primitive template: | |
| PRESENTATION_FLAG | VARCHAR2 | (1) | Presentation form of the rule: | |
| TEMPLATE_TOKEN | VARCHAR2 | (30) | In case of TEMPLATE_DEFINITION this field stores the token of the template. In case of function-like templates, template_token=name. | |
| RULE_TEXT | CLOB | (4000) | Rule text (Corresponding to old cz_rule_texts.text) | |
| NOTES | CLOB | (4000) | Notes about rule | |
| CLASS_NAME | VARCHAR2 | (2000) | Fully qualified FC class name | |
| INSTANTIATION_SCOPE | NUMBER | FC rule instantiation scope | ||
| MODEL_REF_EXPL_ID | NUMBER | For FC rule | ||
| MUTABLE_FLAG | VARCHAR2 | (1) | Default value of '0'. | |
| SEEDED_FLAG | VARCHAR2 | (1) | Yes | '1' indicates this is a seeded expr node |
| 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) |
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
FROM CZ.CZ_RULES;
CZ.CZ_RULES does not reference any database object
CZ.CZ_RULES is referenced by following:
APPS
CZ_RULES
CZ_RULES_T1
CZ_RULES_T2
CZ_RULES_T3
CZ_RULES_TP1
|
|
|
|