FPSINPUT.DASH_E_COPY_SHIFT_TO_DAY

>

> FPSINPUT.WIP_WAFER_HIST_LOOP

View FPSAPP.DASH_E_COPY_SHIFT_TO_DAY

This merge statement copies a perfect configuration for the Shift view (web_version WEB) to the Day view (web_version DAY). merge into dash_c_category_table_cols day using ( select c.*, case when column_id like 'NEXT7%S' then column_id else replace(replace(replace(replace(replace(column_id, 'LAST_SHIFT', 'YESTERDAX'), 'SHIFT', 'DAX'), 'YESTERDAY', 'LAST_SHIFT'), 'DAY', 'SHIFT'), 'DAX', 'DAY') end as day_column_id from dash_c_category_table_cols c where web_version = 'WEB' and category not in ('LOTS','POPUP') ) web on (day.web_version = 'DAY' and day.facility = web.facility and day.category = web.category and day.table_id = web.table_id and day.column_id = web.day_column_id) when matched then update set day.column_entity_max_num = web.column_entity_max_num, day.column_width_pct = web.column_width_pct, day.ovr_sort_order = web.ovr_sort_order, day.should_auto_hide = web.should_auto_hide, day.should_display = web.should_display, day.should_display_exp = web.should_display_exp, day.should_export = web.should_export, day.should_total = web.should_total where ( day.column_entity_max_num != web.column_entity_max_num or day.column_width_pct != web.column_width_pct or day.ovr_sort_order != web.ovr_sort_order or day.should_auto_hide != web.should_auto_hide or day.should_display != web.should_display or day.should_display_exp != web.should_display_exp or day.should_export != web.should_export or day.should_total != web.should_total ) when not matched then insert ( web_version, facility, category, table_id, column_id, column_entity_max_num, column_width_pct, ovr_sort_order, should_auto_hide, should_display, should_display_exp, should_export, should_total ) values ( 'DAY', web.facility, web.category, web.table_id, web.day_column_id, web.column_entity_max_num, web.column_width_pct, web.ovr_sort_order, web.should_auto_hide, web.should_display, web.should_display_exp, web.should_export, web.should_total )