首页 > 其他 > 详细

按单生产

时间:2018-05-21 18:30:18      阅读:33      评论:0      收藏:0      [点我收藏+]

标签:date   lec   ply   alloc   rom   com   替代   pre   factory   

 

SELECT DEMANDLINEID,SUPPLYORDERID,DEMANDORDERID,QTYALLOCATED,ITEM FROM ABPPMGR.SUPPLYDMDPEGPLAN  WHERE  ITEM=000000102001001118CZ;--前台显示

SELECT DEMANDORDERID,DEMANDLINEID,DEMANDTYPE,ITEM,QTYINMOVE,SOURCEDATE,SUPPLYORDERID,SUPPLYTYPE,QTYALLOCATED
 FROM ABPPMGR.supplydmdpegging WHERE (DEMANDORDERID=5000154378 AND DEMANDLINEID=1180_4) OR DEMANDORDERID=5000154378/1180_4-MFG001  ;  --000000101002001849CZ   001201126508    000000102002000845CZ    
 
SELECT PRODUCTIONORDID,BOMID,ITEM,QTYORDERED,REQUIREDDATE,ROUTINGID,UDF_MO_FACTORY FROM ABPPMGR.PRODUCTIONORDERS WHERE PRODUCTIONORDID=5000154378/1180_4-MFG001;

SELECT * FROM IN_MO where so_id=5000154378 and so_line_id=1180;

 

SELECT DEMANDLINEID,SUPPLYORDERID,DEMANDORDERID,QTYALLOCATED,ITEM FROM ABPPMGR.SUPPLYDMDPEGPLAN  WHERE  ITEM=000000102011000263CZ;--前台显示

--SO:5000156623 模拟创建了成品MO:5000156623/70_1-MFG001,成品MO号供给者为半成品MO:001201126508
SELECT DEMANDORDERID,DEMANDLINEID,DEMANDTYPE,ITEM,QTYINMOVE,SOURCEDATE,SUPPLYORDERID,SUPPLYTYPE,QTYALLOCATED
 FROM ABPPMGR.supplydmdpegging WHERE (DEMANDORDERID=5000147246 AND DEMANDLINEID=380_1) OR DEMANDORDERID=5000147246/380_1-MFG001  ;  --000000101002001849CZ   001201126508    000000102002000845CZ    
 
SELECT PRODUCTIONORDID,BOMID,ITEM,QTYORDERED,REQUIREDDATE,ROUTINGID,UDF_MO_FACTORY FROM ABPPMGR.PRODUCTIONORDERS WHERE PRODUCTIONORDID=5000154378/1180_4-MFG001;

SELECT * FROM IN_MO where so_id=5000147246 and so_line_id=380;
SELECT * FROM ABPPMGR.MST_BOMCOMPONENTSALT where alternateitem like 000000102011000263CZ% ;--alternateitem替代料,item为主料

 

按单生产

标签:date   lec   ply   alloc   rom   com   替代   pre   factory   

原文:https://www.cnblogs.com/Snowfun/p/9068291.html

(0)
(0)
   
举报
评论 一句话评论(0
0条  
登录后才能评论!
© 2014 bubuko.com 版权所有 鲁ICP备09046678号-4
打开技术之扣,分享程序人生!
             

鲁公网安备 37021202000002号