CZ_UI_TEMPL_PARAMETERS_VL

Details

• Schema: FUSION

• Object owner: CZ

• Object type: VIEW

Columns

Name
PARAMETER_ID START_TEMPLATE_VERSION END_TEMPLATE_VERSION NAME DESCRIPTION SEQUENCE_NUMBER REQUIRED_FLAG PARAMETER_TYPE DEFAULT_STRING_VALUE DEFAULT_NUMERIC_VALUE UI_TEMPLATE_ID PARAM_VALUES_LOOKUP_CODE DELETED_FLAG OBJECT_VERSION_NUMBER CREATION_DATE LAST_UPDATE_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.PARAMETER_ID, B.START_TEMPLATE_VERSION, B.END_TEMPLATE_VERSION, B.NAME, B.DESCRIPTION, B.SEQUENCE_NUMBER, B.REQUIRED_FLAG, B.PARAMETER_TYPE, TL.DEFAULT_STRING_VALUE, B.DEFAULT_NUMERIC_VALUE, B.UI_TEMPLATE_ID, B.PARAM_VALUES_LOOKUP_CODE, 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_TEMPL_PARAMETERS_B B, CZ_UI_TEMPL_PARAMETERS_TL TL WHERE B.PARAMETER_ID = TL.PARAMETER_ID AND B.START_TEMPLATE_VERSION = TL.START_TEMPLATE_VERSION AND TL.LANGUAGE = USERENV('LANG')