﻿/* Add any work orders split from flagged work orders */
MERGE INTO TEMP_WO TARGET
USING
(
  select distinct WADOCO, COALESCE(WALOTN, CAST(WADOCO AS CHAR(8))) WALOTN, WAMMCU, WAITM
  from F4801_WO wo inner join
       TEMP_WO t_wo ON wo.WAPARS = CAST(t_wo.WORKORDERNUMBER as char(8))
) SOURCE ON (TARGET.WORKORDERNUMBER = SOURCE.WADOCO)
WHEN MATCHED THEN
  UPDATE SET SPLITORDER = 'T'
WHEN NOT MATCHED THEN
  INSERT (WORKORDERNUMBER, LOTNUMBER, BRANCHCODE, SHORTITEMNUMBER, SPLITORDER)
  VALUES (SOURCE.WADOCO, SOURCE.WALOTN, SOURCE.WAMMCU, SOURCE.WAITM, 'T');