【问】做直调出库找不到商品，但是商品档案中是有这个商品
【适用版本】烘焙之星9	【模块】基础业务	【点击数】41
【知识编号】Z2015122900005
【问题描述】做直调出库找不到商品，但是商品档案中是有这个商品

【答】 请备份数据库后执行以下语句处理即可：
USE issbakev9
GO
–更新商品状态异常的商品信息
UPDATE t_bd_item_info SET sale_flag = ‘0’ WHERE sale_flag<>0
GO
–更新机构价格表
select * into t_pc_branch_price_bak from t_pc_branch_price
go
insert t_pc_branch_price
select branch_no,item_no,price,base_price,sale_price,vip_price,com_flag,scheme_price,vip_price2,vip_price3,vip_price4,vip_price5,’0.0000′ cost_price,sale_flag
from t_bd_item_info a, t_bd_branch_info b
where b.property = ‘0’
and not exists (select 1 from t_pc_branch_price c where c.branch_no = b.branch_no and c.item_no = a.item_no)
GO
insert t_pc_branch_price
select branch_no,item_no,price,base_price,sale_price,vip_price,com_flag,scheme_price,vip_price2,vip_price3,
vip_price4,vip_price5,’0.0000′ cost_price,sale_flag
from t_bd_item_info a, t_bd_branch_info b
where b.property = ‘1’
and not exists (select * from t_pc_branch_price c where c.branch_no = b.branch_no and c.item_no = a.item_no )
GO