CZ_RW_MODEL_NODES_VL

Details

• Schema: FUSION

• Object owner: CZ

• Object type: VIEW

Columns

Name

MODEL_NODE_ID PERSISTENT_MODEL_NODE_ID INVENTORY_ITEM_ID ORGANIZATION_ID PARENT_ID MODEL_NODE_TYPE NAME DESCRIPTION DELETED_FLAG MAXIMUM MINIMUM MAX_COUNT_PER_OPTION COUNTED_OPTIONS_FLAG ACD_TYPE CHANGE_LINE_ID VERSION_ID IMPLEMENTATION_DATE CHANGE_BIT_MAP OBJECT_VERSION_NUMBER VERSION_START_DATE VERSION_END_DATE SEQUENCE_NUMBER USER_INPUT_REQUIRED_FLAG DISPLAY_FLAG INITIAL_NUM_VALUE INITIAL_VALUE DEFAULT_CHOICE_NODE_ID CHILD_SORT_ORDER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.MODEL_NODE_ID, B.PERSISTENT_MODEL_NODE_ID, B.INVENTORY_ITEM_ID, B.ORGANIZATION_ID, B.PARENT_ID, B.MODEL_NODE_TYPE, B.NAME, T.DESCRIPTION, B.DELETED_FLAG, B.MAXIMUM, B.MINIMUM, B.MAX_COUNT_PER_OPTION, B.COUNTED_OPTIONS_FLAG, B.ACD_TYPE, B.CHANGE_LINE_ID, B.VERSION_ID, B.IMPLEMENTATION_DATE, B.CHANGE_BIT_MAP, B.OBJECT_VERSION_NUMBER, B.VERSION_START_DATE, B.VERSION_END_DATE, B.SEQUENCE_NUMBER, B.USER_INPUT_REQUIRED_FLAG, B.DISPLAY_FLAG, B.INITIAL_NUM_VALUE, B.INITIAL_VALUE, B.DEFAULT_CHOICE_NODE_ID, B.CHILD_SORT_ORDER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM CZ_RW_MODEL_NODES_B B, CZ_RW_MODEL_NODES_TL T WHERE B.MODEL_NODE_ID = T.MODEL_NODE_ID AND T.LANGUAGE = USERENV('LANG')