SELECT * FROM IN_ITEMBOMROUTING_TEMP WHERE PRODUCED_ITEM_ID='' ;
解决方法:
检查如下数据是否存在就可以知道为什么被过滤 掉
select * from IN_ROUTING_HEADER where ROUTING_ID in (select ROUTING_ID from IN_ITEMBOMROUTING_TEMP WHERE PRODUCED_ITEM_ID='' ) select * from IN_BOM_HEADER where BOM_ID in (select BOM_ID from IN_ITEMBOMROUTING_TEMP WHERE PRODUCED_ITEM_ID='' )