CZ_MODEL_NODES_VL

Details

• Schema: FUSION

• Object owner: CZ

• Object type: VIEW

Columns

Name

MODEL_NODE_ID START_MODEL_VERSION DELETED_FLAG END_MODEL_VERSION MODEL_NODE_TYPE NAME DESCRIPTION PARENT_ID MODEL_ID SEQUENCE_NUMBER INITIAL_VALUE INITIAL_NUM_VALUE MINIMUM MAXIMUM MIN_CARDINALITY MAX_CARDINALITY REFERENCE_ID INSTANTIATION_TYPE MAX_QTY_PER_OPTION COUNTED_OPTIONS_FLAG DOMAIN_ORDER REVERSE_CONNECTOR_ID CONNECTOR_TARGET_TYPE MUTUALLY_EXCLUSIVE_FLAG UI_TIMESTAMP_ADD UI_TIMESTAMP_REMOVE UI_TIMESTAMP_MOVE UI_TIMESTAMP_CHANGETYPE UI_TIMESTAMP_REORDER SKIP_VALIDATION_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.MODEL_NODE_ID, B.START_MODEL_VERSION, B.DELETED_FLAG, B.END_MODEL_VERSION, B.MODEL_NODE_TYPE, B.NAME, T.DESCRIPTION, B.PARENT_ID, B.MODEL_ID, B.SEQUENCE_NUMBER, B.INITIAL_VALUE, B.INITIAL_NUM_VALUE, B.MINIMUM, B.MAXIMUM, B.MIN_CARDINALITY, B.MAX_CARDINALITY, B.REFERENCE_ID, B.INSTANTIATION_TYPE, B.MAX_QTY_PER_OPTION, B.COUNTED_OPTIONS_FLAG, B.DOMAIN_ORDER, B.REVERSE_CONNECTOR_ID, B.CONNECTOR_TARGET_TYPE, B.MUTUALLY_EXCLUSIVE_FLAG, B.UI_TIMESTAMP_ADD, B.UI_TIMESTAMP_REMOVE, B.UI_TIMESTAMP_MOVE, B.UI_TIMESTAMP_CHANGETYPE, B.UI_TIMESTAMP_REORDER, B.SKIP_VALIDATION_FLAG, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM CZ_MODEL_NODES_B B, CZ_MODEL_NODES_TL T WHERE B.MODEL_NODE_ID = T.MODEL_NODE_ID AND B.START_MODEL_VERSION = T.START_MODEL_VERSION AND T.LANGUAGE = USERENV('LANG')