Ron,
You don't need that View at all!!!!
It has no WHERE clause, just open you table solidwaste!fac_mas with table/Row buffering in the same alias as view.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.