厂家查询配送

wbv123

数据不全
select
CASE
  WHEN TO_CHAR(a.execdate, 'dd') >= 26
  THEN TO_CHAR(ADD_MONTHS(a.execdate, 1), 'yyyy')
  ELSE TO_CHAR(a.execdate, 'yyyy')
END AS year,  -- 年
CASE
  WHEN TO_CHAR(a.execdate, 'dd') >= 26
  THEN TO_CHAR(ADD_MONTHS(a.execdate, 1), 'mm')
  ELSE TO_CHAR(a.execdate, 'mm')
END AS month,  --月
'AC20251111111' AS channel_erpno,  -- 商业编码
    'WWWWWW责任公司' AS channel_name,  -- 商业名称
    w.warename AS item_name, -- 产品名称
    w.warespec AS productsize, -- 产品规格
    b.makeno AS lotno, -- 批号
   b.wareqty AS qty, -- 数量
    b.distprice AS price, -- 价格
    to_char(a.execdate,'yyyy-MM-dd') AS saleto_date, -- 销售日期
    f_get_busnoname(a.objbusno) AS saleto_name, -- 销往单位
    s.address as address ,
    w.factoryname as factory,
b.wareid as item_no
from t_dist_h  a left  join  YBCloud.med_store  g on a.objbusno=g.busno
left join s_busi s  on a.OBJBUSNO=s.busno ,t_dist_d  b
left join t_ware w on  b.wareid = w.wareid
where a.distno=b.distno  and a.billcode in ('DIS','ADD') and a.status=1
and    a.execdate >= SYSDATE - 60
    AND  b.wareqty <> 0
and   (w.factoryname  like '%WW%' or w.factoryname  like '%辽宁11%'
    or w.factoryname  like '%保定WW%'  or w.factoryname  like '%WW天银%'
    or w.factoryname  like '%WW%'  or w.factoryname  like '%WW红%')

wbv123

修改后
select
CASE
  WHEN TO_CHAR(a.execdate, 'dd') >= 26
  THEN TO_CHAR(ADD_MONTHS(a.execdate, 1), 'yyyy')
  ELSE TO_CHAR(a.execdate, 'yyyy')
END AS year,  -- 年
CASE
  WHEN TO_CHAR(a.execdate, 'dd') >= 26
  THEN TO_CHAR(ADD_MONTHS(a.execdate, 1), 'mm')
  ELSE TO_CHAR(a.execdate, 'mm')
END AS month,  --月
'AC20250333351' AS channel_erpno,  -- 商业编码
    'WWWWW有限责任公司' AS channel_name,  -- 商业名称
    w.warename AS item_name, -- 产品名称
    w.warespec AS productsize, -- 产品规格
    b.makeno AS lotno, -- 批号
   b.wareqty AS qty, -- 数量
    b.distprice AS price, -- 价格
    to_char(a.execdate,'yyyy-MM-dd') AS saleto_date, -- 销售日期
    f_get_busnoname(a.objbusno) AS saleto_name, -- 销往单位
    s.address as address ,
    tf.factoryname as factory,
b.wareid as item_no
from t_dist_h  a left  join  YBCloud.med_store  g on a.objbusno=g.busno
left join s_busi s  on a.OBJBUSNO=s.busno ,t_dist_d  b
left join t_ware w on  b.wareid = w.wareid
left join   t_factory     tf   on   w.factoryid=tf.factoryid
where a.distno=b.distno  and a.billcode in ('DIS','ADD') and a.status=1
and    a.execdate >= SYSDATE - 60
   AND  b.wareqty >0
and   (tf.factoryname  like '%步WW%' or tf.factoryname  like '%辽宁WW%'
or tf.factoryname  like '%保WWW浩%'  or tf.factoryname  like '%WW天银%'
   or tf.factoryname  like '%丹WW%'  or tf.factoryname  like '%WW红%')