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_EXPRESSION_NODES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_EXPRESSION_NODES_PK	NORMAL	UNIQUE	APPS_TS_SEED	EXPR_NODE_ID ZD_EDITION_NAME
CZ_EXPRESSION_NODES_U2	NORMAL	UNIQUE	APPS_TS_SEED	EXPR_PARENT_ID EXPR_NODE_ID ZD_EDITION_NAME
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 EXPR_TYPE
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

Columns

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			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
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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
,      ZD_EDITION_NAME
FROM CZ.CZ_EXPRESSION_NODES;

Dependencies

[top of page]

CZ.CZ_EXPRESSION_NODES does not reference any database object

CZ.CZ_EXPRESSION_NODES is referenced by following:

CZ: CZ_EXPRESSION_NODES#