ATK_KRH_HIERARCHY_TYPES_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ATK
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ROW_ID ENTERPRISE_ID HIERARCHY_TYPE DISPLAY_ON_NAV_REGION DISPLAY_ON_HOME_TAB DISPLAY_LEVELS_ON_NAV_REGION DISPLAY_LEVELS_ON_TAB_REGION DISPLAY_ORDER NAVIGATION_REGION_NAME HOME_TAB_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER |
問合せ
| SQL_Statement |
|---|
|
SELECT b.ROWID row_id, b.ENTERPRISE_ID, b.HIERARCHY_TYPE, b.DISPLAY_ON_NAV_REGION, b.DISPLAY_ON_HOME_TAB, b.DISPLAY_LEVELS_ON_NAV_REGION, b.DISPLAY_LEVELS_ON_TAB_REGION, b.DISPLAY_ORDER, t.NAVIGATION_REGION_NAME, t.HOME_TAB_NAME, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER FROM ATK_KRH_HIERARCHY_TYPES b, ATK_KRH_HIERARCHY_TYPES_TL t WHERE b.HIERARCHY_TYPE = t.HIERARCHY_TYPE AND t.LANGUAGE = USERENV('LANG') |