PJS_MT_MEASURE_SETS_VL

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name
MEASURE_SET_CODE MEASURE_SET_TYPE MEASURE_CATEGORY_CODE MEASURE_FORMAT SCENARIO_DIM ACCOUNT_DIM MEASURE_FORMULA CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CALCULATED_FLAG ADDL_ATTR_CHAR_1 ADDL_ATTR_CHAR_2 ADDL_ATTR_CHAR_3 ADDL_ATTR_CHAR_4 ADDL_ATTR_CHAR_5 NAME INTERNAL_NAME DESCRIPTION CATEGORY_NAME

Query

SQL_Statement

SELECT PJS_MT_MEASURE_SETS_B.MEASURE_SET_CODE MEASURE_SET_CODE, PJS_MT_MEASURE_SETS_B.MEASURE_SET_TYPE MEASURE_SET_TYPE, PJS_MT_MEASURE_SETS_B.MEASURE_CATEGORY_CODE, PJS_MT_MEASURE_SETS_B.MEASURE_FORMAT MEASURE_FORMAT, PJS_MT_MEASURE_SETS_B.SCENARIO_dim SCENARIO_dim, PJS_MT_MEASURE_SETS_B.account_dim account_dim, PJS_MT_MEASURE_SETS_B.MEASURE_FORMULA MEASURE_FORMULA, PJS_MT_MEASURE_SETS_B.CREATION_DATE CREATION_DATE, PJS_MT_MEASURE_SETS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJS_MT_MEASURE_SETS_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJS_MT_MEASURE_SETS_B.CREATED_BY CREATED_BY, PJS_MT_MEASURE_SETS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJS_MT_MEASURE_SETS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJS_MT_MEASURE_SETS_B.CALCULATED_FLAG CALCULATED_FLAG, PJS_MT_MEASURE_SETS_B.ADDL_ATTR_CHAR_1 ADDL_ATTR_CHAR_1, PJS_MT_MEASURE_SETS_B.ADDL_ATTR_CHAR_2 ADDL_ATTR_CHAR_2, PJS_MT_MEASURE_SETS_B.ADDL_ATTR_CHAR_3 ADDL_ATTR_CHAR_3, PJS_MT_MEASURE_SETS_B.ADDL_ATTR_CHAR_4 ADDL_ATTR_CHAR_4, PJS_MT_MEASURE_SETS_B.ADDL_ATTR_CHAR_5 ADDL_ATTR_CHAR_5, PJS_MT_MEASURE_SETS_TL.NAME NAME, PJS_MT_MEASURE_SETS_TL.INTERNAL_NAME INTERNAL_NAME, PJS_MT_MEASURE_SETS_TL.DESCRIPTION DESCRIPTION , PJS_MT_MEASURE_SETS_TL.CATEGORY_NAME CATEGORY_NAME FROM PJS_MT_MEASURE_SETS_B, PJS_MT_MEASURE_SETS_TL WHERE PJS_MT_MEASURE_SETS_B.MEASURE_SET_CODE = PJS_MT_MEASURE_SETS_TL.MEASURE_SET_CODE AND PJS_MT_MEASURE_SETS_TL.LANGUAGE = USERENV('LANG')