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]

VIEW: APPS.CZ_TYPED_RULES_V

Object Details

Object Name:	CZ_TYPED_RULES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_TYPED_RULES_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RULE_ID	NUMBER	(9)	Yes	Associates this record with a modelling 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
DETAILED_RULE_TYPE	NUMBER
RULETYPE_DATATYPE	NUMBER
PERSISTENT_RULE_ID	NUMBER	(9)		Persistent ID (preserved in copies) of this rule
EXPR_ROOT_RULE_TEMPLATE_ID	NUMBER
RULE_TYPE_CODE	VARCHAR2	(255)
RULE_TYPE_LABEL	VARCHAR2	(255)
RULE_TYPE_DESCRIPTION	VARCHAR2	(4000)
RULE_NAME	VARCHAR2	(255)		The name of this object
RULE_DESCRIPTION	VARCHAR2	(2000)		Descriptive text
DEVL_PROJECT_ID	NUMBER	(15)	Yes	Identifies the project/model associated with this record
RULE_FOLDER_ID	NUMBER	(9)	Yes	Locates this rule within a rule folder/sequence
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.
SEQ_NBR	NUMBER	(9)	Yes	Provides an ordering among rules within a rule folder
SIGNATURE_ID	NUMBER			In case of TEMPLATE_DEFINITION this points to the signature definition of the template
MUTABLE_FLAG	VARCHAR2	(1)		Default value of '0'.
TEMPLATE_PRIMITIVE_FLAG	VARCHAR2	(30)		In case of TEMPLATE_DEFINITION this field specifies whether this template is a primitive template:
TEMPLATE_TOKEN	VARCHAR2	(1)		In case of TEMPLATE_DEFINITION this field stores the token of the template. In case of function-like templates, template_token=name.
PRESENTATION_FLAG	VARCHAR2	(1)		Presentation form of the rule:
RULE_TEXT	CHAR	(1)
COMPONENT_ID	NUMBER	(15)		UNUSED
MODEL_REF_EXPL_ID	NUMBER			For FC rule
NOTES	CHAR	(2)
CLASS_NAME	VARCHAR2	(2000)		Fully qualified FC class name
INSTANTIATION_SCOPE	NUMBER			FC rule instantiation scope
REASON_TYPE	NUMBER	(15)		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
REASON_ID	NUMBER	(9)		Contains a reference to a CZ_LOCALIZED_TEXTS record containing a message to be presented to the user when this rule is violated
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).
SEEDED_FLAG	VARCHAR2	(1)	Yes	'1' indicates this is a seeded expr node
INVALID_FLAG	VARCHAR2	(1)	Yes	'1' indicates this rule is invalid; '0' indicates it is valid
DISABLED_FLAG	VARCHAR2	(1)	Yes	'1' indicates this rule is not to be used during runtime; default '0' indicates rule is active
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.
EFFECTIVE_USAGE_MASK	VARCHAR2	(16)	Yes	Hexadecimal-encoded bit map identifying Usages for which this record is INEFFECTIVE
EFFECTIVITY_SET_ID	NUMBER	(9)		Identifies the named effectivity set associated with this record
CHECKOUT_USER	VARCHAR2	(40)		UNUSED
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
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Records the login ID under which this record was last updated
EXPR_NODE_ID	NUMBER
EXPR_TYPE	NUMBER	(9)
RULE_CLASS	NUMBER
CLASS_SEQ	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_ID
,      RULE_TYPE
,      DETAILED_RULE_TYPE
,      RULETYPE_DATATYPE
,      PERSISTENT_RULE_ID
,      EXPR_ROOT_RULE_TEMPLATE_ID
,      RULE_TYPE_CODE
,      RULE_TYPE_LABEL
,      RULE_TYPE_DESCRIPTION
,      RULE_NAME
,      RULE_DESCRIPTION
,      DEVL_PROJECT_ID
,      RULE_FOLDER_ID
,      RULE_FOLDER_TYPE
,      SEQ_NBR
,      SIGNATURE_ID
,      MUTABLE_FLAG
,      TEMPLATE_PRIMITIVE_FLAG
,      TEMPLATE_TOKEN
,      PRESENTATION_FLAG
,      RULE_TEXT
,      COMPONENT_ID
,      MODEL_REF_EXPL_ID
,      NOTES
,      CLASS_NAME
,      INSTANTIATION_SCOPE
,      REASON_TYPE
,      REASON_ID
,      UNSATISFIED_MSG_ID
,      UNSATISFIED_MSG_SOURCE
,      SEEDED_FLAG
,      INVALID_FLAG
,      DISABLED_FLAG
,      EFFECTIVE_FROM
,      EFFECTIVE_UNTIL
,      EFFECTIVE_USAGE_MASK
,      EFFECTIVITY_SET_ID
,      CHECKOUT_USER
,      ORIG_SYS_REF
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EXPR_NODE_ID
,      EXPR_TYPE
,      RULE_CLASS
,      CLASS_SEQ
FROM APPS.CZ_TYPED_RULES_V;

Dependencies

[top of page]

APPS.CZ_TYPED_RULES_V references the following:

APPS: CZ_DETAILEDRULETYPES_LKV; CZ_RULE_EXPRDETLS_V

APPS.CZ_TYPED_RULES_V is referenced by following:

APPS: CZ_MODEL_ALL_RULEFOLDERS_V; CZ_PSN_TYPED_RULE_REFS_V