Data Dictionary
>
FPSBASE Views
> FPSBASE.WIP_WAFER_HIST_LOOP
View FPSBASE.RTG_REF_START_PRDS
This view shows the starting products (products with no further sources) which go into a given product, taking *only* the products with the highest SOURCE_PRD_NUM_PREFERENCE for each (DEST_FACILITY, DEST_PRD, SOURCE_PRD_NUM). In other words, it tries to show the current most recent version of the starting products that go into an arbitrary product.
|
Column |
Comment |
|---|---|
|
START_FACILITY |
|
|
START_PRD |
|
|
CURRENT_FACILITY |
|
|
CURRENT_PRD |
|
|
QTY_NEEDED |
The number of units needed of the source product for each unit in the next product. Typically this is 1 but occasionally we might assemble 2 A and 1 B together to make 1 C. (* inherited from FPSINPUT.RTG_PRD_FACILITY_NEXT) |