视图sql过滤查询当前登录人不同审批状态的记录【sql过滤数据】

Q：如何在视图的sql过滤模式中，使用sql查询当前登录人已经审批过的、待审批的、已审批的记录呢？

A：大致参考代码如下
待批以及本人创建的SQL:
select * from(
SELECT ROW_NUMBER() OVER (ORDER BY DOMAINID) AS ROWNUMBER, TABNIC.* FROM
(SELECT * FROM (SELECT d.* FROM (SELECT d.* FROM TLK_PERSONALREIMBURSE d WHERE 1 = 1 AND
(d.ID IN(SELECT DOC_ID FROM AUTH_PERSONALREIMBURSE AUTH WHERE AUTH.VALUE = '11e1-a88f-efa9d566-a253-35c406531671'))
OR  d.AUTHOR ='11e1-a88f-efa9d566-a253-35c406531671')d WHERE 1=1 ) ordtb
WHERE DOMAINID ='11e1-98df-fbfa9e0c-adca-15e6adc3fbc5') TABNIC) tb1
where item_costerId='11e1-a88f-efa9d566-a253-35c406531671' or statelabel!='草稿'
order by item_makeDate

已审批的
select personal.* from T_RELATIONHIS rel,TLK_PERSONALREIMBURSE personal where rel.DOCID=personal.ID and rel.AUDITOR='11e2-02ea-b1b30bb8-a47e-df8e51f9b6f2'
and rel.FLOWID='11e1-b128-accf4bde-99f9-9b068defb0a4'

原帖：
http://www.teemlink.com/bbs/viewthread.php?tid=164400