| | |
|---|
| | | ,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 |
|---|
| | | ,o.FNUMBER as HOrganNumber,a.FComboXSLX HComboXSLX |
|---|
| | | from T_PRD_MO a with(nolock) |
|---|
| | | left join T_ORG_Organizations o with(nolock) on a.FPRDORGID=o.FORGID |
|---|
| | | Where a.FID={ids} |
|---|
