FPSINPUT.CHK_COLUMNS_FOR_APD_REF

>

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSADMIN.CHK_COLUMNS_FOR_APD_REF

This view checks three things regarding APD and REF views: 1) Finds APD and REF views where the corresponding table does not exist or is not configured to update by APD or REF. 2) Finds tables which should be updated by APD or REF where the view does not exist. 3) Checks if any columns in a APD or REF view have a column name or datatype different from the corresponding table which the view populates. Note that we would like to have the columns in the same order but it does not matter. 4) Checks that all columns in LOOP table matches main table Note this view should be able to use full outer join but Oracle bug prevents this.