MSC_DIM_DISTINCT_ITEMS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME DESCRIPTION PARENT_ID ORGANIZATION_CODE

Query

SQL_Statement

SELECT ID, NAME, DESCRIPTION, PARENT_ID, ORGANIZATION_CODE from ( select MIC.INVENTORY_ITEM_ID ID, MSI.ITEM_NAME NAME, MSI.DESCRIPTION DESCRIPTION, MIC.CATEGORY_ID PARENT_ID, SUBSTR(MSI.ORGANIZATION_CODE, INSTR(MSI.ORGANIZATION_CODE, ':' , 1,1 ) + 1) ORGANIZATION_CODE FROM MSC_SYSTEM_ITEMS MSI, MSC_ITEM_CATEGORIES MIC, MSC_CATALOG_CATEGORIES CAT WHERE MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID AND CAT.CATEGORY_ID = MIC.CATEGORY_ID AND MIC.organization_id = MSI.organization_id AND MSI.PLAN_ID = -1 union SELECT MSI.INVENTORY_ITEM_ID ID, MSI.ITEM_NAME NAME, MSI.DESCRIPTION DESCRIPTION, -1 PARENT_ID, SUBSTR(MSI.ORGANIZATION_CODE, INSTR(MSI.ORGANIZATION_CODE, ':' , 1,1 ) + 1) ORGANIZATION_CODE FROM MSC_SYSTEM_ITEMS MSI WHERE MSI.PLAN_ID = -1 )