SELECT v_mom_orderdetail_rpt.SortSeq AS [行号],v_mom_orderdetail_rpt.Qty AS [生产订单数量],v_mom_orderdetail_rpt.Mdeptcode  AS  [生产部门],Department.CDEPNAME AS   [部门名称], v_mom_order_rpt.CreateDate  AS  [日期],v_mom_order_rpt.MoCode AS [生产订单号码],v_mom_moallocate_rpt.Qty AS [数量],v_mom_moallocate_rpt.IssQty AS [已领量],v_mom_orderdetail_rpt.InvCode AS [成品编码],mom_morder.StartDate as [开工日期] ,v_mom_moallocate_rpt.InvCode AS [子件编码],Inventory.cInvName AS [存货名称],Inventory.cInvStd AS [规格型号]  FROM v_mom_orderdetail_rpt INNER JOIN v_mom_order_rpt  ON v_mom_orderdetail_rpt.MoId = v_mom_order_rpt.MoId INNER JOIN v_mom_moallocate_rpt  ON v_mom_orderdetail_rpt.MoDId = v_mom_moallocate_rpt.MoDId INNER JOIN Inventory  ON v_mom_moallocate_rpt.InvCode = Inventory.cInvCode  INNER JOIN Department  ON v_mom_orderdetail_rpt.MDeptCode = Department.cDepCode  INNER JOIN mom_morder  ON v_mom_orderdetail_rpt.MoDId = mom_morder.MoDId where  v_mom_moallocate_rpt.IssQty - v_mom_moallocate_rpt.Qty >0