Queries restricting found data
The WHERE
clause must specify found objects only. Otherwise, all objects of that type in the database are returned instead of only the found records. These examples apply to formulas and items:
...f.formula_id = s.formula_id...
...i.item_code = s.item_code...