| | |
| | | ,FPRDORGID HPRDORGID,FENTRUSTORGID HENTRUSTORGID,FOWNERID HOWNERID,FOWNERTYPEID HOWNERTYPEID |
| | | ,0 HCusID,isnull(a.FWORKSHOPID,0) HDeptID,'CLOUD导入' HRemark,a.FCREATORID HMaker,getdate() HMakeDate,a.FAPPROVERID HChecker,a.FAPPROVEDATE HCheckDate,'' HMTONo,a.FID HERPInterID,a.FBILLTYPE HERPBillType |
| | | ,case when a.FISREWORK=1 then '返工' else '普通' end HBillSubType,o.FNUMBER as HOrganNumber |
| | | ,a.FComboXSLX HComboXSLX |
| | | ,'' HComboXSLX |
| | | from T_PRD_MO a with(nolock) |
| | | left join T_ORG_Organizations o with(nolock) on a.FPRDORGID=o.FORGID |
| | | Where a.FID={id} |