select x.CPID00,Z.YPRKPC,Z.YPNM00,Z.YKBMBH,X.YPBM00 YPBM00,X.YPMLBZ,
Z.YPMC00,Z.YPGG00,X.PYSM00,Z.PDXH00,
X.WBSM00, z.SYRQSJ, z.YPSXRQ,z.PZWH00,z.SCPH00,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.LSJ000 )) LSJ000,Z.PCKC00 KCSL00,
X.KCDW00,TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.GJDJ00)) GJJ000, 
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,X.PFJ000)) PFJ000,
ROUND(TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.LSJ000*Z.PCKC00)),2) KCJE00,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,round(Z.GJDJ00*Z.PCKC00,2))) GJJE00,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,round(X.PFJ000*Z.PCKC00,2))) PFJE00,
DECODE(Z.LSJ000,999999,NULL,X.JLDW00) JLDW00,DECODE(Z.LSJ000,999999,NULL,X.ZYFYDW) ZYFYDW,
DECODE(Z.LSJ000,999999,NULL,X.MZFYDW) MZFYDW,TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,X.Z2J000)) Z2J000,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,X.M2J000)) M2J000,TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.KCSX00)) KCSX00,
TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,X.K2J000)) K2J000,TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.KCXX00)) KCXX00,
ROUND(TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.LSJ000*Z.PCKC00)),2)-ROUND(TO_NUMBER(DECODE(Z.LSJ000,999999,NULL,Z.GJDJ00*Z.PCKC00)),2) CE0000,X.GJJ000 ZXGJDJ,
(SELECT a.GHDWMC FROM BM_YPGHDW a,YK_YPRKD0 b,YK_YPRKMX c WHERE a.GHDWNM=b.GHDWNM and b.RKDH00=c.RKDH00 and c.YPRKPC=Z.YPRKPC and rownum=1) GHDWMC,
(SELECT SCCJZW FROM YK_YPRKMX WHERE YPRKPC=Z.YPRKPC) SCCJZW,'' as SFPS00,
X.ZBQMC0,(SELECT QWM000 FROM YK_YPKCXX WHERE YPNM00=Z.YPNM00 and YKBMBH=Z.YKBMBH and rownum=1) QWM000,Z.ZTBZ00,Z.ZTRQSJ,
decode(sign(nvl(Z.ZTCZY0,0)),-1,'系统',1,(select ZWXM00 from BM_YGBM00 where YGBH00=Z.ZTCZY0),'') ZTCZXM, 
(SELECT CDMC00 FROM YK_YPRKMX WHERE YPRKPC=Z.YPRKPC) CDMC00,X.TXM000,sign(Z.YPRKPC) HJJLS0,decode(Z.YPRKPC,0,0,Z.PCKC00) HJKCSL,
decode(Z.YPGG00,'小计','',(select ZCZXX0 from BM_WZQTXX where YPNM00=Z.YPNM00)) ZCZXX0, 
decode(Z.YPGG00,'小计','',(select ZCZRQ0 from BM_WZQTXX where YPNM00=Z.YPNM00)) ZCZRQ0, 
decode(Z.YPGG00,'小计','',(select ZCSXRQ from BM_WZQTXX where YPNM00=Z.YPNM00)) ZCSXRQ, 
(select MC0000 from BM_TYZD00 where ZDMC00='药典维护-药品性质' and BH0000=X.YPXZ00) YPXZ00, 
(select YLMC00 from BM_YPYL00 where YLBH00=X.YLBH00) YLMC00 
,nvl(X.TZRQ00,'0') TZRQ00 
 from VW_YK_ZJPCKC Z,BM_YD0000 X
 where X.YPNM00=Z.YPNM00
 and ( (X.YLBH00 like '##%'   ) or  ('-1'='-1') )    
 and ((X.TYMBH0='ALL' or 'ALL'='ALL') or ('-1'='-1') ) 
 and Z.YKBMBH=2279
  and nvl(X.TZRQ00,'0') = '0' 
  and exists ( select 1 from YK_YPKCXX where YKBMBH = 2279 AND KCSL00 > 0 ) 
 order by X.YLBH00,X.YPBM00, DECODE(Z.LSJ000,999999,1,0)