SELECT M.ELEMENT_NAME, M.ELEMENT_VALUE, M.INVENTORY_ITEM_ID, MTL.ORGANIZATION_ID FROM MTL_SYSTEM_ITEMS_KFV MTL, MTL_DESCR_ELEMENT_VALUES M WHERE M.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
View Text - HTML Formatted
SELECT M.ELEMENT_NAME , M.ELEMENT_VALUE , M.INVENTORY_ITEM_ID , MTL.ORGANIZATION_ID FROM MTL_SYSTEM_ITEMS_KFV MTL , MTL_DESCR_ELEMENT_VALUES M WHERE M.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID