MSC_DIM_CTO_DEMAND_TYPE_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME REFRESH_NUMBER

Query

SQL_Statement
SELECT ID, NAME, MAX(REFRESH_NUMBER) REFRESH_NUMBER FROM(SELECT DISTINCT COMPONENT_TYPE ID , decode(COMPONENT_TYPE, 1, 'MODEL', 2, 'OPTION CLASS' , 'OPTION' ) NAME , REFRESH_NUMBER REFRESH_NUMBER FROM MSC_DP_CTO_BOM_COMP) GROUP BY ID, NAME