機械翻訳について

MSC_DIM_DISTINCT_ITEMS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: MSC

• オブジェクト・タイプ: VIEW

列

名前
ID NAME DESCRIPTION PARENT_ID ORGANIZATION_CODE

問合せ

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 )