金蝶K3 工序计划界面对应的sql

 这界面对应的取数sql

Select top 20000 v1.FDate as FDate,u1.FAutoTD as FAutoTDID,u1.FEntryID as FEntryID_Number,u1.FWBInterID as FBillInterID,u1.FWorkBillNo as FBillNo,u1.FStatus as FStatus,v1.FTranType as FTranType,u1.FInterID as FInterID,u1.FEntryID as FEntryID,t4.FQtyDecimal as FQtyDecimal,v1.FICMOInterID as FICMOInterID, 0 As FBOSCloseFlag from SHWorkBill v1 INNER JOIN SHWorkBillEntry u1 ON   v1.FInterID = u1.FInterID  AND u1.FInterID<>0 
 INNER JOIN t_WorkCenter t10 ON   u1.FWorkCenterID = t10.FItemID  AND t10.FItemID<>0 
 INNER JOIN ICMO t3 ON   v1.FICMOInterID = t3.FInterID  AND t3.FInterID<>0 
 INNER JOIN t_ICItem t4 ON   v1.FItemID = t4.FItemID  AND t4.FItemID<>0 
 where 1=1 AND (   
t3.FBillNo LIKE '%WORK001410%'
) AND ((V1.FBillType<>11622) AND (((u1.FStatus=0 OR u1.FStatus=1 OR u1.FStatus=2 OR u1.FStatus=3)))) order by  u1.FInterID,u1.FEntryID
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
select top 40 
tmpICMOStatus.FMoStatusName AS FICMOStatus,
t3.FSuspend AS FICMOSuspend,
u1.FAutoTD AS FAutoTDID,
u1.FEntryID AS FEntryID_Number,
u1.FWBInterID AS FBillInterID,
u1.FWorkBillNo AS FBillNo,
t4.FItemID AS FItemID,
u1.FStatus AS FStatus,
v1.FTranType AS FTranType,
u1.FInterID AS FInterID,
u1.FWorkBillNo AS FWorkBillNo,
CASE u1.FStatus WHEN 0 THEN '计划' WHEN 3 THEN '关闭' ELSE '审核' END AS FStatusName,
t4.FNumber AS FLongNumber,
t4.FName AS FItemName,
t9.FID AS FOperID,
t9.FName AS FOperName,
u1.FOperSN AS FOperSN,
t5.FName AS FUnitName,
u1.FAuxQtyPlan AS FAuxQtyPlan,
u1.FAuxQtyrecive AS FAuxQtyrecive,
u1.FAuxQtyPass AS FAuxQtyPass,
u1.FAuxReprocessedQty AS FAuxReprocessedQty,
u1.FPlanStartDate AS FPlanStartDate,
u1.FPlanEndDate AS FPlanEndDate,
t23.FName AS FTeamName,
t24.FName AS FWoerkerName,
t21.FName AS FIsOut,
t91.FName AS FAutoTD,
t92.FName AS FAutoOF,
t3.FBillNo AS FICMOBillNo,
t4.FShortNumber AS FShortNumber,
t4.FModel AS FItemModel,
 Case when v1.FBillType=11621 then t30.FAuxQtyShift else t3.FAuxQty end  AS FAuxQty,
t16.FName AS FBaseUnitID,
t3.FPlanCommitDate AS FPlanCommitDate,
t3.FPlanFinishDate AS FPlanFinishDate,
u1.FEntryID AS FEntryID,
u1.Fpriority AS Fpriority,
v1.FDate AS FDate,
u1.FCheckDate AS FCheckDate,
t7.FName AS FBillerID,
t8.FName AS FCheckerIDName,
u1.FOperNote AS FOperNote,
t10.FNumber AS FWorkNumber,
t10.FShortNumber AS FWorkShortNumber,
t10.FName AS FWorkName,
t50.FName AS FDeptName,
t25.FName AS FDeviceName,
t11.FName AS FTimeName,
u1.FLeadTime AS FLeadTime,
u1.FTimeSetup AS FTimeSetup,
u1.FWorkQty AS FWorkQty,
u1.FTimeRun AS FTimeRun,
u1.FTotalWorkTime AS FTotalTimeRun,
u1.FMoveQty AS FMoveQty,
u1.FMoveTime AS FMoveTime,
u1.FAuxQtyReceiveSel AS FAuxQtyReceiveSel,
u1.FStartWorkDate AS FStartWorkDate,
u1.FEndWorkDate AS FEndWorkDate,
u1.FAuxqtyScrap AS FAuxqtyScrap,
u1.FAuxqtyForItem AS FAuxqtyForItem,
u1.FAuxQtyHandOverSel AS FAuxQtyHandOverSel,
u1.FFinishTime AS FFinishTime,
u1.FReadyTime AS FReadyTime,
u1.FFixTime AS FFixTime,
u1.FNote AS FNote,
t20.FName AS FFare,
t22.FName AS FSupplier,
u1.FFee AS FFee,
u1.FFee*u1.FQtyPlan AS FTotalFee,
CASE u1.FBackFlushed WHEN 1 THEN '*' ELSE '' END AS FBackFlushed,
t4.FQtyDecimal AS FQtyDecimal,
t4.FQtyDecimal AS FPriceDecimal,
t26.FName AS FQualityChk,
t27.FSchemeName AS FQualityScheme,
t28.FName AS FManager,
u1.FPieceRate AS FPieceRate,
u1.FAuxQtyTaskDispSel AS FAuxQtyTaskDispSel,
u1.FAuxQtyTaskDispAck AS FAuxQtyTaskDispAck,
u1.FResourceCount AS FResourceCount,
t29.FName AS FBillType,
t30.FBillNo AS FOperShiftBillID,
t31.FWorkBillNo AS FOriginWBID,
u1.FAuxQualifiedReprocessedQty AS FAuxQualifiedReprocessedQty,
u1.FAuxReprocessedMoveQty AS FAuxReprocessedMoveQty,
u1.FAuxReprocessedMoveSelQty AS FAuxReprocessedMoveSelQty,
u1.FAuxRepReceiveQty AS FAuxRepReceiveQty,
u1.FAuxRepReceiveSelQty AS FAuxRepReceiveSelQty,
t3.fgmpbatchno AS fgmpbatchno,
u1.FAuxQtyLost AS FAuxQtyLost,
u1.FAuxQtyLostSel AS FAuxQtyLostSel,
u1.FAuxQtyGain AS FAuxQtyGain,
u1.FAuxQtyGainSel AS FAuxQtyGainSel,
u1.FAuxConvertQtyHandover AS FAuxConvertQtyHandover,
u1.FAuxConvertQtyRecive AS FAuxConvertQtyRecive,
u1.FChangeTimes AS FChangeTimes,
v1.FICMOInterID AS FICMOInterID,
v1.FOrderBillNo AS FOrderBillNo,
v1.FOrderEntryID AS FOrderEntryID,
v1.FMTONo AS FMTONo,
u1.FHRReadyTime AS FHRReadyTime,
v1.FPrintCount AS FPrintCount,
 (CASE tAux.FName WHEN '*' THEN '' ELSE tAux.FName END)  AS FAuxPropName,
tAux.FNumber AS FAuxPropNumber,
tmpBillByOper.FOperAuxQtyFinish AS FOperAuxQtyFinish,
tmpBillByOper.FOperAuxQtyPass AS FOperAuxQtyPass,
tmpBillByOper.FOperAuxQtyScrap AS FOperAuxQtyScrap,
tmpBillByOper.FOperAuxQtyForItem AS FOperAuxQtyForItem,
tmpBillByOper.FOperAuxReprocessedQty AS FOperAuxReprocessedQty,
tmpBillByOper.FOperAuxQtyRecive AS FOperAuxQtyRecive,
tmpBillByOper.FOperAuxQtyHandOver AS FOperAuxQtyHandOver,
CASE  WHEN u1.FExecution = 2 and u1.FStartworkdatepda is not null THEN 'Y' ELSE 'N' END AS FExecution,
t_OutSelf.FName AS FOutSelfChange,
u1.FEntrySelfz0375 AS FEntrySelfz0375,
u1.FEntrySelfz0376 AS FEntrySelfz0376,
u1.FEntrySelfz0374 AS FEntrySelfz0374 from SHWorkBill v1 INNER JOIN SHWorkBillEntry u1 ON   v1.FInterID = u1.FInterID  AND u1.FInterID<>0 
 LEFT OUTER JOIN t_User t8 ON   u1.FCheckerID = t8.FUserID  AND t8.FUserID<>0 
 LEFT OUTER JOIN t_subMessage t9 ON   u1.FOperID = t9.FInterID  AND t9.FInterID<>0 
 INNER JOIN t_WorkCenter t10 ON   u1.FWorkCenterID = t10.FItemID  AND t10.FItemID<>0 
 LEFT OUTER JOIN t_subMessage t11 ON   u1.FTimeUnit = t11.FInterID  AND t11.FInterID<>0 
 INNER JOIN ICMO t3 ON   v1.FICMOInterID = t3.FInterID  AND t3.FInterID<>0 
 INNER JOIN t_ICItem t4 ON   v1.FItemID = t4.FItemID  AND t4.FItemID<>0 
 LEFT OUTER JOIN t_measureunit t5 ON   t3.FUnitID = t5.FMeasureUnitID  AND t5.FMeasureUnitID<>0 
 LEFT OUTER JOIN t_User t7 ON   v1.FBillerID = t7.FUserID  AND t7.FUserID<>0 
 LEFT OUTER JOIN t_measureunit t16 ON   t4.FUnitID = t16.FMeasureUnitID  AND t16.FMeasureUnitID<>0 
 LEFT OUTER JOIN t_department t50 ON   t10.FDeptID = t50.FItemID  AND t50.FItemID<>0 
 LEFT OUTER JOIN t_submessage t20 ON   u1.FFare = t20.FInterID  AND t20.FInterID<>0 
 LEFT OUTER JOIN t_submessage t21 ON   u1.FIsOut = t21.FInterID  AND t21.FInterID<>0 
 LEFT OUTER JOIN t_Supplier t22 ON   u1.FSupplyID = t22.FItemID  AND t22.FItemID<>0 
 LEFT OUTER JOIN t_submessage t23 ON   u1.FTeamID = t23.FInterID  AND t23.FInterID<>0 
 LEFT OUTER JOIN t_emp t24 ON   u1.FWorkerID = t24.FItemID  AND t24.FItemID<>0 
 LEFT OUTER JOIN t_resource t25 ON   u1.FDeviceID = t25.FInterId  AND t25.FInterId<>0 
 LEFT OUTER JOIN t_submessage t26 ON   u1.FQualityChkID = t26.FInterId  AND t26.FInterId<>0 
 LEFT OUTER JOIN icqcscheme t27 ON   u1.FQualitySHcemeID = t27.FInterId  AND t27.FInterId<>0 
 LEFT OUTER JOIN t_emp t28 ON   u1.FFManagerID = t28.FItemID  AND t28.FItemID<>0 
 LEFT OUTER JOIN t_submessage t29 ON   v1.FBillType = t29.FInterId  AND t29.FInterId<>0 
 LEFT OUTER JOIN ICOperShift t30 ON   v1.FOperShiftBillID = t30.FInterId  AND t30.FInterId<>0 
 LEFT OUTER JOIN SHWorkBillEntry t31 ON   v1.FOriginWBID = t31.FWBInterId  AND t31.FWBInterId<>0 
 LEFT OUTER JOIN t_subMessage t91 ON   u1.FAutoTD = t91.FInterID  AND t91.FInterID<>0 
 LEFT OUTER JOIN t_subMessage t92 ON   u1.FAutoOF = t92.FInterID  AND t92.FInterID<>0 
 LEFT OUTER JOIN t_AuxItem tAux ON     v1.FAuxPropID = tAux.FItemid   AND tAux.FItemid <>0 
 LEFT OUTER JOIN vw_ICMOStatus tmpICMOStatus ON   v1.FICMOInterID = tmpICMOStatus.FInterID  AND tmpICMOStatus.FInterID<>0 
 LEFT OUTER JOIN vw_SHWorkBillByOper tmpBillByOper ON   u1.FWBInterID = tmpBillByOper.FWBInterID  AND tmpBillByOper.FWBInterID<>0 
 LEFT OUTER JOIN t_submessage t_OutSelf ON   u1.FOutSelfChange = t_OutSelf.FInterID  AND t_OutSelf.FInterID<>0 
 where  (u1.FInterID=67860 and u1.FEntryID=1) or (u1.FInterID=67860 and u1.FEntryID=2) or (u1.FInterID=67860 and u1.FEntryID=3) or (u1.FInterID=67860 and u1.FEntryID=4) or (u1.FInterID=67860 and u1.FEntryID=5) or (u1.FInterID=67860 and u1.FEntryID=6) or (u1.FInterID=67860 and u1.FEntryID=7) or (u1.FInterID=67860 and u1.FEntryID=8) or (u1.FInterID=67860 and u1.FEntryID=9) or (u1.FInterID=67860 and u1.FEntryID=10) or (u1.FInterID=67860 and u1.FEntryID=11) or (u1.FInterID=67860 and u1.FEntryID=12) or (u1.FInterID=67860 and u1.FEntryID=13) order by  u1.FInterID,u1.FEntryID
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Select top 20000 u1.FAuxQtyPlan as FAuxQtyPlan,u1.FAuxQtyrecive as FAuxQtyrecive,u1.FAuxQtyPass as FAuxQtyPass,u1.FAuxReprocessedQty as FAuxReprocessedQty,u1.FLeadTime as FLeadTime,u1.FTimeSetup as FTimeSetup,u1.FWorkQty as FWorkQty,u1.FTimeRun as FTimeRun,u1.FTotalWorkTime as FTotalTimeRun,u1.FMoveQty as FMoveQty,u1.FMoveTime as FMoveTime,u1.FAuxQtyReceiveSel as FAuxQtyReceiveSel,u1.FAuxqtyScrap as FAuxqtyScrap,u1.FAuxqtyForItem as FAuxqtyForItem,u1.FAuxQtyHandOverSel as FAuxQtyHandOverSel,u1.FFinishTime as FFinishTime,u1.FReadyTime as FReadyTime,u1.FFixTime as FFixTime,u1.FAuxQtyTaskDispSel as FAuxQtyTaskDispSel,u1.FAuxQtyTaskDispAck as FAuxQtyTaskDispAck,u1.FAuxQualifiedReprocessedQty as FAuxQualifiedReprocessedQty,u1.FAuxReprocessedMoveQty as FAuxReprocessedMoveQty,u1.FAuxReprocessedMoveSelQty as FAuxReprocessedMoveSelQty,u1.FAuxRepReceiveQty as FAuxRepReceiveQty,u1.FAuxRepReceiveSelQty as FAuxRepReceiveSelQty,u1.FAuxQtyLost as FAuxQtyLost,u1.FAuxQtyLostSel as FAuxQtyLostSel,u1.FAuxQtyGain as FAuxQtyGain,u1.FAuxQtyGainSel as FAuxQtyGainSel,u1.FAuxConvertQtyHandover as FAuxConvertQtyHandover,u1.FAuxConvertQtyRecive as FAuxConvertQtyRecive,u1.FHRReadyTime as FHRReadyTime,tmpBillByOper.FOperAuxQtyFinish as FOperAuxQtyFinish,tmpBillByOper.FOperAuxQtyPass as FOperAuxQtyPass,tmpBillByOper.FOperAuxQtyScrap as FOperAuxQtyScrap,tmpBillByOper.FOperAuxQtyForItem as FOperAuxQtyForItem,tmpBillByOper.FOperAuxReprocessedQty as FOperAuxReprocessedQty,tmpBillByOper.FOperAuxQtyRecive as FOperAuxQtyRecive,tmpBillByOper.FOperAuxQtyHandOver as FOperAuxQtyHandOver,u1.FEntryID as FEntryID_Number,v1.FTranType as FTranType,u1.FInterID as FInterID,u1.FEntryID as FEntryID,t4.FQtyDecimal as FQtyDecimal,t4.FQtyDecimal as FPriceDecimal from SHWorkBill v1 INNER JOIN SHWorkBillEntry u1 ON   v1.FInterID = u1.FInterID  AND u1.FInterID<>0 
 INNER JOIN t_WorkCenter t10 ON   u1.FWorkCenterID = t10.FItemID  AND t10.FItemID<>0 
 INNER JOIN ICMO t3 ON   v1.FICMOInterID = t3.FInterID  AND t3.FInterID<>0 
 INNER JOIN t_ICItem t4 ON   v1.FItemID = t4.FItemID  AND t4.FItemID<>0 
 LEFT OUTER JOIN vw_SHWorkBillByOper tmpBillByOper ON   u1.FWBInterID = tmpBillByOper.FWBInterID  AND tmpBillByOper.FWBInterID<>0 
 where 1=1 AND (   
t3.FBillNo LIKE '%WORK001410%'
) AND ((V1.FBillType<>11622) AND (((u1.FStatus=0 OR u1.FStatus=1 OR u1.FStatus=2 OR u1.FStatus=3))))