FPSAPP.BLD_COMMON_LOT_QUERIES

>

> FPSAPP.WIP_WAFER_HIST_LOOP

View FPSADMIN.BLD_COMMON_LOT_QUERIES

We recommend saving these queries in your favorites because they are repeatedly useful. It is often helpful to pull up these then find/replace for xxx with the lot you are researching and then you can execute each query. select * from fpsinput.wip_event_hist where lot = 'xxx' order by inst desc, lot_seq_within_sec desc; select * from fpsinput.wip_lots_verify where lot = 'xxx'; select * from fpsbase.wip_step_hist where lot = 'xxx' order by inst desc, lot_seq_within_sec desc; select * from fpsbase.wip_events_curr_step where lot = 'xxx' order by inst desc, lot_seq_within_sec desc; select * from fpsbase.wip_lots_realtime where lot = 'xxx'; select * from fpsbase.wip_lots_plus where lot = 'xxx'; select * from fpsbase.wip_step_hist_and_future where lot = 'xxx' order by overall_lot_seq_num; select * from fpsbase.wip_step_future where lot = 'xxx' order by num_seq_away; select * from fpsbase.wip_step_future_plus where lot = 'xxx' order by num_seq_away; select * from fpsbase.wip_step_future_assignments where lot = 'xxx' order by num_steps_away;