[Home] [Help] [Dependency Information]
Object Name: | CZ_TEMPLATE_DEFS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CZ.CZ_TEMPLATE_DEFS_V |
Subobject Name: | |
Status: | VALID |
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 |
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;
APPS.CZ_TEMPLATE_DEFS_V is not referenced by any database object
|
|
|