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