Yea, we've discussed that (our plant and another with the same issue).  Since this is a new implementation corporate wide, I'm not sure if Corporate will be willing to add...

You are correct.  I would query our SQL Server to come up with a list of the currently running UPC codes, then they would be used in a where clause...

Yea, that would be nice, except this is actually connecting to JDE (Peoplesoft) Enterprise One.  Hence, they can make changes to a Work Order and/or UPC so I would have...

Yes, but then it essentially pulls all the data over from Oracle which takes a lot of bandwidth over a slow WAN.  Also, the only way the linked server will...