CREATE VIEW ConversionFactorItem AS
SELECT
  UUID,
  DI000341,
  DI000373,
  DI000398, 
  DI006427,
  DI028470, 
  DI028471,
  /* FOREIGN KEYS */
  (SELECT UUID FROM DT475 WHERE DT475.DI000294 = DT476.DI000341) "conversionFactorUUID"
FROM DT476