eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CZ.CZ_RULES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_RULES_PK

RULE_ID

Indexes

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")

Columns

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)

Query Text

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;

Dependencies

[top of page]

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