Data Dictionary
>
FPSINPUT Views
> FPSINPUT.WIP_WAFER_HIST_LOOP
View FPSADMIN.SYSMNTR_ERRORS
This view looks for invalid objects in all FPS schemas as well as errors in ADM_LOAD. We must use dbf_xxx views here because dbf_objects does not include triggers and synonyms in other schemas and we need to check if those are invalid. Then because we must use dbf_xxx views and Oracle does not allow grant select on views using dbf_xxx and we need to grant permission on CHK_INVALID to other users, our solution is to refresh a table with this data which we can grant.