ACE_METRIC_CONFIG_VL
Details
-
Schema: FUSION
-
Object owner: ACE
-
Object type: VIEW
Columns
| Name |
|---|
|
METRIC_CONFIG_ID TABLE_NAME COLUMN_NAME METRIC_TYPE DATA_TYPE DEFAULT_SELECTED MIN_VALUE IS_ENABLED IS_SYSTEM MAX_VALUE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DISPLAY_LABEL DESCRIPTION ERROR_MESSAGE |
Query
| SQL_Statement |
|---|
|
SELECT ACE_METRIC_CONFIG_B.METRIC_CONFIG_ID METRIC_CONFIG_ID, ACE_METRIC_CONFIG_B.TABLE_NAME TABLE_NAME, ACE_METRIC_CONFIG_B.COLUMN_NAME COLUMN_NAME, ACE_METRIC_CONFIG_B.METRIC_TYPE METRIC_TYPE, ACE_METRIC_CONFIG_B.DATA_TYPE DATA_TYPE, ACE_METRIC_CONFIG_B.DEFAULT_SELECTED DEFAULT_SELECTED, ACE_METRIC_CONFIG_B.MIN_VALUE MIN_VALUE, ACE_METRIC_CONFIG_B.IS_ENABLED IS_ENABLED, ACE_METRIC_CONFIG_B.IS_SYSTEM IS_SYSTEM, ACE_METRIC_CONFIG_B.MAX_VALUE MAX_VALUE, ACE_METRIC_CONFIG_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACE_METRIC_CONFIG_B.CREATED_BY CREATED_BY, ACE_METRIC_CONFIG_B.CREATION_DATE CREATION_DATE, ACE_METRIC_CONFIG_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACE_METRIC_CONFIG_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACE_METRIC_CONFIG_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACE_METRIC_CONFIG_TL.DISPLAY_LABEL DISPLAY_LABEL, ACE_METRIC_CONFIG_TL.DESCRIPTION DESCRIPTION, ACE_METRIC_CONFIG_TL.ERROR_MESSAGE ERROR_MESSAGE FROM ACE_METRIC_CONFIG_B, ACE_METRIC_CONFIG_TL WHERE ACE_METRIC_CONFIG_B.METRIC_CONFIG_ID = ACE_METRIC_CONFIG_TL.METRIC_CONFIG_ID AND ACE_METRIC_CONFIG_TL.LANGUAGE = USERENV('LANG') |