MSC_DIM_PARENT_INV_ITEM_CTO_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME PARENT_ID REFRESH_NUMBER

Query

SQL_Statement
SELECT ID, NAME, PARENT_ID, MAX(REFRESH_NUMBER) REFRESH_NUMBER FROM(SELECT DISTINCT ITEM_BOM_COMP_ID ID , ITEM_BOM_COMP_NAME NAME , PARENT_INV_ITEM_ID PARENT_ID , REFRESH_NUMBER REFRESH_NUMBER FROM MSC_DP_CTO_BOM_COMP ) GROUP BY ID, NAME, PARENT_ID