综合查询

select guid,
djbh,
nd,
pxmc,
pxlb,
sqks,
sqry,
sqrq,
pxdx,
pxkssj,
pxjssj,
pxrs,
pxsxje,
pxdd,
pxnr,
bz,
jfly,
sjbxje,
bxzt,
jfjy,
procinstid,
shzt,
act_status,
jdr,
saas,
sh,
sqryxm,
sqksmc,
jflxmc
from (select guid,
djbh,
nd,
pxmc,
pxlb,
(select ‘(’ || d.dwbh || ‘)’ || d.mc
from dwb d
where sqks = d.guid) sqksmc,
sqks,
(select ‘(’ || d.rybh || ‘)’ || d.xm
from ryb d
where sqry = d.guid) sqryxm,
sqry,
to_char(t.sqrq, ‘yyyy-MM-dd’) sqrq,
pxdx,
to_char(t.pxkssj, ‘yyyy-MM-dd’) pxkssj,
to_char(t.pxjssj, ‘yyyy-MM-dd’) pxjssj,
pxrs,
trim(to_char(nvl(t.pxsxje, ‘0.00’), ‘9999999999999990.00’)) pxsxje,
pxdd,
pxnr,
bz,
jfly,
(select mc
from AC_SYS_DMB C
where C.dm = t.JFLY
and c.zl = ‘jflx’) jflxmc,
trim(to_char(nvl(t.sjbxje, ‘0.00’), ‘9999999999999990.00’)) sjbxje,
bxzt,
trim(to_char(nvl(t.jfjy, ‘0.00’), ‘9999999999999990.00’)) jfjy,
procinstid,
decode(t.shzt,
‘0’,
‘未提交’,
‘1’,
‘待审核’,
‘8’,
‘审核通过’,
‘2’,
‘审核退回’) as shzt,
shzt as sh,
act_status,
jdr,
saas
from nk_pxsqb t
where t.saas = ‘000001’
and jdr = ‘F9A3D2CDB5E6432B865579667341555B’) K
where 1 = 1
and pxmc not in (‘123’)

/* and (nvl(pxmc,0) not in (‘123’))*/
order by DJBH desc