FND_TS_DATA_SOURCE_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID ENTERPRISE_ID DATA_SOURCE_ID TREE_STRUCTURE_CODE VIEW_OBJECT_DEF_NAME PK1_COLUMN PK2_COLUMN PK3_COLUMN PK4_COLUMN PK5_COLUMN MAX_DEPTH ALLOW_AS_TERMINAL_NODE USAGE_LIMIT ALLOW_NODE_LEVEL_SECURITY ICON_NAME ALLOW_DUPLICATE_NODES LABEL_VIEW_OBJECT_DEF_NAME LABEL_PK1_COLUMN LABEL_PK2_COLUMN LABEL_PK3_COLUMN LABEL_PK4_COLUMN LABEL_PK5_COLUMN CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DATA_SOURCE_NAME ALLOW_AS_FREE_NODE

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.ENTERPRISE_ID ENTERPRISE_ID, B.DATA_SOURCE_ID DATA_SOURCE_ID, B.TREE_STRUCTURE_CODE TREE_STRUCTURE_CODE, B.VIEW_OBJECT_DEF_NAME VIEW_OBJECT_DEF_NAME, B.PK1_COLUMN PK1_COLUMN, B.PK2_COLUMN PK2_COLUMN, B.PK3_COLUMN PK3_COLUMN, B.PK4_COLUMN PK4_COLUMN, B.PK5_COLUMN PK5_COLUMN, B.MAX_DEPTH MAX_DEPTH, B.ALLOW_AS_TERMINAL_NODE ALLOW_AS_TERMINAL_NODE, B.USAGE_LIMIT USAGE_LIMIT, B.ALLOW_NODE_LEVEL_SECURITY ALLOW_NODE_LEVEL_SECURITY, B.ICON_NAME ICON_NAME, B.ALLOW_DUPLICATE_NODES ALLOW_DUPLICATE_NODES, B.LABEL_VIEW_OBJECT_DEF_NAME LABEL_VIEW_OBJECT_DEF_NAME, B.LABEL_PK1_COLUMN LABEL_PK1_COLUMN, B.LABEL_PK2_COLUMN LABEL_PK2_COLUMN, B.LABEL_PK3_COLUMN LABEL_PK3_COLUMN, B.LABEL_PK4_COLUMN LABEL_PK4_COLUMN, B.LABEL_PK5_COLUMN LABEL_PK5_COLUMN, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, T.DATA_SOURCE_NAME DATA_SOURCE_NAME, B.ALLOW_AS_FREE_NODE FROM FND_TS_DATA_SOURCE B, FND_TS_DATA_SOURCE_TL T WHERE B.DATA_SOURCE_ID = T.DATA_SOURCE_ID AND B.TREE_STRUCTURE_CODE = T.TREE_STRUCTURE_CODE AND T.LANGUAGE = USERENV('LANG')