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