rstx2

SQL View VPO2

Jul 15th, 2021 (edited)
216
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.29 KB | None | 0 0
  1. 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,
  2.                          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,
  3.                          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,
  4.                          dbo.V_RunningPO.StiQR
  5. FROM            dbo.VW_MES_MO LEFT OUTER JOIN
  6.                          dbo.V_RunningPO ON dbo.VW_MES_MO.Factory_ID COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.V_RunningPO.Factory AND
  7.                          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
  8.                          dbo.VW_MES_MO.Color_No COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.V_RunningPO.Article LEFT OUTER JOIN
  9.                          dbo.VW_MES_Line ON dbo.VW_MES_MO.Line_ID = dbo.VW_MES_Line.Line_ID
  10. WHERE        (dbo.VW_MES_MO.Line_ID IS NOT NULL)
  11.  
  12. at 10.11.0.32 DB
Add Comment
Please, Sign In to add comment