1. Tables and Views for Sales and Fusion Service
  2. MOT_TERR_METRICS_VL

MOT_TERR_METRICS_VL

Details

  • Schema: FUSION

  • Object owner: MOT

  • Object type: VIEW

Columns

Name

TERR_METRIC_ID

ACTIVE_FLAG

PARTITION_ID

METRICS_CODE

ACTIVATION_REQUEST

CALCULATED_FLAG

FORMULA_DEFINITION

DRILL_REPORT_PATH

ENABLED_FLAG

VO_ATTR_NAME

METRICS_DATA_SOURCE

METRICS_QUERY_HANDLER

METRICS_DRILL_HANDLER

BI_FACT_NAME

BI_FACT_ATTR_NAME

INTERNAL_FLAG

CUMULATIVE_FLAG

CUMULATIVE_HISTORY_REQUIRED

ASSOCIATED_TIME_ENTITY

ASSOCIATED_TIME_ENTITY_ATTRS

TERR_METRIC_SUBJECT_AREA_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

CONFLICT_ID

FORECAST_TRENDING_FLAG

NAME

DESCRIPTION

Query

SQL_Statement

SELECT

MOT_TERR_METRICS_B.TERR_METRIC_ID TERR_METRIC_ID,

MOT_TERR_METRICS_B.ACTIVE_FLAG ACTIVE_FLAG,

MOT_TERR_METRICS_B.PARTITION_ID PARTITION_ID,

MOT_TERR_METRICS_B.METRICS_CODE METRICS_CODE,

MOT_TERR_METRICS_B.ACTIVATION_REQUEST ACTIVATION_REQUEST,

MOT_TERR_METRICS_B.CALCULATED_FLAG CALCULATED_FLAG,

MOT_TERR_METRICS_B.FORMULA_DEFINITION FORMULA_DEFINITION,

MOT_TERR_METRICS_B.DRILL_REPORT_PATH DRILL_REPORT_PATH,

MOT_TERR_METRICS_B.ENABLED_FLAG ENABLED_FLAG,

MOT_TERR_METRICS_B.VO_ATTR_NAME VO_ATTR_NAME,

MOT_TERR_METRICS_B.METRICS_DATA_SOURCE METRICS_DATA_SOURCE,

MOT_TERR_METRICS_B.METRICS_QUERY_HANDLER METRICS_QUERY_HANDLER,

MOT_TERR_METRICS_B.METRICS_DRILL_HANDLER METRICS_DRILL_HANDLER,

MOT_TERR_METRICS_B.BI_FACT_NAME BI_FACT_NAME,

MOT_TERR_METRICS_B.BI_FACT_ATTR_NAME BI_FACT_ATTR_NAME,

MOT_TERR_METRICS_B.INTERNAL_FLAG INTERNAL_FLAG,

MOT_TERR_METRICS_B.CUMULATIVE_FLAG CUMULATIVE_FLAG,

MOT_TERR_METRICS_B.CUMULATIVE_HISTORY_REQUIRED CUMULATIVE_HISTORY_REQUIRED,

MOT_TERR_METRICS_B.ASSOCIATED_TIME_ENTITY ASSOCIATED_TIME_ENTITY,

MOT_TERR_METRICS_B.ASSOCIATED_TIME_ENTITY_ATTRS ASSOCIATED_TIME_ENTITY_ATTRS,

MOT_TERR_METRICS_B.TERR_METRIC_SUBJECT_AREA_ID TERR_METRIC_SUBJECT_AREA_ID,

MOT_TERR_METRICS_B.CREATED_BY CREATED_BY,

MOT_TERR_METRICS_B.CREATION_DATE CREATION_DATE,

MOT_TERR_METRICS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

MOT_TERR_METRICS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

MOT_TERR_METRICS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

MOT_TERR_METRICS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

MOT_TERR_METRICS_B.CONFLICT_ID CONFLICT_ID,

MOT_TERR_METRICS_B.FORECAST_TRENDING_FLAG,

MOT_TERR_METRICS_TL.NAME NAME,

MOT_TERR_METRICS_TL.DESCRIPTION DESCRIPTION

FROM

MOT_TERR_METRICS_B,

MOT_TERR_METRICS_TL

WHERE

MOT_TERR_METRICS_B.TERR_METRIC_ID = MOT_TERR_METRICS_TL.TERR_METRIC_ID AND

MOT_TERR_METRICS_TL.LANGUAGE = USERENV('LANG')