FND_TREE_VERSION_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID TREE_STRUCTURE_CODE TREE_CODE TREE_VERSION_ID SOURCE_TREE_VERSION_ID STATUS EFFECTIVE_START_DATE EFFECTIVE_END_DATE LAST_VALIDATION_DATE CHANGED_SINCE_VALIDATION LEVEL_COUNT NODE_COUNT LOCKED_BY LOCK_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_VALIDATION_RESULT_ID LAST_VALIDATION_RESULT TREE_VERSION_NAME DESCRIPTION VERSION_COMMENT

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.TREE_STRUCTURE_CODE, B.TREE_CODE, B.TREE_VERSION_ID, B.SOURCE_TREE_VERSION_ID, B.STATUS, B.EFFECTIVE_START_DATE, B.EFFECTIVE_END_DATE, B.LAST_VALIDATION_DATE, B.CHANGED_SINCE_VALIDATION, B.LEVEL_COUNT, B.NODE_COUNT, B.LOCKED_BY, B.LOCK_DATE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.LAST_VALIDATION_RESULT_ID, B.LAST_VALIDATION_RESULT, T.TREE_VERSION_NAME, T.DESCRIPTION, T.VERSION_COMMENT FROM FND_TREE_VERSION B, FND_TREE_VERSION_TL T WHERE B.TREE_STRUCTURE_CODE = T.TREE_STRUCTURE_CODE AND B.TREE_CODE = T.TREE_CODE AND B.TREE_VERSION_ID = T.TREE_VERSION_ID AND T.LANGUAGE = USERENV('LANG')