1. Tables and Views for Financials
  2. IEX_SCORE_ENG_COMPONENTS_V

IEX_SCORE_ENG_COMPONENTS_V

Details

  • Schema: FUSION

  • Object owner: IEX

  • Object type: VIEW

Columns

Name

SCORE_ID

SCORE_COMPONENT_ID

SCORE_COMP_WEIGHT

SCORE_COMP_VALUE

FUNCTION_FLAG

METRIC_FLAG

DISPLAY_ORDER

Query

SQL_Statement

SELECT SC.SCORE_ID SCORE_ID,

SCP.SCORE_COMPONENT_ID SCORE_COMPONENT_ID,

SCP.SCORE_COMP_WEIGHT SCORE_COMP_WEIGHT,

SCPT.SCORE_COMP_VALUE SCORE_COMP_VALUE,

SCPT.FUNCTION_FLAG FUNCTION_FLAG,

SCPT.METRIC_FLAG METRIC_FLAG,

SCPT.DISPLAY_ORDER DISPLAY_ORDER

FROM

IEX_SCORES SC,

IEX_SCORE_COMPONENTS SCP,

IEX_SCORE_COMP_TYPES_VL SCPT

WHERE SC.SCORE_ID = SCP.SCORE_ID AND

SCP.SCORE_COMP_TYPE_ID = SCPT.SCORE_COMP_TYPE_ID AND

SC.ENABLED_FLAG = 'Y' AND

SC.VALID_FROM_DT < sysdate AND

NVL(SC.VALID_TO_DT, sysdate+1) >= sysdate AND

SCP.ENABLED_FLAG = 'Y' AND

SCPT.ACTIVE_FLAG = 'Y'