MSC_PROFILE_CAUSAL_FACTORS_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PROFILE_ID CAUSAL_FACTOR_ID CAUSAL_FACTOR_CODE CAUSAL_TYPE_ID CAUSAL_DECOMP_ID DEFINING_MEASURE TRANSPOSE_MEASURE FILL_MISSING_VALUES SHORT_METHODS LONG_METHODS MULTI_METHOD_GR1 MULTI_METHOD_GR2 NON_SEASONAL SCALE_UNEVEN_PERIODS SHAPE_DEF TIME_RELATED CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CAUSAL_FACTOR_DISP_NAME CAUSAL_FACTOR_DESCRIPTION

Query

SQL_Statement

SELECT B.PROFILE_ID, B.CAUSAL_FACTOR_ID, B.CAUSAL_FACTOR_CODE, B.CAUSAL_TYPE_ID, B.CAUSAL_DECOMP_ID, B.DEFINING_MEASURE, B.TRANSPOSE_MEASURE, B.FILL_MISSING_VALUES, B.SHORT_METHODS, B.LONG_METHODS, B.MULTI_METHOD_GR1, B.MULTI_METHOD_GR2, B.NON_SEASONAL, B.SCALE_UNEVEN_PERIODS, B.SHAPE_DEF, B.TIME_RELATED, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.CAUSAL_FACTOR_DISP_NAME, T.CAUSAL_FACTOR_DESCRIPTION FROM MSC_PROFILE_CAUSAL_FACTORS_B B, MSC_PROFILE_CAUSAL_FACTORS_TL T WHERE B.PROFILE_ID = T.PROFILE_ID AND B.CAUSAL_FACTOR_ID = T.CAUSAL_FACTOR_ID AND T.LANGUAGE = USERENV('LANG')