I don't see an advantage to using @fromtables in this particular join-template script. This should be reverted when you fix your MV schemas to use your MV tables instead of base tables (and hard-code the options for @dmltable to use each of your base tables).

I am sorry that I left the existing matview example this confusing.