Failure : Method Name : GetData Query Failure Exception Message Server is busy. Please try again. Transaction (Process ID 320) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Login : 105057 06-Oct-2025 1:07:57:8948 PM Connection : wrench Command(s) : SELECT 'Document' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, DI.DOC_NO OBJECT_NO, DI.DOC_DESCRIPTION OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS, REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (DI.DOC_NO+ CHAR(10)+ ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, DI.CLIENT_DOC_NO CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,DI.ORDER_ID,DI.DOC_NO,WR.STATUS,'' AREA_CODE , WO.IS_FORWARDED ,WRSS.INT_USER_REV_NO, WRSS.INT_REV_NO ,WRSS.VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'DOC' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.SENT_TO = N'105057' INNER JOIN DOC_INFO DI ON DI.IDOC_ID = WR.OBJECT_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM LEFT JOIN ORDER_MASTER OM ON DI.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID INNER JOIN WF_RUN_STAGE_STATUS WRSS ON WO.ROUTING_ID = WRSS.ROUTING_ID UNION ALL SELECT 'Document' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, DI.DOC_NO OBJECT_NO, DI.DOC_DESCRIPTION OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS, REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (DI.DOC_NO+ CHAR(10)+ ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, DI.CLIENT_DOC_NO CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,DI.ORDER_ID,DI.DOC_NO,WO.STATUS,'' AREA_CODE , WO.IS_FORWARDED ,WO.INT_USER_REV_NO, WO.INT_REV_NO ,WO.VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN DOC_INFO DI ON DI.IDOC_ID = WO.OBJECT_ID LEFT JOIN ORDER_MASTER OM ON DI.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.OBJECT_TYPE = 'DOC' UNION ALL SELECT 'Task' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, CASE WHEN ISNULL(wd.DOC_NO,'') = '' THEN WD.TASK_NAME ELSE WD.TASK_NAME+'('+WD.DOC_NO+')' END OBJECT_NO, WD.TASK_NAME OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WR.WF_TEAM_ID, (WD.TASK_NAME+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, WD.CLIENT_DOC_NO CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,WH.ORDER_ID , WD.DOC_NO,WR.STATUS,ORDER_AREA.AREA_CODE AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,WRSS.INT_REV_NO ,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'TSK' AND WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 ) ) INNER JOIN WBS_DETAILS WD ON WD.TASK_ID = WR.OBJECT_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM LEFT JOIN ORDER_AREA ON WD.AREACODE_ID = ORDER_AREA.ORD_AREA_ID LEFT JOIN WBS_HEADER WH ON WD.WBS_ID=WH.WBS_ID LEFT JOIN ORDER_MASTER OM ON WH.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID INNER JOIN WF_RUN_STAGE_STATUS WRSS ON WO.ROUTING_ID = WRSS.ROUTING_ID UNION ALL SELECT 'Task' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, CASE WHEN ISNULL(wd.DOC_NO,'') = '' THEN WD.TASK_NAME ELSE WD.TASK_NAME+'('+WD.DOC_NO+')' END OBJECT_NO, WD.TASK_NAME OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (WD.TASK_NAME+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, WD.CLIENT_DOC_NO CLIENT_DOC_NO, OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,WH.ORDER_ID , WD.DOC_NO,WO.STATUS,ORDER_AREA.AREA_CODE AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,WO.INT_REV_NO ,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN WBS_DETAILS WD ON WD.TASK_ID = WO.OBJECT_ID LEFT JOIN ORDER_AREA ON WD.AREACODE_ID = ORDER_AREA.ORD_AREA_ID LEFT JOIN WBS_HEADER WH ON WD.WBS_ID=WH.WBS_ID LEFT JOIN ORDER_MASTER OM ON WH.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'TSK' UNION ALL SELECT 'Change Proposal' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, CR.CR_REF_NO OBJECT_NO, CR.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (CR.CR_REF_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'DCR' AND WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) INNER JOIN CR_MST CR ON CR.CR_ID = WR.OBJECT_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'Change Proposal' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, CR.CR_REF_NO OBJECT_NO, CR.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON,ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (CR.CR_REF_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION ,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WO.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN CR_MST CR ON CR.CR_ID = WO.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'DCR' UNION ALL SELECT 'Change Note' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, CN.DCN_REF_NO OBJECT_NO, CN.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WR.WF_TEAM_ID, (CN.DCN_REF_NO +CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'DCN' AND WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) INNER JOIN DCN_MST CN ON CN.DCN_ID = WR.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'Change Note' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, CN.DCN_REF_NO OBJECT_NO, CN.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON,ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (CN.DCN_REF_NO +CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION, '' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WO.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN DCN_MST CN ON CN.DCN_ID = WO.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'DCN' UNION ALL SELECT 'BOM' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS ,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'BOM' AND WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) INNER JOIN BOM_HDR BH ON BH.BOM_ID = WR.OBJECT_ID LEFT JOIN PART_MASTER PM ON BH.PARENT_PART_ID = PM.PART_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'BOM' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO ,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WO.STATUS ,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN BOM_HDR BH ON BH.BOM_ID = WO.OBJECT_ID LEFT JOIN PART_MASTER PM ON BH.PARENT_PART_ID = PM.PART_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'BOM' UNION ALL SELECT 'MOM' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, MD.ITEM_DESCRIPTION OBJECT_NO, CASE ISNULL(MD.MOM_ID,'') WHEN '-2' THEN 'OTHERS' ELSE MOM.MOM_REF_NO END OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (MD.ITEM_DESCRIPTION+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,OM.ORDER_ID,'' DOC_NO,WR.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'MOM' AND WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) INNER JOIN MOM_DETAILS MD ON MD.ITEM_ID = WR.OBJECT_ID LEFT JOIN MOM_MASTER MOM ON MD.MOM_ID = MOM.MOM_ID LEFT JOIN ORDER_MASTER OM ON OM.ORDER_ID = MOM.OBJECT_ID AND MOM.OBJECT_TYPE = 'PROJECT' LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'MOM' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, MD.ITEM_DESCRIPTION OBJECT_NO, CASE ISNULL(MD.MOM_ID,'') WHEN '-2' THEN 'OTHERS' ELSE MOM.MOM_REF_NO END OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (MD.ITEM_DESCRIPTION+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO ,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,OM.ORDER_ID,'' DOC_NO,WO.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN MOM_DETAILS MD ON MD.ITEM_ID = WO.OBJECT_ID LEFT JOIN MOM_MASTER MOM ON MD.MOM_ID = MOM.MOM_ID LEFT JOIN ORDER_MASTER OM ON OM.ORDER_ID = MOM.OBJECT_ID AND MOM.OBJECT_TYPE = 'PROJECT' LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR (WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.OBJECT_TYPE = 'MOM' UNION ALL SELECT 'Part' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'PRT' AND WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR (WO.STATUS = 0 AND WO.OPERATION_ID = 4)) INNER JOIN PART_MASTER PM ON PM.PART_ID = WR.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'Part' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION, '' ORDER_ID,'' DOC_NO,WO.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN PART_MASTER PM ON PM.PART_ID = WO.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR (WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.OBJECT_TYPE = 'PRT' Connection Timeout : 0 Queries : SELECT 'Document' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, DI.DOC_NO OBJECT_NO, DI.DOC_DESCRIPTION OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS, REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (DI.DOC_NO+ CHAR(10)+ ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, DI.CLIENT_DOC_NO CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,DI.ORDER_ID,DI.DOC_NO,WR.STATUS,'' AREA_CODE , WO.IS_FORWARDED ,WRSS.INT_USER_REV_NO, WRSS.INT_REV_NO ,WRSS.VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'DOC' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.SENT_TO = N'105057' INNER JOIN DOC_INFO DI ON DI.IDOC_ID = WR.OBJECT_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM LEFT JOIN ORDER_MASTER OM ON DI.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID INNER JOIN WF_RUN_STAGE_STATUS WRSS ON WO.ROUTING_ID = WRSS.ROUTING_ID UNION ALL SELECT 'Document' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, DI.DOC_NO OBJECT_NO, DI.DOC_DESCRIPTION OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS, REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (DI.DOC_NO+ CHAR(10)+ ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, DI.CLIENT_DOC_NO CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,DI.ORDER_ID,DI.DOC_NO,WO.STATUS,'' AREA_CODE , WO.IS_FORWARDED ,WO.INT_USER_REV_NO, WO.INT_REV_NO ,WO.VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN DOC_INFO DI ON DI.IDOC_ID = WO.OBJECT_ID LEFT JOIN ORDER_MASTER OM ON DI.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.OBJECT_TYPE = 'DOC' UNION ALL SELECT 'Task' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, CASE WHEN ISNULL(wd.DOC_NO,'') = '' THEN WD.TASK_NAME ELSE WD.TASK_NAME+'('+WD.DOC_NO+')' END OBJECT_NO, WD.TASK_NAME OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WR.WF_TEAM_ID, (WD.TASK_NAME+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, WD.CLIENT_DOC_NO CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,WH.ORDER_ID , WD.DOC_NO,WR.STATUS,ORDER_AREA.AREA_CODE AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,WRSS.INT_REV_NO ,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'TSK' AND WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 ) ) INNER JOIN WBS_DETAILS WD ON WD.TASK_ID = WR.OBJECT_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM LEFT JOIN ORDER_AREA ON WD.AREACODE_ID = ORDER_AREA.ORD_AREA_ID LEFT JOIN WBS_HEADER WH ON WD.WBS_ID=WH.WBS_ID LEFT JOIN ORDER_MASTER OM ON WH.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID INNER JOIN WF_RUN_STAGE_STATUS WRSS ON WO.ROUTING_ID = WRSS.ROUTING_ID UNION ALL SELECT 'Task' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, CASE WHEN ISNULL(wd.DOC_NO,'') = '' THEN WD.TASK_NAME ELSE WD.TASK_NAME+'('+WD.DOC_NO+')' END OBJECT_NO, WD.TASK_NAME OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (WD.TASK_NAME+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, WD.CLIENT_DOC_NO CLIENT_DOC_NO, OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,WH.ORDER_ID , WD.DOC_NO,WO.STATUS,ORDER_AREA.AREA_CODE AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,WO.INT_REV_NO ,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN WBS_DETAILS WD ON WD.TASK_ID = WO.OBJECT_ID LEFT JOIN ORDER_AREA ON WD.AREACODE_ID = ORDER_AREA.ORD_AREA_ID LEFT JOIN WBS_HEADER WH ON WD.WBS_ID=WH.WBS_ID LEFT JOIN ORDER_MASTER OM ON WH.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'TSK' UNION ALL SELECT 'Change Proposal' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, CR.CR_REF_NO OBJECT_NO, CR.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (CR.CR_REF_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'DCR' AND WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) INNER JOIN CR_MST CR ON CR.CR_ID = WR.OBJECT_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'Change Proposal' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, CR.CR_REF_NO OBJECT_NO, CR.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON,ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (CR.CR_REF_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION ,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WO.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN CR_MST CR ON CR.CR_ID = WO.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'DCR' UNION ALL SELECT 'Change Note' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, CN.DCN_REF_NO OBJECT_NO, CN.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WR.WF_TEAM_ID, (CN.DCN_REF_NO +CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'DCN' AND WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) INNER JOIN DCN_MST CN ON CN.DCN_ID = WR.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'Change Note' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, CN.DCN_REF_NO OBJECT_NO, CN.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON,ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (CN.DCN_REF_NO +CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION, '' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WO.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN DCN_MST CN ON CN.DCN_ID = WO.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'DCN' UNION ALL SELECT 'BOM' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS ,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'BOM' AND WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) INNER JOIN BOM_HDR BH ON BH.BOM_ID = WR.OBJECT_ID LEFT JOIN PART_MASTER PM ON BH.PARENT_PART_ID = PM.PART_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'BOM' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO ,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WO.STATUS ,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN BOM_HDR BH ON BH.BOM_ID = WO.OBJECT_ID LEFT JOIN PART_MASTER PM ON BH.PARENT_PART_ID = PM.PART_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'BOM' UNION ALL SELECT 'MOM' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, MD.ITEM_DESCRIPTION OBJECT_NO, CASE ISNULL(MD.MOM_ID,'') WHEN '-2' THEN 'OTHERS' ELSE MOM.MOM_REF_NO END OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (MD.ITEM_DESCRIPTION+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,OM.ORDER_ID,'' DOC_NO,WR.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'MOM' AND WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) INNER JOIN MOM_DETAILS MD ON MD.ITEM_ID = WR.OBJECT_ID LEFT JOIN MOM_MASTER MOM ON MD.MOM_ID = MOM.MOM_ID LEFT JOIN ORDER_MASTER OM ON OM.ORDER_ID = MOM.OBJECT_ID AND MOM.OBJECT_TYPE = 'PROJECT' LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'MOM' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, MD.ITEM_DESCRIPTION OBJECT_NO, CASE ISNULL(MD.MOM_ID,'') WHEN '-2' THEN 'OTHERS' ELSE MOM.MOM_REF_NO END OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (MD.ITEM_DESCRIPTION+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO ,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,OM.ORDER_ID,'' DOC_NO,WO.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN MOM_DETAILS MD ON MD.ITEM_ID = WO.OBJECT_ID LEFT JOIN MOM_MASTER MOM ON MD.MOM_ID = MOM.MOM_ID LEFT JOIN ORDER_MASTER OM ON OM.ORDER_ID = MOM.OBJECT_ID AND MOM.OBJECT_TYPE = 'PROJECT' LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR (WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.OBJECT_TYPE = 'MOM' UNION ALL SELECT 'Part' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'PRT' AND WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR (WO.STATUS = 0 AND WO.OPERATION_ID = 4)) INNER JOIN PART_MASTER PM ON PM.PART_ID = WR.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'Part' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION, '' ORDER_ID,'' DOC_NO,WO.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN PART_MASTER PM ON PM.PART_ID = WO.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR (WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.OBJECT_TYPE = 'PRT' SELECT COUNT(1) TOTAL_COUNT FROM (SELECT 'Document' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, DI.DOC_NO OBJECT_NO, DI.DOC_DESCRIPTION OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS, REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (DI.DOC_NO+ CHAR(10)+ ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, DI.CLIENT_DOC_NO CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,DI.ORDER_ID,DI.DOC_NO,WR.STATUS,'' AREA_CODE , WO.IS_FORWARDED ,WRSS.INT_USER_REV_NO, WRSS.INT_REV_NO ,WRSS.VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'DOC' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.SENT_TO = N'105057' INNER JOIN DOC_INFO DI ON DI.IDOC_ID = WR.OBJECT_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM LEFT JOIN ORDER_MASTER OM ON DI.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID INNER JOIN WF_RUN_STAGE_STATUS WRSS ON WO.ROUTING_ID = WRSS.ROUTING_ID UNION ALL SELECT 'Document' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, DI.DOC_NO OBJECT_NO, DI.DOC_DESCRIPTION OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS, REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (DI.DOC_NO+ CHAR(10)+ ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, DI.CLIENT_DOC_NO CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,DI.ORDER_ID,DI.DOC_NO,WO.STATUS,'' AREA_CODE , WO.IS_FORWARDED ,WO.INT_USER_REV_NO, WO.INT_REV_NO ,WO.VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN DOC_INFO DI ON DI.IDOC_ID = WO.OBJECT_ID LEFT JOIN ORDER_MASTER OM ON DI.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.OBJECT_TYPE = 'DOC' UNION ALL SELECT 'Task' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, CASE WHEN ISNULL(wd.DOC_NO,'') = '' THEN WD.TASK_NAME ELSE WD.TASK_NAME+'('+WD.DOC_NO+')' END OBJECT_NO, WD.TASK_NAME OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WR.WF_TEAM_ID, (WD.TASK_NAME+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, WD.CLIENT_DOC_NO CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,WH.ORDER_ID , WD.DOC_NO,WR.STATUS,ORDER_AREA.AREA_CODE AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,WRSS.INT_REV_NO ,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'TSK' AND WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 ) ) INNER JOIN WBS_DETAILS WD ON WD.TASK_ID = WR.OBJECT_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM LEFT JOIN ORDER_AREA ON WD.AREACODE_ID = ORDER_AREA.ORD_AREA_ID LEFT JOIN WBS_HEADER WH ON WD.WBS_ID=WH.WBS_ID LEFT JOIN ORDER_MASTER OM ON WH.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID INNER JOIN WF_RUN_STAGE_STATUS WRSS ON WO.ROUTING_ID = WRSS.ROUTING_ID UNION ALL SELECT 'Task' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, CASE WHEN ISNULL(wd.DOC_NO,'') = '' THEN WD.TASK_NAME ELSE WD.TASK_NAME+'('+WD.DOC_NO+')' END OBJECT_NO, WD.TASK_NAME OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID, WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (WD.TASK_NAME+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE, WD.CLIENT_DOC_NO CLIENT_DOC_NO, OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,WH.ORDER_ID , WD.DOC_NO,WO.STATUS,ORDER_AREA.AREA_CODE AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,WO.INT_REV_NO ,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN WBS_DETAILS WD ON WD.TASK_ID = WO.OBJECT_ID LEFT JOIN ORDER_AREA ON WD.AREACODE_ID = ORDER_AREA.ORD_AREA_ID LEFT JOIN WBS_HEADER WH ON WD.WBS_ID=WH.WBS_ID LEFT JOIN ORDER_MASTER OM ON WH.ORDER_ID=OM.ORDER_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'TSK' UNION ALL SELECT 'Change Proposal' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, CR.CR_REF_NO OBJECT_NO, CR.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (CR.CR_REF_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'DCR' AND WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) INNER JOIN CR_MST CR ON CR.CR_ID = WR.OBJECT_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'Change Proposal' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, CR.CR_REF_NO OBJECT_NO, CR.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON,ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (CR.CR_REF_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION ,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WO.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN CR_MST CR ON CR.CR_ID = WO.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'DCR' UNION ALL SELECT 'Change Note' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, CN.DCN_REF_NO OBJECT_NO, CN.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WR.WF_TEAM_ID, (CN.DCN_REF_NO +CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'DCN' AND WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) INNER JOIN DCN_MST CN ON CN.DCN_ID = WR.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'Change Note' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, CN.DCN_REF_NO OBJECT_NO, CN.REMARKS OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON,ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (CN.DCN_REF_NO +CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION, '' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WO.STATUS ,'' AREA_CODE , WO.IS_FORWARDED ,NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN DCN_MST CN ON CN.DCN_ID = WO.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'DCN' UNION ALL SELECT 'BOM' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS ,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'BOM' AND WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) INNER JOIN BOM_HDR BH ON BH.BOM_ID = WR.OBJECT_ID LEFT JOIN PART_MASTER PM ON BH.PARENT_PART_ID = PM.PART_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'BOM' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO ,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WO.STATUS ,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN BOM_HDR BH ON BH.BOM_ID = WO.OBJECT_ID LEFT JOIN PART_MASTER PM ON BH.PARENT_PART_ID = PM.PART_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4 )) AND WO.OBJECT_TYPE = 'BOM' UNION ALL SELECT 'MOM' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, MD.ITEM_DESCRIPTION OBJECT_NO, CASE ISNULL(MD.MOM_ID,'') WHEN '-2' THEN 'OTHERS' ELSE MOM.MOM_REF_NO END OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (MD.ITEM_DESCRIPTION+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,OM.ORDER_ID,'' DOC_NO,WR.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'MOM' AND WO.SENT_TO = N'105057' AND ( WO.STATUS IN (1,3) OR ( WO.STATUS = 0 AND WO.OPERATION_ID = 4)) INNER JOIN MOM_DETAILS MD ON MD.ITEM_ID = WR.OBJECT_ID LEFT JOIN MOM_MASTER MOM ON MD.MOM_ID = MOM.MOM_ID LEFT JOIN ORDER_MASTER OM ON OM.ORDER_ID = MOM.OBJECT_ID AND MOM.OBJECT_TYPE = 'PROJECT' LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'MOM' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, MD.ITEM_DESCRIPTION OBJECT_NO, CASE ISNULL(MD.MOM_ID,'') WHEN '-2' THEN 'OTHERS' ELSE MOM.MOM_REF_NO END OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (MD.ITEM_DESCRIPTION+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO ,OM.ORDER_NO,OM.ORDER_DESCRIPTION,OM.ORDER_SHORT_DESCRIPTION,OM.ORDER_ID,'' DOC_NO,WO.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN MOM_DETAILS MD ON MD.ITEM_ID = WO.OBJECT_ID LEFT JOIN MOM_MASTER MOM ON MD.MOM_ID = MOM.MOM_ID LEFT JOIN ORDER_MASTER OM ON OM.ORDER_ID = MOM.OBJECT_ID AND MOM.OBJECT_TYPE = 'PROJECT' LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR (WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.OBJECT_TYPE = 'MOM' UNION ALL SELECT 'Part' AS OBJ_TYPE, WR.OBJECT_ID, WR.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION,'' ORDER_ID,'' DOC_NO,WR.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY WO OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM INNER JOIN WF_RUN WR ON WO.RUN_ID = WR.RUN_ID AND WR.OBJECT_TYPE = 'PRT' AND WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR (WO.STATUS = 0 AND WO.OPERATION_ID = 4)) INNER JOIN PART_MASTER PM ON PM.PART_ID = WR.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID UNION ALL SELECT 'Part' AS OBJ_TYPE, WO.OBJECT_ID, WO.OBJECT_TYPE, PM.PART_NO OBJECT_NO, PM.PART_DESC OBJECT_DESC, WO.RUN_ID, WO.ROUTING_ID, WO.ROUTING_SUB_ID,WO.OPERATION_ON SEND_ON, ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS) OUTBOX_COMMENTS,REQUEST TASK_FOR_NEXT_STAGE, WFOP.DESCRIPTION ACTION_PERFORMED, 'Click here to get user details' USER_NAMES,WO.WF_TEAM_ID, (PM.PART_NO+CHAR(10)+ISNULL(MCM.MESSAGE_CONTENT,WO.ROUTING_COMMENTS)) AS MERGE_MESSAGE ,NULL MAIL_MESSAGE , '' CLIENT_DOC_NO,'' ORDER_NO,'' ORDER_DESCRIPTION,'' ORDER_SHORT_DESCRIPTION, '' ORDER_ID,'' DOC_NO,WO.STATUS,'' AREA_CODE , WO.IS_FORWARDED , NULL INT_USER_REV_NO ,NULL INT_REV_NO,NULL VERSION_NO FROM WF_RUN_ROUTING_HISTORY_REV WO INNER JOIN PART_MASTER PM ON PM.PART_ID = WO.OBJECT_ID LEFT JOIN WF_OPERATIONS WFOP ON WO.OPERATION_ID = WFOP.OPERATION_ID OUTER APPLY ( SELECT MESSAGE_CONTENT FROM MESSAGE_CONTENT_MASTER WHERE MESSAGE_CONTENT_ID=WO.ROUTING_COMMENTS_ID )MCM WHERE WO.SENT_TO = N'105057' AND (WO.STATUS IN (1,3) OR (WO.STATUS = 0 AND WO.OPERATION_ID = 4)) AND WO.OBJECT_TYPE = 'PRT' ) A ------------------------------------------------------------------------------------------------------------------------------------------------------