BOM取料品仓库

如果BOM子项上已经有存储地点了且与料品不一样，这个脚本会强制刷成一样的

update A set SupplyWareHouse=C.WareHouse

from cbo_bomcomponent A,cbo_itemmaster B,CBO_InventoryInfo C,Base_Organization D

where A.itemmaster=B.ID and B.ID=C.itemmaster and B.Org=D.ID

and A.IssueStyle=0 and C.WareHouse is not null

and D.Code='10'

只刷料品存储地点非空时，且子项上供应地点为空的记录

update A set SupplyWareHouse=C.WareHouse

from cbo_bomcomponent A,cbo_itemmaster B,CBO_InventoryInfo C,Base_Organization D

where A.itemmaster=B.ID and B.ID=C.itemmaster and B.Org=D.ID

and A.IssueStyle=0 and C.WareHouse is not null and A.SupplyWareHouse is null

and D.Code='10'

生产订单备料取料品仓库

update A set SupplyWh=C.WareHouse

from MO_MOPickList A,cbo_itemmaster B,CBO_InventoryInfo C,Base_Organization D

where A.itemmaster=B.ID and B.ID=C.itemmaster and B.Org=D.ID

and A.IssueStyle=0 and C.WareHouse is not null and A.SupplyWh is null

and D.Code='20'