Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT dbo.VW_MES_MO.Factory_ID AS Factory, dbo.VW_MES_MO.Line_ID AS Line, dbo.VW_MES_Line.Line_Desc AS CellName, dbo.VW_MES_MO.MO_No, dbo.VW_MES_MO.MO_Seq, dbo.VW_MES_MO.Cycle_No AS PO,
- dbo.VW_MES_MO.Style_No, dbo.VW_MES_MO.Style_Name, dbo.VW_MES_MO.Color_No AS Article, dbo.VW_MES_MO.Plan_Qty AS Qty, dbo.VW_MES_MO.Plan_Start_ASY, dbo.VW_MES_MO.Act_End_ASY,
- dbo.VW_MES_MO.Comfirm_Date, dbo.VW_MES_MO.CRD, dbo.V_RunningPO.PrepStatId, dbo.V_RunningPO.StiStatId, dbo.V_RunningPO.PrepStat, dbo.V_RunningPO.StiStat, dbo.V_RunningPO.PrepQR,
- dbo.V_RunningPO.StiQR
- FROM dbo.VW_MES_MO LEFT OUTER JOIN
- dbo.V_RunningPO ON dbo.VW_MES_MO.Factory_ID COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.V_RunningPO.Factory AND
- dbo.VW_MES_MO.Line_ID COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.V_RunningPO.Line AND dbo.VW_MES_MO.Cycle_No COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.V_RunningPO.PO AND
- dbo.VW_MES_MO.Color_No COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.V_RunningPO.Article LEFT OUTER JOIN
- dbo.VW_MES_Line ON dbo.VW_MES_MO.Line_ID = dbo.VW_MES_Line.Line_ID
- WHERE (dbo.VW_MES_MO.Line_ID IS NOT NULL)
- at 10.11.0.32 DB
Add Comment
Please, Sign In to add comment