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
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