ZCA_ES_PARAMETERS_VL
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: VIEW
Columns
Name |
---|
PARAMETER_UUID PARAMETER_TYPE_NAME PARAMETER_DATA_TYPE MIN_VALUE MAX_VALUE DEFAULT_VALUE VALUE DELETED_FLAG BOUNCE_REQUIRED DISPLAYED_FLAG CONFIG_TYPE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE LOCALIZED_NAME LOCALIZED_DESCRIPTION |
Query
SQL_Statement |
---|
SELECT ZCA_ES_PARAMETERS_B.PARAMETER_UUID, ZCA_ES_PARAMETERS_B.PARAMETER_TYPE_NAME, ZCA_ES_PARAMETERS_B.PARAMETER_DATA_TYPE, ZCA_ES_PARAMETERS_B.MIN_VALUE, ZCA_ES_PARAMETERS_B.MAX_VALUE, ZCA_ES_PARAMETERS_B.DEFAULT_VALUE, ZCA_ES_PARAMETERS_B.VALUE, ZCA_ES_PARAMETERS_B.DELETED_FLAG, ZCA_ES_PARAMETERS_B.BOUNCE_REQUIRED, ZCA_ES_PARAMETERS_B.DISPLAYED_FLAG, ZCA_ES_PARAMETERS_B.CONFIG_TYPE, ZCA_ES_PARAMETERS_B.CREATED_BY, ZCA_ES_PARAMETERS_B.CREATION_DATE, ZCA_ES_PARAMETERS_B.LAST_UPDATE_DATE, ZCA_ES_PARAMETERS_B.LAST_UPDATE_LOGIN, ZCA_ES_PARAMETERS_B.LAST_UPDATED_BY, ZCA_ES_PARAMETERS_B.OBJECT_VERSION_NUMBER, ZCA_ES_PARAMETERS_B.USER_LAST_UPDATE_DATE, ZCA_ES_PARAMETERS_TL.LOCALIZED_NAME, ZCA_ES_PARAMETERS_TL.LOCALIZED_DESCRIPTION FROM ZCA_ES_PARAMETERS_B, ZCA_ES_PARAMETERS_TL WHERE ZCA_ES_PARAMETERS_B.PARAMETER_UUID = ZCA_ES_PARAMETERS_TL.PARAMETER_UUID AND ZCA_ES_PARAMETERS_TL.LANGUAGE = USERENV('LANG') |