I guess I could have made it clear that the view definition is missing from the ecommerce.sql file. It's simply not there. We need someone familiar with ecommerce to find what it's supposed to do.
BTW, there are only 2 bugs left on the ecommerce module on SDM now (and I am working through them).