天心sunlike ERP 托工缺货明细SQL

ALTER PROCEDURE [dbo].[am_select_que_tw]
	-- @Param1 varchar(30), @Param2 int
AS
BEGIN
select 
TF_TW.am_jiaoqi,
TF_TW.am_bian as bian,
TF_TW.am_que,
TF_TW.am_msg,
SALM.NAME as SAL,
A.am_sc,
A.am_jihua,
A.PRD_NAME as am_cp,
A.OS_NO as am_os,
--中类代号
PRDT.IDX1,
--中类名称
INDX.NAME as indxname,
--库存数据 
PRDT1.WH,
CAST(PRDT1.QTY AS INT) as KC,
-- 货品资料
PRDT.SPC,
-- 供应商
CUST.NAME AS CUST,
MF_TW.QTY_RK,
--退回
CAST(MF_TW.QTY_TC AS int) as   QTY_TC,
--缴回
CAST(MF_TW.QTY_RTN AS int) as   QTY_RTN,
MF_TW.MO_NO,
MF_TW.SO_NO,
-- 托工料号
MF_TW.MRP_NO,
-- 下单日期
CONVERT(varchar(100),MF_TW.SYS_DATE, 23) as SYS_DATE,
-- 托工调拨数 
CAST(TF_TW.QTY_TS AS int) as   QTY_TB,
-- 托工数量
CAST(TF_TW.QTY AS int) as   QTY,
TF_TW.PRD_NAME,
-- 回货料号
TF_TW.PRD_NO,
CAST(TF_TW.QTY_STD AS int) as   QTY_STD,
-- 托工单号
TF_TW.TW_NO
from MF_TW
left join TF_TW on
MF_TW.TW_NO=TF_TW.TW_NO
/*厂商资料*/
LEFT JOIN CUST ON
MF_TW.CUS_NO = CUST.CUS_NO
-- 货品资料
LEFT JOIN prdt ON
MF_TW.MRP_NO=prdt.PRD_NO
-- 库存数据
left JOIN PRDT1 ON
--MF_TW.MRP_NO = PRDT1.PRD_NO AND PRDT1.WH='32'
MF_TW.MRP_NO = PRDT1.PRD_NO AND PRDT1.WH=PRDT.WH
-- TF_TW.PRD_NO = PRDT1.PRD_NO AND PRDT1.WH=TF_TW.WH
--中类
left JOIN INDX ON PRDT.IDX1=INDX.IDX_NO
LEFT JOIN (SELECT  am_sc,am_jihua,PRD_NAME,OS_NO FROM TF_POS WHERE am_check=1) AS A 
ON MF_TW.SO_NO = A.OS_NO
-- 业务
LEFT JOIN SALM on CUST.SAL=SALM.SAL_NO
-- 订单号码
where MF_TW.SO_NO IN (SELECT  TF_POS.OS_NO FROM TF_POS WHERE am_check=1)
order by A.am_jihua,A.OS_NO
END