FND_TREE_STRUCTURE_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID TREE_STRUCTURE_CODE APPLICATION_ID STATUS SHARING_SCHEME CREATION_MODE CUSTOMIZABLE TREE_NODE_TABLE ROW_FLATTENED_TABLE ID_COL_FLATTENED_TABLE REFRESH_INTERVAL VERSIONING ALLOW_MULTIPLE_ROOT_NODES RESTRICT_BY_DATE RESTRICT_BY_SETID LABELING_SCHEME ALLOW_RAGGED_NODES ALLOW_SKIP_LEVEL_NODES NUMBER_OF_TREES ALLOW_NODE_LEVEL_SECURITY CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ALLOW_MULTIPLE_ACTIVE_VERS TREE_STRUCTURE_NAME DESCRIPTION MODULE_ID BI_VIEW_OBJECT_DEF_NAME TREE_NODE_VIEW_OBJECT_DEF_NAME OPTIONAL_LABEL_ENFORCEMENT PROTECTED_FLAG ND_SEARCH_VIEW_OBJECT_DEF_NAME

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.TREE_STRUCTURE_CODE, B.APPLICATION_ID, B.STATUS, B.SHARING_SCHEME, B.CREATION_MODE, B.CUSTOMIZABLE, B.TREE_NODE_TABLE, B.ROW_FLATTENED_TABLE, B.ID_COL_FLATTENED_TABLE, B.REFRESH_INTERVAL, B.VERSIONING, B.ALLOW_MULTIPLE_ROOT_NODES, B.RESTRICT_BY_DATE, B.RESTRICT_BY_SETID, B.LABELING_SCHEME, B.ALLOW_RAGGED_NODES, B.ALLOW_SKIP_LEVEL_NODES, B.NUMBER_OF_TREES, B.ALLOW_NODE_LEVEL_SECURITY, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.ALLOW_MULTIPLE_ACTIVE_VERS, T.TREE_STRUCTURE_NAME, T.DESCRIPTION, B.MODULE_ID, B.BI_VIEW_OBJECT_DEF_NAME, B.TREE_NODE_VIEW_OBJECT_DEF_NAME, B.OPTIONAL_LABEL_ENFORCEMENT, B.PROTECTED_FLAG, B.ND_SEARCH_VIEW_OBJECT_DEF_NAME FROM FND_TREE_STRUCTURE B, FND_TREE_STRUCTURE_TL T WHERE B.TREE_STRUCTURE_CODE = T.TREE_STRUCTURE_CODE AND T.LANGUAGE = USERENV('LANG')