<$W><QUERY>WFAlertAfterPlanFinish	ADMIN	06-Nov-2025 2:49:45:4589 PM
<$W><SQL>SELECT     WRRH.RUN_ID, WRRH.ROUTING_ID, WRRH.ROUTING_SUB_ID, WRRH.SENT_TO, WRRH.SENT_TO_STAGE_ID, WR.OBJECT_ID, WR.OBJECT_TYPE, WRRH.PLAN_DATE
                                ,WTSD.RECURRING_ALERT_REQD_AFTER_PLAN_FINISH FROM        WF_RUN_ROUTING_HISTORY WRRH 
                                INNER JOIN  WF_RUN WR ON WR.RUN_ID = WRRH.RUN_ID
                                INNER JOIN  WF_TEAM_STAGE_DET WTSD ON WTSD.WF_TEAM_ID = WR.WF_TEAM_ID AND WTSD.STAGE_ID = WRRH.SENT_TO_STAGE_ID
                                WHERE       WRRH.STATUS = 0 
                                AND WRRH.ROUTE_SUB_TYPE = 2 AND ISNULL(ALERT_MAIL_SENT,0) < 8
                                AND WTSD.ALERT_DAYS_AFTER_PLAN_FINISH > 0 AND WRRH.PLAN_DATE IS NOT NULL
                                AND DATEDIFF(DD, ISNULL(WRRH.PLAN_DATE, GETDATE()), GETDATE())+1 > WTSD.ALERT_DAYS_AFTER_PLAN_FINISH
                                AND CAST(ISNULL(WRRH.ALERT_AFTER_PLAN_FINISH_SENT_ON,GETDATE()-1) AS DATE) <> CAST(GETDATE() AS DATE)
                                ORDER BY	WR.OBJECT_TYPE, WRRH.SENT_TO</SQL>
 <$W>Execution Time: <TIME>1078.1376</TIME> Milliseconds.  (02:49:45.458 PM)
 </QUERY>
----------------------------------------------------------------------------------------------------------