select
 BizObj.FNumber  as "费用申请单编号 ",
 --bill. as "费用申请单名称",
 ac.FACTDEFNAME_L2 as "当前任务名称",
 ac.FCREATEDTIME as "任务创建时间",
 ass.FPERSONEMPNAME_L2 as "审批人"
from T_INV_MaterialIssueBill BizObj--费用申请单
 left join T_WFR_ProcInstBizObj ob on BizObj.FID = ob.FBizObjId--流程实例与单据关系
 left join T_WFR_ProcInst pr on ob.FProcInstId = pr.FProcinstID--流程实例
 left join T_WFR_ACTINST ac on pr.FProcinstID = ac.FProcinstID--活动实例
 left join T_WFR_Assign ass on ac.FACTINSTID = ass.FACTINSTID--工作流任务
 left join T_INV_MaterialIssueBillEntry bill on bill.fparentid=bizobj.fid
where (ac.FSTATE = 'open.running' or ac.FSTATE = 'open.not_running.not_started') and bill.fmaterialid='jPJnAQEUEADgCtf5wKgCZ0QJ5/A='
order by BizObj.FCREATETIME desc,pr.FCREATEDTIME desc,ac.FCREATEDTIME desc,ass.FCREATEDTIME desc