按单生产

 

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 ENTERPRISE, ENGINE_ID, SALESORDERID, SOLINENUM, ATTRIBUTECLASS, ATTRIBUTE, RELATIONSHIP, VALUE , SYS_CREATED_BY FROM ABPPMGR.SALESORDERLINE_P WHERE ATTRIBUTECLASS LIKE '%5000154378_1180_4%';
SELECT * FROM ABPPMGR.PRODUCTIONORDERS_P WHERE PRODUCTIONORDERID IN ('001201168481');
SELECT * FROM ABPPMGR.SFCHEADERPROPERTY WHERE  PRODUCTIONORDERID IN ('001201168481');

 

 

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

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'  ;  --000000101011003148CZ  001100896975
 
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为主料

SELECT ENTERPRISE, ENGINE_ID, SALESORDERID, SOLINENUM, ATTRIBUTECLASS, ATTRIBUTE, RELATIONSHIP, VALUE , SYS_CREATED_BY FROM ABPPMGR.SALESORDERLINE_P WHERE ATTRIBUTECLASS LIKE '%5000147246_380_1%';
SELECT * FROM ABPPMGR.PRODUCTIONORDERS_P WHERE PRODUCTIONORDERID IN ('001201167021','001100896975');--001100896975
SELECT * FROM ABPPMGR.SFCHEADERPROPERTY WHERE  PRODUCTIONORDERID IN ('001201167021','001100896975');--001201167021
--SELECT * FROM ABPPMGR.INVENTORYPROPERTY WHERE ITEM LIKE '%000000102011000263%';