CZ_UI_ITEM_TEMPL_PARAM_VALS_VL

Details

• Schema: FUSION

• Object owner: CZ

• Object type: VIEW

Columns

Name
UI_TEMPL_PARAM_VALUE_ID UI_ITEM_ID PARAMETER_ID START_MODEL_VERSION END_MODEL_VERSION MODEL_ID PARAMETER_STRING_VALUE PARAMETER_NUMERIC_VALUE PARAMETER_VALUE DELETED_FLAG OBJECT_VERSION_NUMBER CREATION_DATE LAST_UPDATE_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.UI_TEMPL_PARAM_VALUE_ID, B.UI_ITEM_ID, B.PARAMETER_ID, B.START_MODEL_VERSION, B.END_MODEL_VERSION, B.MODEL_ID, TL.PARAMETER_STRING_VALUE, B.PARAMETER_NUMERIC_VALUE, B.PARAMETER_VALUE, B.DELETED_FLAG, B.OBJECT_VERSION_NUMBER, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN FROM CZ_UI_ITEM_TEMPL_PARAM_VALS_B B, CZ_UI_ITEM_TEMPL_PARAM_VALS_TL TL WHERE B.UI_TEMPL_PARAM_VALUE_ID = TL.UI_TEMPL_PARAM_VALUE_ID AND B.START_MODEL_VERSION = TL.START_MODEL_VERSION AND TL.LANGUAGE = USERENV('LANG')