待审批SQL，

SELECT t_WF_ActInst.FActivityId,t_WF_ApprovalAssign.FResult,t_WF_ApprovalAssign.FDisposition

,t_WF_Receiver.FReceiverId,t_SEC_User.FName,t_WF_ApprovalItem.FStatus, t_WF_ApprovalItem.FActionResult

,t_WF_ApprovalItem.FDisposition, t_WF_ApprovalItem.FCompletedTime  

FROM  t_WF_PiBiMap  --流程实例单据实例映射表 

INNER JOIN t_WF_ProcInst ON (t_WF_ProcInst.FProcInstId = t_WF_PiBiMap.FProcInstId) --工作流实例 

INNER  JOIN t_WF_ActInst on (t_WF_ActInst.FProcInstId = t_WF_ProcInst.FProcInstId) --节点实例 

INNER JOIN t_WF_Assign on (t_WF_Assign.FActInstId = t_WF_ActInst.FActInstId)  --待办任务 

INNER JOIN t_WF_Receiver on (t_WF_Receiver.FAssignId = t_WF_Assign.FAssignId) --待办任务接收人 

INNER JOIN t_SEC_User ON (t_SEC_User.FUserId = t_WF_Receiver.FReceiverId) --用户 

INNER JOIN t_WF_ApprovalAssign on (t_WF_Assign.FAssignId = t_WF_ApprovalAssign.FAssignId) --审批任务 

LEFT JOIN t_WF_ApprovalItem on (t_WF_ApprovalItem.FApprovalAssignId = t_WF_ApprovalAssign.FApprovalAssignId  AND t_WF_ApprovalItem.FReceiverId = t_WF_Receiver.FReceiverId) --待办任务处理明细  

WHERE  1=1 

--and t_WF_PiBiMap.FObjectTypeId = '单据唯一标识(例：ENG_ECNOrder)' 

--AND t_WF_PiBiMap.FKeyValue = '单据内码(例：100584)'

order by t_WF_Receiver.FReceiverId