CZ_UI_NAV_MODEL_STEPS

詳細

スキーマ: FUSION
オブジェクト所有者: CZ
オブジェクト・タイプ: VIEW

列

名前
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

名前

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

問合せ

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')

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')