CZ_UI_ITEMS_VL

Details

• Schema: FUSION

• Object owner: CZ

• Object type: VIEW

Columns

Name

UI_ITEM_ID UI_ID PARENT_UI_ITEM_ID START_MODEL_VERSION END_MODEL_VERSION OBJECT_VERSION_NUMBER UI_ITEM_TYPE NAME MODEL_ID MODEL_NODE_PATH RELATIVE_NODE_PATH TRANS_ATTR_ID SEQUENCE_NUMBER CX_RULE_ID UI_TEMPLATE_ID INVALID_FLAG EMPTY_FLAG REFRESH_ENABLED_FLAG UI_EDITING_FLAG DISPLAY_CONDITION_ID EXT_NODE_TYPE RECEIVE_NODE_CHANGE_FLAG NODE_CHANGE_SCOPE DELETED_FLAG CREATION_DATE LAST_UPDATE_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_LOGIN CAPTION LIST_ITEM_CAPTION

Query

SQL_Statement

SELECT B.UI_ITEM_ID, B.UI_ID, B.PARENT_UI_ITEM_ID, B.START_MODEL_VERSION, B.END_MODEL_VERSION, B.OBJECT_VERSION_NUMBER, B.UI_ITEM_TYPE, B.NAME, B.MODEL_ID, B.MODEL_NODE_PATH, B.RELATIVE_NODE_PATH, B.TRANS_ATTR_ID, B.SEQUENCE_NUMBER, B.CX_RULE_ID, B.UI_TEMPLATE_ID, B.INVALID_FLAG, B.EMPTY_FLAG, B.REFRESH_ENABLED_FLAG, B.UI_EDITING_FLAG, B.DISPLAY_CONDITION_ID, B.EXT_NODE_TYPE, B.RECEIVE_NODE_CHANGE_FLAG, B.NODE_CHANGE_SCOPE, B.DELETED_FLAG, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, TL.CAPTION, TL.LIST_ITEM_CAPTION FROM CZ_UI_ITEMS_B B, CZ_UI_ITEMS_TL TL WHERE B.UI_ITEM_ID = TL.UI_ITEM_ID AND B.START_MODEL_VERSION = TL.START_MODEL_VERSION AND TL.LANGUAGE = USERENV('LANG')