select
(select name from tUSER WHERE ID=T.djr) 登记人,
(select tdmc from ttdbm where id=B.td) 团队,
(select name from lborganization l where l.id=T.yyb) 部门,
(select xmjc from tfp_xtjh where id=T.cpid) 项目名称,
SUM(T.sjpssl) 领取数量
--(select TO_char(wm_concat(K.htbh) from TFP_KBHTXX k where ';'||T.PSHT||';' like '%;'||k.id||';%' )合同序号
from TFP_HTXQDJB T,
(select t.dyyh dyyh,t.td td from tryxx t,ttdcy d where d.ryxx=t.id and d.zt=0) B
where T.djr=B.dyyh(+) and T.cpid=2993
and T.PSZT=1 group by B.td,T.cpid,T.yyb,T.djr,T.psht order by B.td
