FND_LABEL_VL
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: VIEW
Columns
Name |
---|
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 |
Query
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') |