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