MSC_SEGMENT_ENTITY_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ENTITY_ID ENTITY SOURCE_TABLE DATA_TYPE ENTITY_NAME ENTITY_LOOKUP_TYPE SQL_STMT DIMENSION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT MSC_SEGMENT_ENTITY_B.ENTITY_ID ENTITY_ID, MSC_SEGMENT_ENTITY_B.ENTITY ENTITY, MSC_SEGMENT_ENTITY_B.SOURCE_TABLE SOURCE_TABLE, MSC_SEGMENT_ENTITY_B.DATA_TYPE DATA_TYPE, MSC_SEGMENT_ENTITY_TL.ENTITY_NAME ENTITY_NAME, MSC_SEGMENT_ENTITY_B.ENTITY_LOOKUP_TYPE ENTITY_LOOKUP_TYPE, MSC_SEGMENT_ENTITY_B.SQL_STMT SQL_STMT, MSC_SEGMENT_ENTITY_B.DIMENSION DIMENSION, MSC_SEGMENT_ENTITY_B.CREATED_BY CREATED_BY, MSC_SEGMENT_ENTITY_B.CREATION_DATE CREATION_DATE, MSC_SEGMENT_ENTITY_B.LAST_UPDATED_BY LAST_UPDATED_BY, MSC_SEGMENT_ENTITY_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MSC_SEGMENT_ENTITY_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MSC_SEGMENT_ENTITY_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM MSC_SEGMENT_ENTITY_TL, MSC_SEGMENT_ENTITY_B WHERE MSC_SEGMENT_ENTITY_B.ENTITY_ID=MSC_SEGMENT_ENTITY_TL.ENTITY_ID AND MSC_SEGMENT_ENTITY_TL.LANGUAGE = USERENV('LANG')