| 123456789 |
- select pl.RecID id,pl.Line,rd.title as Describe,(pl.Site + ' ' + wm.Descr) as Site,pl.Part,pl.Rate,pl.SetupTime
- ,pl.SkillNo,ISNULL(pl.SetupTime, 0)*60 time1,(CAST(a.Op as nvarchar(10)) +' '+a.Descr) as OpStdOp
- FROM ProdLineDetail as pl LEFT JOIN RoutingOpDetail a ON pl.Op=a.Op and pl.Part = a.RoutingCode and pl.Domain = a.Domain
- LEFT JOIN rf_dictionary rd on pl.Line = rd.code
- AND pl.Line IS NOT NULL
- AND pl.Line <> ''
- AND TRIM(pl.Line) <> ''
- left join WorkCtrMaster wm on pl.Domain = wm.Domain and pl.Site = wm.WorkCtr
- where pl.IsActive = 1
|
