CZ_UI_NAV_MODEL_STEPS_VL

Details

• Schema: FUSION

• Object owner: CZ

• Object type: VIEW

Columns

Name
STEP_ID START_MODEL_VERSION OBJECT_VERSION_NUMBER MODEL_ID UI_ITEM_ID UI_NAV_MODEL_ID UI_ID PARENT_STEP_ID HIER_SEQ_NBR LINEAR_SEQ_NBR END_MODEL_VERSION MODEL_NODE_PATH UI_EDITING_FLAG DELETED_FLAG CREATION_DATE LAST_UPDATE_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_LOGIN REFERENCE_MODEL_ID CAPTION

Query

SQL_Statement

SELECT B.STEP_ID, B.START_MODEL_VERSION, B.OBJECT_VERSION_NUMBER, B.MODEL_ID, B.UI_ITEM_ID, B.UI_NAV_MODEL_ID, B.UI_ID, B.PARENT_STEP_ID, B.HIER_SEQ_NBR, B.LINEAR_SEQ_NBR, B.END_MODEL_VERSION, B.MODEL_NODE_PATH, B.UI_EDITING_FLAG, B.DELETED_FLAG, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.REFERENCE_MODEL_ID, T.CAPTION CAPTION FROM CZ_UI_NAV_MODEL_STEPS_B B, CZ_UI_NAV_MODEL_STEPS_TL T WHERE B.STEP_ID = T.STEP_ID AND B.START_MODEL_VERSION = T.START_MODEL_VERSION AND T.LANGUAGE = USERENV('LANG')