ATK_KRH_HIERARCHY_ITEMS_L_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ATK
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ROW_ID ITEM_ID HIERARCHY_TYPE ITEM_ID_NUMBER ICON_FILE_NAME TOPIC_RELEASES NAME DESCRIPTION LANGUAGE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER TOPIC_COUNT TOPIC_COUNT_FAQ |
問合せ
| SQL_Statement |
|---|
|
SELECT b.ROWID row_id, b.ITEM_ID, b.HIERARCHY_TYPE, b.ITEM_ID_NUMBER, b.ICON_FILE_NAME, b.TOPIC_RELEASES, t.NAME, t.DESCRIPTION, t.LANGUAGE, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER, b.TOPIC_COUNT, b.TOPIC_COUNT_FAQ FROM ATK_KRH_HIERARCHY_ITEMS b, ATK_KRH_HIERARCHY_ITEMS_TL t WHERE b.ITEM_ID = t.ITEM_ID |