[Home] [Help] [Dependency Information]
Object Name: | CZ_EXPRESSION_NODES |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_EXPRESSION_NODES |
Subobject Name: | |
Status: | VALID |
This table describes each node in an expression used in a Configurator product model.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_EXPRESSION_NODES_PK | NORMAL | UNIQUE | APPS_TS_SEED | EXPR_NODE_ID |
CZ_EXPRESSION_NODES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
EXPR_PARENT_ID
EXPR_NODE_ID |
CZ_EXPRESSION_NODES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | ITEM_TYPE_ID |
CZ_EXPRESSION_NODES_N10 | NORMAL | NONUNIQUE | APPS_TS_SEED |
RULE_ID
DELETED_FLAG EXPR_PARENT_ID TEMPLATE_ID |
CZ_EXPRESSION_NODES_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | ITEM_ID |
CZ_EXPRESSION_NODES_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | FILTER_SET_ID |
CZ_EXPRESSION_NODES_N4 | NORMAL | NONUNIQUE | APPS_TS_SEED | PS_NODE_ID |
CZ_EXPRESSION_NODES_N5 | NORMAL | NONUNIQUE | APPS_TS_SEED | GRID_COL_ID |
CZ_EXPRESSION_NODES_N6 | NORMAL | NONUNIQUE | APPS_TS_SEED | PROPERTY_ID |
CZ_EXPRESSION_NODES_N8 | NORMAL | NONUNIQUE | APPS_TS_SEED |
EXPRESS_ID
EXPR_PARENT_ID |
CZ_EXPRESSION_NODES_N9 | NORMAL | NONUNIQUE | APPS_TS_SEED |
RULE_ID
EXPR_NODE_ID DELETED_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_LOGIN | NUMBER | Records the login ID under which this record was last updated | ||
EXPR_NODE_ID | NUMBER | Yes | Provide the unique identity of this expression node | |
EXPRESS_ID | NUMBER | (9) | Identifies the Expression associated with this record | |
SEQ_NBR | NUMBER | (9) | Yes | Provides an ordering among associated records |
ITEM_TYPE_ID | NUMBER | (9) | ID of the item type associated with this record | |
PS_NODE_ID | NUMBER | (15) | Associates this record with a Model structure node ('psnode') | |
ITEM_ID | NUMBER | (9) | Associates an Item Master record with this record | |
FILTER_SET_ID | NUMBER | (9) | Identifies the Filter Set associated with this record | |
GRID_COL_ID | NUMBER | (9) | Associates an Explicit Compatibility column with this record | |
EXPR_PARENT_ID | NUMBER | (9) | Identifies the parent expression-node of this record | |
PROPERTY_ID | NUMBER | (9) | Associates this record with a Property | |
COMPILE_ADVICE | NUMBER | (9) | UNUSED | |
COL | NUMBER | (9) | UNUSED | |
DATA_VALUE | VARCHAR2 | (255) | Holds a value for this node when expression node is of a literal-value type | |
FIELD_NAME | VARCHAR2 | (80) | When expression node is of type 'field name', this field holds that field name | |
EXPR_TYPE | NUMBER | (9) | Yes | Primary type of this expression node: 200 - Operator; 201 - Literal; 202 - Field Name; 203 - Column; 204 - Feature Prop; 205 - Node; 206 - Set; 207 - Property; 208 - Punctuation; 209 - Component Count; 210 - System Property |
EXPR_SUBTYPE | NUMBER | (9) | Exact function of this expression node, coded. For operators: 300 - Begins With; 301 - Ends With; 302 - Is Child Of; 303 - Contains; 304 - Matches; 305 - Belongs To Type; 306 - Any Of; 307 - All Of; 308 - Products In; 309 - Components Of; 310 - Feature-Groups Of; 311 - Features Of; 312 - Options Of; 313 - Totals Of; 314 - Resources Of; 315 - Is Of Type; 316 - And; 317 - Or; 318 - Equals; 319 - Each Of; 320 - Not Equals; 321 - Minimum; 322 - Maximum; 323 - Truncate; 324 - Children Of; 325 - Value of; 326 - Dot (dereference); 350 - Greater Than; 351 - Less Than; 352 - Greater Than or Equal; 353 - Less Than or Equal; 360 - Not True; 399 - None; 401 - Add; 402 - Subtract; 403 - Multiply; 404 - Divide; 405 - Ceiling; 406 - Floor; 407 - Round; 1000 - Not. For component counts: 0 - minimum; 1 - maximum; 3 - count. For punctuation: 0 - left parenthesis; 1 - right parenthesis; 2 - comma. For system properties: 1 - name; 2 - selection; 3 - count; 4 - minimum; 5 - maximum. For Literals, indicates data type applicable to DATA_VALUE field: 1 - Integer; 2 - Floating-point; 3 - boolean; 4 - string. | |
TOKEN_LIST_SEQ | NUMBER | (9) | Provides an ordering sequence of expression nodes according to their sequence in an unparsed expression | |
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 | |
CONSEQUENT_FLAG | VARCHAR2 | (1) | When '1', indicates this expression node participates in a consequent expression | |
MODEL_REF_EXPL_ID | NUMBER | (9) | Associates this record with a model-reference explosion node in the current model | |
RULE_ID | NUMBER | Yes | FK to CZ_RULES | |
TEMPLATE_ID | NUMBER | Stores the template ID when expr_type = EXPR_TEMPLATE. Used either when the root of a template application or when the value of an argument of type DATA_SIGNATURE | ||
ARGUMENT_SIGNATURE_ID | NUMBER | Semantic extension: stores event-specific argument signature info when expr_type = EXPR_EVENT_ARGUMENT in an event binding | ||
ARGUMENT_INDEX | NUMBER | Stores the argument index when expr_type = EXPR_ARGUMENT in a template definition | ||
PARAM_SIGNATURE_ID | NUMBER | Semantic extension: stores signature info of the java argument being used in an event binding | ||
PARAM_INDEX | NUMBER | Denormalized argument_index from the template parameter being used in a template application | ||
ARGUMENT_NAME | VARCHAR2 | (2000) | Stores the name of the argument when expr_type = EXPR_ARGUMENT in a template definition or a ForAll construct | |
DATA_TYPE | NUMBER | This field is a FK to a record in CZ_SIGNATURES that defines the return data type of this expression node. The 'implementation' type of the exprnode (EXPR_TYPE) must support the DATA_TYPE | ||
DISPLAY_NODE_DEPTH | NUMBER | iF EXPR_TYPE=REFNODE, this field specifies the depth of the compound reference from which this refnode was created; in 'unparse'/display, that many parent nodes must be displayed | ||
COLLECTION_FLAG | VARCHAR2 | (1) | Denormalization | |
SOURCE_OFFSET | NUMBER | For a freeform rule, stores the starting location in the text for this node. | ||
SOURCE_LENGTH | NUMBER | For a freeform rule, stores length of text representing this node. | ||
RELATIVE_NODE_PATH | VARCHAR2 | (4000) | Records node reference by paths when explosion/psnode specification is not available | |
MUTABLE_FLAG | VARCHAR2 | (1) | Denormalization | |
EVENT_EXECUTION_SCOPE | NUMBER | In case rule_type=EVENT_BINDING, this is the execution scope for this event binding: 1 = SCOPE_GLOBAL 2 = SCOPE_MODEL_NODE_SUBTREE 4 = SCOPE_MODEL_NODE_ONLY | ||
DATA_NUM_VALUE | NUMBER | For storage of numeric values. | ||
SEEDED_FLAG | VARCHAR2 | (1) | Yes | '1' indicates this is a seeded expr node |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_LOGIN
, EXPR_NODE_ID
, EXPRESS_ID
, SEQ_NBR
, ITEM_TYPE_ID
, PS_NODE_ID
, ITEM_ID
, FILTER_SET_ID
, GRID_COL_ID
, EXPR_PARENT_ID
, PROPERTY_ID
, COMPILE_ADVICE
, COL
, DATA_VALUE
, FIELD_NAME
, EXPR_TYPE
, EXPR_SUBTYPE
, TOKEN_LIST_SEQ
, CREATION_DATE
, LAST_UPDATE_DATE
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, EFF_MASK
, CHECKOUT_USER
, CONSEQUENT_FLAG
, MODEL_REF_EXPL_ID
, RULE_ID
, TEMPLATE_ID
, ARGUMENT_SIGNATURE_ID
, ARGUMENT_INDEX
, PARAM_SIGNATURE_ID
, PARAM_INDEX
, ARGUMENT_NAME
, DATA_TYPE
, DISPLAY_NODE_DEPTH
, COLLECTION_FLAG
, SOURCE_OFFSET
, SOURCE_LENGTH
, RELATIVE_NODE_PATH
, MUTABLE_FLAG
, EVENT_EXECUTION_SCOPE
, DATA_NUM_VALUE
, SEEDED_FLAG
FROM CZ.CZ_EXPRESSION_NODES;
CZ.CZ_EXPRESSION_NODES does not reference any database object
CZ.CZ_EXPRESSION_NODES is referenced by following:
|
|
|