生产-未领料生产物料在线管控用知友软件服务中心

发布时间：2014-12-25 00:02 文章来源：未知被浏览次数：次

SELECT v_mom_order_rpt.MoCode AS [生产订单号码],v_mom_orderdetail_rpt.SortSeq AS [订单行号],

v_mom_order_rpt.CreateDate AS [订单日期] ,mom_morder.StartDate AS [开工日期], mom_morder.DueDate AS [完工日期],

v_mom_orderdetail_rpt.InvCode AS [产成品编码] , Inventory1.cInvAddCode AS [产成品代码],

Inventory1.cinvccode AS [产品分类],InventoryClass.cInvCName AS [产品类别名称],Inventory1.cInvName AS [产成品名称],

Inventory1.cInvStd AS [产成品规格型号] ,v_mom_orderdetail_rpt.MDeptCode AS [生产部门], Department.cDepName AS [部门名称],

v_mom_orderdetail_rpt.Qty AS [生产订单数量], v_mom_orderdetail_rpt.QualifiedInQty AS [入库数量],v_mom_orderdetail_rpt.Status AS [状态],

v_mom_moallocate_rpt.SortSeq AS [行号],v_mom_moallocate_rpt.InvCode AS [物料编码], Inventory.cinvccode as [存货分类] ,

Inventory.cInvAddCode AS [存货代码], Inventory.cInvName AS [存货名称], Inventory.cInvStd AS [规格型号],

v_mom_moallocate_rpt.Qty AS [应领数量], v_mom_moallocate_rpt.IssQty AS [已领量], ComputationUnit.cComUnitName AS [计量单位名称],

v_mom_modetail.Remark AS [生产线别] FROM v_mom_order_rpt

INNER JOIN v_mom_orderdetail_rpt ON v_mom_order_rpt.MoId = v_mom_orderdetail_rpt.MoId

INNER JOIN v_mom_moallocate_rpt ON v_mom_orderdetail_rpt.MoDId = v_mom_moallocate_rpt.MoDId

LEFT JOIN Department ON v_mom_orderdetail_rpt.MDeptCode = Department.cDepCode

INNER JOIN Inventory ON v_mom_moallocate_rpt.InvCode = Inventory.cInvCode

INNER JOIN InventoryClass ON InventoryClass.cInvCCode = Inventory.cInvCCode

INNER JOIN Inventory Inventory1 ON v_mom_orderdetail_rpt.InvCode = Inventory1.cInvCode

INNER JOIN mom_morder ON v_mom_orderdetail_rpt.MoDId = mom_morder.MoDId

INNER JOIN ComputationUnit ON Inventory.cComUnitCode = ComputationUnit.cComunitCode

INNER JOIN v_mom_modetail ON v_mom_modetail.MoCode=v_mom_order_rpt.MoCode

where v_mom_orderdetail_rpt.modid not in (select v_mom_moallocate_rpt.modid from v_mom_moallocate_rpt where v_mom_moallocate_rpt.IssQty>0)

分享到：更多

◆ 相关内容

最新动态