ATK_KRH_INDUSTRIES_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ATK
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ROW_ID ENTERPRISE_ID INDUSTRY_ID NAME HIERARCHY_NUMBER OWNER DESCRIPTION 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.INDUSTRY_ID, t.NAME, b.HIERARCHY_NUMBER, b.OWNER, t.DESCRIPTION, 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_INDUSTRIES b, ATK_KRH_INDUSTRIES_TL t WHERE t.INDUSTRY_ID = b.INDUSTRY_ID AND t.LANGUAGE = USERENV('LANG') |