MSC_DIM_DEMAND_CLASS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ID

NAME

DESCRIPTION

LEVEL_ID

Query

SQL_Statement

SELECT MSRLV.LOOKUP_CODE AS ID,

MSRLV.MEANING AS NAME,

MSRLV.MEANING AS DESCRIPTION ,

50 AS LEVEL_ID

FROM MSC_SR_LOOKUP_VALUES_VL MSRLV

WHERE MSRLV.LOOKUP_TYPE ='DEMAND_CLASS'