MERGE INTO T_SCM_MATERIAL m
USING HIS.UNDRUG_INFO UN
ON (M.NAME = UN.UNDRUG_NAME
AND CLASSID = 10
AND M.ICODE = UN.UNDRUG_CODE
AND UN.STOP_FLAG = 1)
WHEN MATCHED THEN
UPDATE SET M.DISABLED = UN.STOP_FLAG;
USING HIS.UNDRUG_INFO UN
ON (M.NAME = UN.UNDRUG_NAME
AND CLASSID = 10
AND M.ICODE = UN.UNDRUG_CODE
AND UN.STOP_FLAG = 1)
WHEN MATCHED THEN
UPDATE SET M.DISABLED = UN.STOP_FLAG;