| 123456789 |
- select c.RecID as id,c.ItemNum,i.Descr as ItemDescr,c.Op,r.Descr as OpDescr,c.Line,c.Typed,g.Comments as TypedDescr,c.ItemCode,c.Descr,c.IsMain
- from ItemOpCondition c
- left join ItemMaster i
- on c.Domain=i.Domain and c.ItemNum=i.ItemNum
- left join RoutingOpDetail r
- on c.Domain=r.Domain and c.ItemNum=r.RoutingCode and c.Op=r.Op
- left join GeneralizedCodeMaster g
- on c.Domain=g.Domain and c.Typed=g.Val and g.FldName='OpConditionType'
- where c.Domain='{<UserFactoryNum>}' and c.CodeType='Prod'
|
