db oracle sn

dsafasdfdfsafs

--查询商品信息在每个站点每个门店的具体库存数量
select g.name as 商品名称,
t.status as 发布状态, t.is_auth as 审核状态, t.ref_price as 参考价格,
s.erp_code as 商品编码, s.vendor as 厂商, s.depot as 库位, s.distribution_site as 发货地点, s.sales_org as 销售组织, s.stock_quantity as 库存数量
from general_product g, specific_product t, shadow_inventory s
where g.erp_code = t.erp_code and g.erp_code = s.erp_code and t.status = '1' and t.is_auth ='1'

sadfasffsafsaf

200.72_gold

select * from tbl_main_sheet m where m.use_dept='cw' and m.fill_endtime>=to_date('2008-10-31','YYYY-MM-DD HH24:MI:SS');

 

sdfsfsd