工艺路线SQL

思无邪

sfc_prouting
sfc_proutingdetail
sfc_resource


求助，想把工艺路线拉出来，但无法关联到具体的存货编码。。。

yuangang

--- 工艺路线一览表 ---
SELECT a.cinvcode as 物料编码,g.cInvName AS 物料名称,g.cInvStd AS 规格型号,'被公用'=case when SharingPartId='0' then '否' else '是' end,
  c.OpSeq as 工序行号,c.Description as 工序说明,e.Description as 工作中心,'类型'=case when b.RountingType='1' then '主' else '替代' end,
  b.Version as 版本号,b.IdentDesc as 替代说明,f.cPersonName as 建档人,b.Createdate as 建档日期,Person1.cPersonName as 修改人,
  b.ModifyDate as 修改日期,Person2.cPersonName as 审核人,b.relsDate as 审核日期,b.VersionDesc as 版本说明,b.IdentCode as 替代标识
FROM v_sfc_proutingpart_rpt a
  LEFT JOIN v_sfc_prouting_rpt b ON a.PRoutingId = b.PRoutingId
  LEFT JOIN v_sfc_proutingdetail_rpt c ON b.PRoutingId=c.PRoutingId
  left join v_sfc_operation_rpt d on c.OperationId = d.OperationId
  LEFT JOIN sfc_workcenter e ON c.WcId = e.WcId
  LEFT JOIN Person f ON b.CreateUser = f.cPersonCode
  LEFT JOIN Person Person1 ON b.ModifyUser = Person1.cPersonCode
  LEFT JOIN Person Person2 ON b.relsUser = Person2.cPersonCode
  LEFT JOIN Inventory g ON a.cinvcode = g.cinvcode
order by a.cinvcode

思无邪

yuangang 发表于 2018-8-2 10:57
--- 工艺路线一览表 ---
SELECT a.cinvcode as 物料编码,g.cInvName AS 物料名称,g.cInvStd AS 规格型号,' ...

太感谢了！！！

shuixiang

yuangang 发表于 2018-8-2 10:57
--- 工艺路线一览表 ---
SELECT a.cinvcode as 物料编码,g.cInvName AS 物料名称,g.cInvStd AS 规格型号,' ...

感谢支持

kaikai7902

学习了。