CZ_UI_COND_EXPR_NODES
CZ_UI_COND_EXPR_NODES stores UI condition expression nodes
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CZ_UI_COND_EXPR_NODES_PK |
EXPR_NODE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXPR_NODE_ID | NUMBER | 18 | Yes | Id of an expression node | |
| PARENT_EXPR_NODE_ID | NUMBER | 18 | Id of the parent expression node | ||
| UI_CONDITION_ID | NUMBER | 18 | Yes | Id of the UI condition this expression node belongs to | |
| START_OBJECT_VERSION | NUMBER | 18 | Yes | Start version of the versioned entity i.e. model or UI template | |
| EXPR_NODE_TYPE | VARCHAR2 | 30 | Yes | OPERATOR, SYSTEM_ATTRIBUTE, TEMPLATE_PARAMETER VALUE | |
| SATTR_SOURCE | VARCHAR2 | 30 | Source of the system attribute. Valid sources are ASSOCIATED_MODEL_NODE OTHER_MODEL_NODE CONFIGURATION SESSION TEMPLATE_PARAMETER | ||
| SATTR_SRC_NODE_REL_PATH | VARCHAR2 | 1000 | When system attribute source is OTHER_MODEL_NODE this is id based path of the other model node relative to the AMN of the UI Item this condition is defined on or the model node this condition is defined on | ||
| SATTR_SRC_NODE_PATH | VARCHAR2 | 1000 | When system attribute source is OTHER_MODEL_NODE this is id based absolute path of the other model node This path is used for displaying the name based path in CME and also for UI refresh. | ||
| SATTR_SRC_NODE_NAME_PATH | VARCHAR2 | 4000 | When system attribute source is OTHER_MODEL_NODE this column stores the name id based absolute path of the other model node. This path is used for display in CME. | ||
| SATTR_SRC_TRANS_ATTR_ID | NUMBER | 18 | Stores the id of a TIA when the other model node is a TIA | ||
| SATTR_SRC_TEMPL_PARAM | VARCHAR2 | 255 | When system attribute source is TEMPLATE_PARAMETER this column indicates the name of the template parameter | ||
| SATTR_SIGNATURE_CODE | VARCHAR2 | 48 | SIGNATURE_CODE of java system attribute | ||
| OPERATOR_CODE | VARCHAR2 | 30 | When EXPR_NODE_TYPE is OPERATOR, this column indicates an operator to use EQUALS, NOT_EQUALS, LESS_THAN, LESS_THAN_OR_EQUAL_TO, GREATER_THAN, GREATER_THAN_OR_EQUAL_TO, STARTS_WITH, ENDS_WITH, CONTAINS, DOES_NOT_CONTAIN, AND, OR | ||
| VALUE | VARCHAR2 | 1000 | This column is relevant when the expr_node_type is VALUE The column contains an FND lookup code when the expr_node_type of the left operand is SYSTEM_ATTRIBUTE that has an associated lookup type for its values | ||
| DELETED_FLAG | NUMBER | 18 | A non-zero value indicates a logically deleted record | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CZ_UI_COND_EXPR_NODES_N1 | Non Unique | Default | START_OBJECT_VERSION, PARENT_EXPR_NODE_ID, UI_CONDITION_ID, EXPR_NODE_TYPE |
| CZ_UI_COND_EXPR_NODES_U1 | Unique | Default | EXPR_NODE_ID |