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')