select A.*,A.kcje00-A.GJJE00 as JXCJ00,decode(sign(nvl(A.GYRY00,0)),-1,'系统',1,(select ZWXM00 from BM_YGBM00 where YGBH00=A.GYRY00),'') GYRYXM from 
 ( select KCLSH0,YPNM00,YPBM00,YPMC00,YPGG00,CZFLMC,SCPH00,GJJ000,YKKCXX,SJKCXX,KCJE00,SCCJZW,KCDW00,JLDW00,
 ZYFYDW,MZFYDW,K2ZJJL,ZJJL2J,M2J000,KCXX00,KCSX00,HGH000,PYSM00,WBSM00,SFZTPD,YKRKPC,
 YPMLBZ,LSJ000,YKKCSL,SJKCSL,GJJE00,YFBMBH,LBBH00,YLBH00,JXBH00,TYMBH0,SFYX00,0 PXXH00,  
 0 JXCJ00_HJ,0 GJJE00_HJ,0 KCJE00_HJ,0 JLS000,YPSXRQ,GYRY00,GYRQSJ,TXM000,GHDWMC,YKBMBH,SFBZMC,null BYKSLL,TZRQ00  
 from VW_KS_PCKCXX union all
 select KCLSH0,YPNM00,YPBM00,YPMC00,YPGG00,CZFLMC,SCPH00,GJJ000,YKKCXX,SJKCXX,KCJE00,SCCJZW,KCDW00,JLDW00,
 ZYFYDW,MZFYDW,K2ZJJL,ZJJL2J,M2J000,KCXX00,KCSX00,HGH000,PYSM00,WBSM00,SFZTPD,YKRKPC,
 YPMLBZ,LSJ000,YKKCSL,SJKCSL,GJJE00,YFBMBH,LBBH00,YLBH00,JXBH00,TYMBH0,SFYX00,1 PXXH00,  
KCJE00-GJJE00 as JXCJ00_HJ, GJJE00 GJJE00_HJ,KCJE00 KCJE00_HJ,1 JLS000,YPSXRQ,GYRY00,GYRQSJ,null,null,YKBMBH,SFBZMC,BYKSLL,TZRQ00  
 from VW_KS_PCKCHZ V) A
 where ( (A.YLBH00 like '%'   ) or  (''='-1') )    
 and ((A.TYMBH0='' or ''='ALL') or (''='-1') ) 
 and ((YKBMBH+0=0) or (0=0))
 and TZRQ00 is null
 and A.YPNM00= 
 and A.YFBMBH=102 
 order by YLBH00,YPBM00,PXXH00,YKRKPC