One of our operations, “SUBBLUE”, is a subcontract operation. This operation is associated with a supplier and we need to change that to a new supplier. With over 10k parts, a BAQ/DMT process seemed right.
My BAQ queries the ECORev + ECOOpr tables to get all entries with SUBBLUE and the old VendorNum. I then export, update VendorNum to the new number, and run into the Operations DMT. All good.
However! On review we realized that the BAQ returned multiple SUBBLUE operations with old OprSeq numbers. That is, at some point the part was updated, a new operation added, and the SUBBLUE sequence changed from 90 to 100. The BAQ, however, returned both the 90 SUBBLUE (no longer displayed in Method Tracker) and the 100 SUBBLUE (the correct one).
Because of this, these doubled-up results when through the DMT and changed the actual 90 operation “MILLING” to “SUBLUE” (bad).
Question: how can I modify my BAQ to EXCLUDE those entries in ECOOpr that are not currently part of the BOO? The part in question only has a single revision, as do most of our parts, but the SUBBLUE operation has moved from OprSeq 90 to 100 to 110 over time, with 110 being the real SUBBLUE operation for this part.