--最后一次入库库位带出的是已经停用库位的品号信息
select 
e.PLANT_NAME,b.ITEM_CODE as 品号,b.ITEM_NAME as 品名,c.WAREHOUSE_CODE as 仓库编码,c.WAREHOUSE_NAME as 仓库名称,d.BIN_CODE as 最近入库库位编码,d.BIN_NAME as 最近入库库位名称,
a.Owner_Org_ROid,a.ITEM_ID,a.WAREHOUSE_ID,a.BIN_ID from  ITEM_WAREHOUSE a 
left join  ITEM b on a.ITEM_ID =b.ITEM_BUSINESS_ID
left join  WAREHOUSE c on a.WAREHOUSE_ID=c.WAREHOUSE_ID
LEFT join  BIN d on a.BIN_ID=d.BIN_ID
left join  PLANT e on a.Owner_Org_ROid= e.PLANT_ID
where  a.BIN_ID in (select BIN_ID from BIN where ApproveStatus <> 'Y')  --查看BIN ID为停用状态的
ORDER BY c.WAREHOUSE_CODE,d.BIN_CODE

--根据上面查询结果的 WAREHOUSE_ID+BIN_ID 查询要替换的数据范围
select * from ITEM_WAREHOUSE
where BIN_ID ='F52972A6-8261-4937-485A-1C05C37C89E6'


--查询指定仓库，库位，所在工厂的 BIN_ID，即要用作替换的新BIN_ID
select c.PLANT_NAME,a.WAREHOUSE_ID,b.BIN_ID,a.WAREHOUSE_CODE,a.WAREHOUSE_NAME,a.BIN_CONTROL,b.BIN_CODE,b.BIN_NAME from WAREHOUSE a 
left join BIN b on a.WAREHOUSE_ID=b.WAREHOUSE_ID 
left join PLANT c  on a.Owner_Org_ROid=c.PLANT_ID
WHERE BIN_CODE = 'F10101' and WAREHOUSE_CODE ='M'

--SELECT * into ITEM_WAREHOUSE20260109 from ITEM_WAREHOUSE   ---备份表


--更新新的BIN_ID替换旧的BIN_ID(注意区分查询结果中的工厂，相同库位，不同工厂的BIN_ID值不一样)
update ITEM_WAREHOUSE set BIN_ID = '776177BD-0976-4E1E-187E-1C020E2C1729' 
where BIN_ID ='F52972A6-8261-4937-485A-1C05C37C89E6'