FPSBASE.BLD_ETP_QUERIES

>

> FPSBASE.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_ETP_QUERIES

We recommend saving these queries in your favorites because they are repeatedly useful for debugging ETP. It is often helpful to pull up these then find/replace for xxx with the tool you are researching and then you can execute each query. select * from etp_hist where tool = 'xxx' and etp_from_inst > trunc(sysdate) + 4/24 order by etp_from_inst, etp_hist_seq_within_sec, entity; select * from wip_hist_for_etp where tool = 'xxx' and inst > trunc(sysdate) + 4/24 and t = 'WWH' and is_etp = 'Y'; select * from wip_step_hist where tool = 'xxx' and inst > trunc(sysdate) + 4/24 order by inst desc; select * from dash_p_wip_wafer_hist where tool = 'xxx' and inst > trunc(sysdate) + 4/24 order by inst desc; select * from dash_p_gantt_entity_state where tool = 'xxx' and to_inst > trunc(sysdate) + 4/24 order by from_inst; select * from dash_p_gantt_tool_state where tool = 'xxx' and to_inst > sysdate - 4/24 order by from_inst; select * from dash_p_gantt_tool_lot where tool = 'xxx' and comp_inst > trunc(sysdate) + 4/24 order by lot_beg_inst_for_sort desc, lot, from_inst; select * from dash_b_h_etp_7d where tool = 'xxx' and to_inst > trunc(sysdate) + 4/24 order by from_inst;