---plu查询
  
  ---select * from PLUCHGLISTLOG t;
  
   SELECT * FROM PluUpdatePrice WHERE shopid='A02133' and goodsid='1001144';
 
 begin
for r in (
SELECT distinct shopid, code FROM business_goods a,balanceplu b WHERE a.code=b.goodsid and a.barcode=b.plu and a.mkt=b.shopid --and b.shopid='A02133'
and a.lsj<>b.price)
loop
  
  pgpos_goods.p_Cmdgoods(r.shopid,r.code);
  commit;
  end loop;
  end;
  
 select * from Plugoodslist;
 PLUPOSGOODSAUDIT
 
 --plu变价系统流程
 TRI_BALANCEPLU--->Plugoodslist--->PLUPOSGOODSAUDIT-->PGPUB_SYNDATA.R$Run;
 
 
 
 
begin
Pluposgoodsaudit;
PGPUB_SYNDATA.R$Run;
begin javapos.mktinfdxs.run;end; 
end;