工单重复回写

SELECT * FROM OUT_MO_RES WHERE PEGGED_ID='001100670265' ;

SELECT * FROM TEMP_OUT_MO

--INSERT INTO STG.TEMP_OUT_MO(PRODUCTIONORDID, SO_ID, SO_LINE_ID, PEGGED_MO_ID, ITEM, QTYORDERED, CREATION_DATE, LOC_ID, PLANNEDSTARTDATE, PLANNEDENDDATE, QTYUOM, CUSTOMER_ID, BOM_ID)
SELECT PRODUCTIONORDID, LTRIM(SO_ID,'0') AS SO_ID, SO_LINE_ID, PEGGED_MO_ID, ITEM, QTYORDERED, CREATION_DATE, LOC_ID, PLANNEDSTARTDATE, PLANNEDENDDATE, QTYUOM, CUSTOMER_ID, BOM_ID FROM STG.OUT_MO
WHERE OUT_MO.LOC_ID = '2023'
and PRODUCTIONORDID='04600012450/140_1-MFG0001'

SELECT * FROM OUT_MO WHERE  PRODUCTIONORDID='04600012450/140_1-MFG0001'

select * from OUT_MO_BACK where PRODUCTIONORDID='04600012450/140_1-MFG0001' order by  CREATION_DATE desc

--FP_MO2SAP 700
select * from TEMP_MO_SPLIT where COMBINE_MO='04600012450/140_1-MFG0001'

SELECT * FROM TEMP_MO where MO_ID='04600012450/140_1-MFG0001'