IN_ITEMBOMROUTING中的数据被过滤 到IN_ITEMBOMROUTING_TEMP

 

SELECT * FROM IN_ITEMBOMROUTING_TEMP WHERE PRODUCED_ITEM_ID='000000101001029634' ;

解决方法：

检查如下数据是否存在就可以知道为什么被过滤 掉

select * from IN_ROUTING_HEADER where ROUTING_ID in (select ROUTING_ID from IN_ITEMBOMROUTING_TEMP WHERE PRODUCED_ITEM_ID='000000101001029634' )

select * from IN_BOM_HEADER where BOM_ID in (select BOM_ID from IN_ITEMBOMROUTING_TEMP WHERE PRODUCED_ITEM_ID='000000101001029634' )