SELECT v_mom_orderdetail_rpt.SortSeq AS [行号],v_mom_orderdetail_rpt.MoClass AS [类型],v_mom_orderdetail_rpt.Qty AS [生产订单数量],v_mom_orderdetail_rpt.MrpQty AS [MRP净算量],v_mom_orderdetail_rpt.MDeptCode AS [生产部门],v_mom_orderdetail_rpt.QualifiedInQty AS [入库数量],v_mom_orderdetail_rpt.Status AS [状态],v_mom_orderdetail_rpt.InvCode AS [物料编码],v_mom_orderdetail_rpt.cDefine33 AS [备注],v_mom_order_rpt.MoCode AS [生产订单号码],v_mom_order_rpt.CreateDate AS [建档日期],v_mom_order_rpt.CreateUser AS [建档人],v_mom_order_rpt.ModifyDate AS [修改日期],v_mom_order_rpt.ModifyUser AS [修改人],Inventory.cInvName AS [物料名称],Inventory.cInvStd AS [物料规格],mom_mormk.Remark AS [生产线别],ComputationUnit.cComUnitName AS [单位],mom_morder.StartDate AS [开工日期],mom_morder.DueDate AS [完工日期],Department.cDepName AS [部门名称],v_mom_orderdetail_rpt.RelsUser AS [审核人],v_mom_orderdetail_rpt.RelsDate 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 Inventory  ON v_mom_orderdetail_rpt.InvCode = Inventory.cInvCode INNER JOIN mom_mormk  ON v_mom_orderdetail_rpt.MoDId = mom_mormk.MoDId INNER JOIN ComputationUnit  ON Inventory.cComUnitCode = ComputationUnit.cComunitCode INNER JOIN mom_morder  ON v_mom_orderdetail_rpt.MoDId = mom_morder.MoDId INNER JOIN Department  ON v_mom_orderdetail_rpt.MDeptCode = Department.cDepCode