/* */ 20201225 18:06:48 select a.brxm00 cname,a.zlxmjc testitemname,a.zy0000 REPORTVALUEALL,a.ywid00 SAMPLENO,a.yjdjh0,a.Zdclr0 from VW_ZS_WJZTX0_ZYDZBL a,zy_brxxb0 z where a.Zyghid=z.zyid00 and a.sftxbq='1' and SFZZJS='0' and ((KDKSBH = 2236 and Zdclr0 = 4960) or (KDKSBH = 2236 and zdclr0 is null)) /* */ 20201225 18:06:48 select * from xt_xttsxx where xtdm00='V ' and zt0000='0' and czyxm0='医惠' and jsrbh0='4960' /* */ 20201225 18:06:48 select SSSFTB,SHBZ00 from BA_BRZYXX where lsh000 = 6052748 /* */ 20201225 18:06:47 Insert into BA_BRSSXX(ID0000,LSH000,SSXH00,SSLB00,SSM000,SSMC00,SSRQ00,SSSJ00,SSZL00,SSYS00,SSYSMC,IYS000, IYSMC0,IIYS00,IIYSMC, MZFS00,QKYHDJ,MZYS00,MZYSMC,CZRQ00,CZSJ00,CZY000,FWMC00,BWMC00,BCSM00) values(SQ_BA_BRSSXX_ID0000.nextval,:LSH000,(SELECT nvl(max(a.ssxh00),0)+1 FROM BA_BRSSXX a WHERE a.LSH000 =:LSH001),:SSLB00,:SSM000,:SSMC00,:SSRQ00,:SSSJ00,:SSZL00,:SSYS00, :SSYSMC,:IYS000,:IYSMC0,:IIYS00,:IIYSMC,:MZFS00,:QKYHDJ,:MZYS00,:MZYSMC,:CZRQ00,:CZSJ00,:CZY000,:FWMC00,:BWMC00,:BCSM00 :SSCXSJ,:MZFJ00) /* */ 20201225 18:06:46 select RYRQ00,CYDJRQ from ZY_BRXXB0 where ZYID00 =6052748 /* */ 20201225 18:06:46 select SP_SF_CHECKSFZH('350127197110114357') from dual /* */