SELECTS_LST_OF_VAL.HIGH AS TASK_ORIGINATOR,S_LST_OF_VAL.LOW AS AREA,PARENT.NAME AS SUB_AREA,S_LST_OF_VAL.NAME AS DETAIL,ISNULL(REPLACE(S_ISS.DESC_TEXT, CHAR(10), ''), '') AS SLAFROM S_LST_OF_VAL WITH (NOLOCK)LEFT OUTER JOIN S_LST_OF_VAL PARENT WITH (NOLOCK) ON PARENT.ROW_ID = S_LST_OF_VAL.PAR_ROW_IDLEFT OUTER JOIN S_ISS WITH (NOLOCK) ON S_ISS.X_CLIST_TO = S_LST_OF_VAL.HIGH ANDS_ISS.X_CLIST_AREA = S_LST_OF_VAL.LOW ANDS_ISS.X_CLIST_SAREA = PARENT.NAME ANDS_ISS.X_CLIST_DETAIL = S_LST_OF_VAL.NAMEWHERE  S_LST_OF_VAL.TYPE = '400_SR_DETAIL'AND S_LST_OF_VAL.ACTIVE_FLG = 'Y'AND PARENT.ACTIVE_FLG = 'Y'ORDER BYS_LST_OF_VAL.HIGH,S_LST_OF_VAL.LOW,PARENT.NAME,S_LST_OF_VAL.NAMEGO

Mobile Apps

• Google+
• Twitter
• Periscope
• FOREX Radar