Untitled
Never
---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;