Selasa, 15 Julai 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

Tiada ulasan:

Catat Ulasan