Oracle 11g Update statement with Error ORA-00904

The extra join seems unnecessary. Why not just use this simpler version?

UPDATE Appliance
    SET Appliance.IdApplianceType =
        (SELECT AT.id
         FROM ApplianceType AT
         WHERE UPPER(Appliance.typeName) = UPPER(AT.name)
        );