MSC_MEASURE_SOURCE_LISTS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
LIST_ID MEASURE_ID IS_DEFAULT NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT ML.LIST_ID LIST_ID, ML.MEASURE_ID MEASURE_ID, ML.IS_DEFAULT IS_DEFAULT, MLT.NAME NAME, ML.CREATED_BY CREATED_BY, ML.CREATION_DATE CREATION_DATE, ML.LAST_UPDATED_BY LAST_UPDATED_BY, ML.LAST_UPDATE_DATE LAST_UPDATE_DATE, ML.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ML.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM MSC_MEASURE_SOURCE_LISTS_B ML, MSC_MEASURE_SOURCE_LISTS_TL MLT WHERE MLT.LIST_ID = ML.LIST_ID AND MLT.LANGUAGE = USERENV('LANG')