SELECT R.ORGANIZATION_ID ORGNID , R.INVENTORY_ITEM_ID ITEMID , G.CONCATENATED_SEGMENTS ITEMCODE , M.CONCATENATED_SEGMENTS CODE , M.DESCRIPTION NAME FROM MTL_RELATED_ITEMS R , MTL_SYSTEM_ITEMS_KFV G , MTL_SYSTEM_ITEMS_KFV M WHERE R.INVENTORY_ITEM_ID = G.INVENTORY_ITEM_ID AND R.ORGANIZATION_ID = G.ORGANIZATION_ID AND R.RELATED_ITEM_ID = M.INVENTORY_ITEM_ID AND R.ORGANIZATION_ID = M.ORGANIZATION_ID AND R.RELATIONSHIP_TYPE_ID = 19