获取单据当前工作流状态

SELECT 

assign.FRECEIVERNAMES 处理人

,assign_l.FASSIGNNAME 节点

,approval.FASSIGNID

,approval.FOBJECTTYPEID 单据id

,approval.FKEYVALUE 单据id

FROM  (    

  select FASSIGNID, FOBJECTTYPEID, FKEYVALUE  from (     

        select ROW_NUMBER() over(partition by FOBJECTTYPEId, FKEYVALUE order by fdealtime desc) RowNum ,T_WF_APPROVALASSIGN.* from T_WF_APPROVALASSIGN    ) as t1  

  where RowNum = 1