FND_LABEL_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: FND
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ROW_ID TREE_STRUCTURE_CODE DATA_SOURCE_ID LABEL_ID LABEL_SHORT_NAME ICON_NAME EFFECTIVE_START_DATE EFFECTIVE_END_DATE SET_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LABEL_NAME DESCRIPTION |
問合せ
| SQL_Statement |
|---|
|
SELECT B.ROWID ROW_ID, B.TREE_STRUCTURE_CODE, B.DATA_SOURCE_ID, B.LABEL_ID, B.LABEL_SHORT_NAME, B.ICON_NAME, B.EFFECTIVE_START_DATE, B.EFFECTIVE_END_DATE, B.SET_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.LABEL_NAME, T.DESCRIPTION FROM FND_LABEL B, FND_LABEL_TL T WHERE B.TREE_STRUCTURE_CODE = T.TREE_STRUCTURE_CODE AND B.DATA_SOURCE_ID = T.DATA_SOURCE_ID AND B.LABEL_ID = T.LABEL_ID AND T.LANGUAGE = USERENV('LANG') |