Tuesday 15 July 2014

Work Flow STATUS Checking Query

select count(*) from WF_NOTIFICATIONS WN
WHERE 1 = 1
AND TRUNC(TO_DATE(WN.BEGIN_DATE)) = TRUNC(TO_DATE(SYSDATE)-1)
AND END_DATE IS NULL
AND MESSAGE_TYPE like 'LAA%'
AND STATUS = 'OPEN'
AND  1=1

No comments:

Post a Comment