单行查询返回多行记录问题解决---拼接多行查询结果

-------正式脚本
 select 
 '('||T.gw_year||')'||T.gw_year_number||'号' as "任务号" ,
 T.APPLY_TITLE as "标题" ,
 (SELECT S.DEPT_NAME FROM SY_ORG_DEPT S WHERE S.DEPT_CODE = T.S_ODEPT) AS "申请机构" ,
 (SELECT W.DEPT_NAME FROM SY_ORG_DEPT W WHERE W.DEPT_CODE = T.S_DEPT) AS "申请部门" ,
 (SELECT Q.USER_NAME FROM SY_ORG_USER Q WHERE Q.USER_CODE = T.S_USER ) AS "申请人",
 T.USER_TEL as "联系电话", 
 T.S_ATIME as "起草时间",
 T.HT_TOTAL_MONEY as "招投标金额",
 T.Apply_Reason as "用印事由",
 (select wmsys.wm_concat(M.S_DNAME||'-'||M.S_UNAME||':'||M.MIND_CONTENT) from sy_comm_mind_v M WHERE M.DATA_ID = T.APPLY_ID AND M.MIND_CODE LIKE '%SP%') AS "省分公司本级审核意见" ,
 (select wmsys.wm_concat(substr(F.FILE_OBJ,INSTR(F.FILE_OBJ,',', 1, 1)+1))  from seal_file_list F WHERE F.APPLY_ID = T.APPLY_ID)  AS "用印文件"
 from seal_use_apply T
  where T.Code_Path  like '%201206161349120968m60ay%' 
  and T.Apply_Type = 'SEAL_USE_APPLY_ZH' 
  and  T.BELONG_BID = '1' 
  and T.s_atime < '2016-01-01 00:00:00'
  order by T.s_Odept desc ,T.s_Dept asc;