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_TEMPLATE_DEFS_V

Object Details

Object Name:	CZ_TEMPLATE_DEFS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_TEMPLATE_DEFS_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
SIGNATURE_ID	NUMBER			In case of TEMPLATE_DEFINITION this points to the signature definition of the template
NAME	VARCHAR2	(255)		The name of this object
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.
DESC_TEXT	VARCHAR2	(2000)		Descriptive text
RULE_TEXT	CLOB	(4000)		Rule text (Corresponding to old cz_rule_texts.text)
TEMPLATE_PRIMITIVE_FLAG	VARCHAR2	(1)		In case of TEMPLATE_DEFINITION this field specifies whether this template is a primitive template:
INVALID_FLAG	VARCHAR2	(1)	Yes	'1' indicates this rule is invalid; '0' indicates it is valid
PRESENTATION_FLAG	VARCHAR2	(1)		Presentation form of the rule:
NOTES	CLOB	(4000)		Notes about rule
SEQ_NBR	NUMBER	(9)	Yes
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
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
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).
DISABLED_FLAG	VARCHAR2	(1)	Yes	'1' indicates this rule is not to be used during runtime; default '0' indicates rule is active
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
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
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
SEEDED_FLAG	VARCHAR2	(1)	Yes	'1' indicates this is a seeded expr node
P_MODEL_ID	NUMBER	(15)	Yes

Query Text

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


SELECT RULE_ID
,      SIGNATURE_ID
,      NAME
,      TEMPLATE_TOKEN
,      DESC_TEXT
,      RULE_TEXT
,      TEMPLATE_PRIMITIVE_FLAG
,      INVALID_FLAG
,      PRESENTATION_FLAG
,      NOTES
,      SEQ_NBR
,      REASON_ID
,      REASON_TYPE
,      UNSATISFIED_MSG_ID
,      UNSATISFIED_MSG_SOURCE
,      DISABLED_FLAG
,      RULE_TYPE
,      RULE_FOLDER_ID
,      DEVL_PROJECT_ID
,      DELETED_FLAG
,      SEEDED_FLAG
,      P_MODEL_ID
FROM APPS.CZ_TEMPLATE_DEFS_V;

Dependencies

[top of page]

APPS.CZ_TEMPLATE_DEFS_V references the following:

APPS: CZ_DEVL_PROJECTS; CZ_LOOKUP_VALUES; CZ_RULES; CZ_TYPE_RELATIONSHIPS

APPS.CZ_TEMPLATE_DEFS_V is not referenced by any database object