with aa as(
select a.DOC_NO as 单号,CONVERT(char(10),a.ApproveDate, 120) as 审核日期,c.ITEM_CODE,b.ITEM_DESCRIPTION,b.ITEM_SPECIFICATION,d.UNIT_NAME,
case b.PRODUCT_TYPE when '1' then '主产品' when '2' then '联产品' when '3' then '副产品' when '4' then '回收料' ELSE '' end as 产出类型,
b.PLAN_QTY as 预计产量,b.REQ_QTY as 入库申请数量,b.COMPLETED_QTY as 入库数量,
b.PLAN_QTY-b.COMPLETED_QTY as 未入库数量
from MO a left join  MO_PRODUCT b on a.MO_ID=b.MO_ID
left join ITEM c on b.ITEM_ID=c.ITEM_BUSINESS_ID
left join UNIT d on b.UNIT_ID=d.UNIT_ID
)
select * from aa where 未入库数量<> '0' ORDER BY 审核日期,单号 DESC