1 16:20:31 Log started for: 住院收费管理系统 2 16:20:48 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(5497624,1143,'WLZX-CQ','5',nvl('1337681223',' '),'192.111.6.20#402:18575@PrjZY_ZYSF.exe+住院收费管理系统',43) 3 16:20:48 SQL Data In: ORACLE - Rows affected = 1 4 16:20:48 SQL Execute: ORACLE - Commit 5 16:20:48 SQL Data In: ORACLE - Rows affected = 0 6 16:20:48 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 43 7 16:20:48 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 8 16:20:48 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 9 16:20:48 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.111.6.20' 10 16:20:48 SQL Execute: ORACLE - select NAME00,VALUE0,SYXT00 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ','YS_TCXTSFTZSZT') 11 16:20:48 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 43 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 12 16:20:48 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 13 16:20:48 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where (nvl(a.YYID00,'0')='222137' or trim(nvl(a.YYID00,'0'))='0') AND (a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'5'||',')>0 ) 14 16:20:50 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 15 16:20:50 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 16 16:20:50 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20180301' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',43,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='5') 17 16:20:52 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') and (SYXT00='999' or instr(','||SYXT00||',',',5,')>0 ) 18 16:20:52 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 19 16:20:52 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_ZY_ZY_BRFY00_INSERT','TR_ZY_ZY_BRJFB0_INSERT', 'TR_ZY_ZY_BRDB00_UPDATE','TR_ZY_ZY_PJSYQK_INSERT', 'TR_ZY_ZY_BRJFB0_UPDATE','TR_ZY_ZY_BRXXB0_INSERT','TR_ZY_ZY_PJSYQK_INSERT') and STATUS = 'ENABLED' 20 16:20:52 SQL Execute: ORACLE - select sysdate nowtime from dual 21 16:20:52 SQL Execute: ORACLE - select SF_ZY_getZDJKSJ('222137') JKSJ00 from dual 22 16:20:52 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 1143 23 16:20:52 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_PJHSC0','ZY_MRNZYH','ZY_DYYBFP','XT_JEQZ00','SF_ZHTYJE','SF_ZHBJJE','ZY_YBJSTKD','ZY_SFYJS0_BZ0000','ZY_WJZBNCY','ZY_PRINTSCALE','ZY_XTDBQX','ZY_XTQFQX','ZY_QXCYQX','ZY_TKPAR0_CZY000','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_YTFSFYXCY','SF_SFSYJZK','ZY_TJKSSJ','ZY_TJJSSJ','SF_YBBRXB','ZY_FPWidth','ZY_FPHeigh','ZY_SYDJKYDBQF','ZY_PJLYXYLYQR','XT_QDXXZHYE','XT_QDXXZHYE_LX','ZY_JKDSFTD','ZY_JKSFAJJBSJ','ZY_ZYJKDGS0','ZY_YJJDJGS','ZY_YBRQDFS','IC_YBYYJKLM','ZY_RYDJSFFZ','ZY_YBBRZFXMFS','SF_ZY_SFZDXS','SF_SFCFFP','ZY_FPTOP','ZY_SFFSXM','ZY_YBFPBH','ZY_SFQZGSYB','ZY_RQDGSCS','YF_ZYFJF_YPNM00','YF_CFMXJE_CZFS','XT_XYCYTCF','ZY_JMXMFS','ZY_EJBBSFCF','ZY_EJBBCFLS','ZY_EJBBCFHS','ZY_CYBRQFMXBB_SFCF','ZY_CYBRQFMXBBLS','ZY_CYBRQFMXBBHS','YF_CFMXJE_SRWS','YF_CFZJE_CZFS','ZY_RQDFPXMSFDY','SF_GFBRJKBXSRDW','YF_CFZJE_SRWS_YB','YF_CFZJE_SRWS','XT_ZYXTSFSYZLK','ZY_ZYXTSFSYZLK',+'YF_CFZJE_CZFS_YB','ZY_RQDMX0_ZFHB','ZY_ZYDJBLHPB','ZY_ZYHSFZDSC','XT_JKTQSJ','ZY_CXJSSFDYDJ','ZY_YBRYSFSYDT','ZY_DYQBFP','ZY_FPLEFT','ZY_SFDYZLD','XT_TFXYSHBZ','ZY_RYDJTCTS','ZY_YJJGS0_SFDYYE','YF_AutoMatch','ZY_SFHHXMMX','ZY_SFDYTKTZS','ZY_JSTKAYJJFS','ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','ZY_SFDYBASY','ZY_SFDYJZD','ZY_FBZHXTYZ','ZY_SFMHEYJKD','ZY_NPYBCYJSXSYBZHZF','ZYSF_TDXMTDKS_YXQF','ZY_CRYTJSFAKS','ZY_PJWLYBNSY','ZY_PRINTBASYZDY','ZY_SFQYCZPJKPJK','ZY_KP_LJDLKPXTFS','ZY_KP_ZYFPDYPLBH','ZY_KP_FPZRDYMS','ZY_ZYFPSFXSFYBF','ZY_QDDYGJBMXSFS','ZY_JSBBSFXSJCJE','ZY_YYBRSFYWFY','BQ_YBCYSFBXLRCYZD','ZY_YBCYJSHZDCSBASY','ZY_JZSRKSSRSFCF','ZY_JZSRKSSRSFZDZTJKD','ZY_YBJKSFJHZHDK','ZY_YBCXJZRQ','ZY_YBFSKSMCZDHZS','ZYSF_RYDJMS','ZYSF_RYDJMRBQ','ZYSF_RYDJMRKS','ZY_WSZBRSFKYXGRYXX','BQ_HLGZLTJSXZDY','BQ_KHLGZLTJZDYID','ZY_JKJZSJSZHZ') 24 16:20:52 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 25 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_SFYDDYJ' 26 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_BASYDYZDYST' 27 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_LXBRSFKYYF' 28 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRQDHZSFTSDY' 29 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFPTCYHZRQDGS' 30 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFABRFYDY' 31 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRNLSFXSDY' 32 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSJD' 33 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_KPYHDYFS' 34 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDBRPXFS' 35 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFMYDYYTYW' 36 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXS0XM' 37 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYKSZDYDY' 38 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJZDY' 39 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_PRINTYJJPJTKZDY' 40 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJDSFTD' 41 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJTKDSFTD' 42 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BRCYJSSFXXCYSH' 43 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDSFXSZFBL' 44 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJFXJZFZDXE' 45 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_JHFPSFTD' 46 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YJJJKZGXE' 47 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CXJSSFSPYCXJSFKCL' 48 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FZFPDYPJXHLX' 49 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZDY_ZYBRWJSFYBB' 50 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_SFQYHZYLJK' 51 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_DATAPATH' 52 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_HZYL_HZYLBRFB' 53 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_KP_CXZRSFZFYFP' 54 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFTSDYZSFP' 55 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_CYSFTSSRJBZD' 56 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BASSMZXXSFSFCLR' 57 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFSYFPXMZMYHJM' 58 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YYIDPDDLKS' 59 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJDTOPLEFT' 60 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00 = 'ZY_YJJTKDTOPLEFT' 61 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZZ0_FQYY' 62 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSXJ' 63 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZYRDSFXSJMJE' 64 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_FPGE00' 65 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXQXRYDJ' 66 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFYXLFYCY' 67 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_MRNZYHFZSFYZ' 68 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFCSSYFMBQBM' 69 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_BDFPQDSFHBXTXM' 70 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_NHSYBRSFAPTLBRY' 71 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDZFBLSFYBBL' 72 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_LSCLSFXZ' 73 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXSYJSBZ' 74 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_SFXMYBJK' 75 16:20:52 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='ZY_SBGSJZFYSPTS' 76 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_GRZFSFBHSB' 77 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_YLJGBH' 78 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJSFPDTMBR' 79 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RQDZFBLSFTXNJYY' 80 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_RYDJZYYSSFYSR' 81 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_ZFYJJSFXZDTZF' 82 16:20:52 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where name00='ZY_QDSFDYZFJE' 83 16:20:52 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL49' order by YBYLZD 84 16:20:52 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBSM01' and YBYLZD<='YBSM16' order by YBYLZD 85 16:20:52 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('ZY_CSBSYBFPSFFKCL','ZY_PRINTYYFYMXZZDY','ZY_WCKSFYXCYJS','ZY_SFQYBASYCSJK','ZY_SFYJKTJ_SFCF','ZY_SFYJKTJLS','ZY_SFYJKTJHS','ZY_YXLFYZFBRCYJS','ZY_QDHZSHTSDY','ZY_ZYYSJZSRXSCYRS','ZY_NHBRSFCSJBZD','ZY_JKJHSFXSJKDH','ZY_ZYBRSFKYZHBRID','ZY_BASYNHBRSFCSICKH','ZY_FPRQDYSFXSDYRQ','ZY_XNHBRSFCSICKH','ZY_YJJYHKTCSFYXJTC','ZY_RYDJZDCSDBJE','ZY_YJJSKSFXSYLMXZ','ZY_SZCYBRSFKYRY','ZY_BRLDTJ_BQ_KS','ZY_YJJYEMXBTITLE','ZY_JKRQXSSFALNYYFS','ZY_NHBRSFFSCYDJRQ','ZY_NBBRXB','ZY_QDDYSFMRQTDYJ','ZY_YBJSRBBSFXSCZYB','ZY_ZFZYBXMTSSB','ZY_JKRQSFGBCXGJKRQ','ZY_ZFBRXB','ZY_BASY_LEFTPAGE','ZY_BASY_TOPPAGE','ZY_PJJHYJJSFXSCXLL','SF_MZFPPDSFXYBR','ZY_CYJSTKAYJJ','ZY_JKDYFWSFYZTYZDZ','ZY_FZFZYBSFXZ','ZY_FPTHBJXX','ZY_NHBRSFMRXM','ZY_FYGZJSSFTSJX','SF_SFSYSFXMZMYHJM','ZY_YBFBZHLBBTSFTS','ZY_YJJSKDJXSZLCK','ZY_SZCYBRTJDYFS','ZY_YJJCKDGS','ZY_ZYBRFBXGYB','ZY_FPSFDYGWYJE','ZY_XNHCSLX','ZY_JKDSFSYFR3XS','ZY_YBFSRYKSSFSYBQ','ZY_GFMZFYWJSSFYXRY','ZY_SFBKGFBR','ZY_BRCYJSTS','ZY_XNHFZXMC','ZY_ZYRQDHZJMJE','ZY_ZYBRXXWFSBASFBHXNH','ZY_XNHBRSFXSYBZHJE','ZY_HSFPJGS','ZY_CYJSSFTSSNBBR','ZY_QDDYSFGJNRCDZDHH','ZY_KZMZFBBRCFFP','ZY_YBBRCYJSSFBCWJ','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM','ZY_SFSYPANHJK','SF_TJKSSJ','SF_TJJSSJ') 86 16:20:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 24, Scale = 0, Data = 非税收入医疗票据开票接口 87 16:20:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_ZY 88 16:20:52 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 89 16:20:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 新农合跨省结报参数 90 16:20:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_ZY 91 16:20:52 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 92 16:20:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 新农合跨省结报参数 93 16:20:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = Xnhksjs_FB 94 16:20:52 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 95 16:20:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 96 16:20:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_ZY 97 16:20:52 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 98 16:20:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 99 16:20:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = JKQYSQM 100 16:20:52 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 101 16:20:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 102 16:20:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = SFJYSZFW 103 16:20:52 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 104 16:20:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数 105 16:20:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = CYJSZFYM 106 16:20:52 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 107 16:20:53 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='5' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='5'))) 108 16:20:53 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '5$%' and A.XTDM00='5' and trim(A.MKDM00)='5$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 109 16:20:53 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 110 16:20:53 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 111 16:20:53 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 112 16:20:53 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 113 16:21:02 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null) 114 16:21:12 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null) 115 16:21:22 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null) 116 16:21:25 SQL Execute: ORACLE - Update ZY_BRDB00 set SFYX00='N' where DBJSRQ||DBJSSJ <= to_char(sysdate,'yyyymmdd' )||to_char(sysdate,'HH24:MI:SS') and SFYX00 = 'Y' 117 16:21:25 SQL Data In: ORACLE - Rows affected = 0 118 16:21:25 SQL Execute: ORACLE - Commit 119 16:21:25 SQL Data In: ORACLE - Rows affected = 0 120 16:21:32 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null) 121 16:21:35 SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = ZYH000 122 16:21:35 SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 123 16:21:35 SQL Execute: ORACLE - BEGIN "SP_XT_SEQ000" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0); END; 124 16:21:41 SQL Execute: ORACLE - select QTLBMC,QTLBBH from VW_BM_BRQTLB where 1=1 order BY QTLBBH 125 16:21:41 SQL Execute: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00 = '9' AND CZBZ00 <> '2' order by bh0000 126 16:21:41 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='医保入院类别对应' order by decode(nvl(xsxh00,0),0,BH0000,XSXH00) 127 16:21:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 343 128 16:21:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = ZY_BRFBBHXSKZ 129 16:21:41 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 130 16:21:41 SQL Execute: ORACLE - select SF_ZY_GETTWOCS(?,?,?) FSLX00 from dual 131 16:21:41 SQL Execute: ORACLE - select * from bm_brztb0 132 16:21:41 SQL Execute: ORACLE - select * from VW_ZY_BRJFLB where JFLBID <> 0 133 16:21:41 SQL Execute: ORACLE - select * from VW_BM_BRFBB0 134 16:21:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 135 16:21:41 SQL Execute: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? order by A.YBLB00 desc 136 16:21:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -2.000000 137 16:21:41 SQL Execute: ORACLE - select FBMC00 from BM_BRFBB0 where FBBH00= ? 138 16:21:41 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='入院途径' AND YXBZ00='1' order by XSXH00 139 16:21:41 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='治疗类别' AND YXBZ00='1' order by XSXH00 140 16:21:41 SQL Execute: ORACLE - select QTLBMC,QTLBBH from VW_BM_FWBJ00 141 16:21:41 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 142 16:21:41 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 143 16:21:41 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000 144 16:21:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 145 16:21:41 SQL Execute: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? order by A.YBLB00 desc 146 16:21:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 147 16:21:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 148 16:21:41 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 149 16:21:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 150 16:21:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 151 16:21:41 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 152 16:21:41 SQL Execute: ORACLE - select * from vw_bm_brzffs where 1=1 and ZFFSBH not in (18,20,26) order by ZFFSBH 153 16:21:41 SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = ZYH000 154 16:21:41 SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 155 16:21:41 SQL Execute: ORACLE - BEGIN "SP_XT_SEQ000" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0); END; 156 16:21:46 SQL Execute: ORACLE - select QTLBMC,QTLBBH from VW_BM_BRQTLB where 1=1 order BY QTLBBH 157 16:21:46 SQL Execute: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00 = '9' AND CZBZ00 <> '2' order by bh0000 158 16:21:46 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='医保入院类别对应' order by decode(nvl(xsxh00,0),0,BH0000,XSXH00) 159 16:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 343 160 16:21:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = ZY_BRFBBHXSKZ 161 16:21:46 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 162 16:21:46 SQL Execute: ORACLE - select SF_ZY_GETTWOCS(?,?,?) FSLX00 from dual 163 16:21:46 SQL Execute: ORACLE - select * from bm_brztb0 164 16:21:46 SQL Execute: ORACLE - select * from VW_ZY_BRJFLB where JFLBID <> 0 165 16:21:46 SQL Execute: ORACLE - select * from VW_BM_BRFBB0 166 16:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 167 16:21:46 SQL Execute: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? order by A.YBLB00 desc 168 16:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -2.000000 169 16:21:46 SQL Execute: ORACLE - select FBMC00 from BM_BRFBB0 where FBBH00= ? 170 16:21:46 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='入院途径' AND YXBZ00='1' order by XSXH00 171 16:21:46 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='治疗类别' AND YXBZ00='1' order by XSXH00 172 16:21:46 SQL Execute: ORACLE - select QTLBMC,QTLBBH from VW_BM_FWBJ00 173 16:21:46 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 174 16:21:46 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 175 16:21:46 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000 176 16:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 177 16:21:46 SQL Execute: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? order by A.YBLB00 desc 178 16:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 179 16:21:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 180 16:21:46 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 181 16:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 182 16:21:46 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 183 16:21:46 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 184 16:21:46 SQL Execute: ORACLE - select * from vw_bm_brzffs where 1=1 and ZFFSBH not in (18,20,26) order by ZFFSBH 185 16:21:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 186 16:21:46 SQL Execute: ORACLE - select * from BM_PJLYQK where PJLXBM = 8 and PJSYR0 = ? and SYBZ00 = 'Y' 187 16:21:46 SQL Data In: ORACLE - Param = 1, Name = P_NAME00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = ZYH000 188 16:21:46 SQL Data In: ORACLE - Param = 2, Name = P_VALUE0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 189 16:21:46 SQL Execute: ORACLE - BEGIN "SP_XT_SEQ000" (P_NAME00 => :P_NAME00,P_VALUE0 => :P_VALUE0); END; 190 16:21:51 SQL Execute: ORACLE - select QTLBMC,QTLBBH from VW_BM_BRQTLB where 1=1 order BY QTLBBH 191 16:21:51 SQL Execute: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00 = '9' AND CZBZ00 <> '2' order by bh0000 192 16:21:51 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='医保入院类别对应' order by decode(nvl(xsxh00,0),0,BH0000,XSXH00) 193 16:21:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 343 194 16:21:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = ZY_BRFBBHXSKZ 195 16:21:51 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 196 16:21:51 SQL Execute: ORACLE - select SF_ZY_GETTWOCS(?,?,?) FSLX00 from dual 197 16:21:51 SQL Execute: ORACLE - select * from bm_brztb0 198 16:21:51 SQL Execute: ORACLE - select * from VW_ZY_BRJFLB where JFLBID <> 0 199 16:21:51 SQL Execute: ORACLE - select * from VW_BM_BRFBB0 200 16:21:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 201 16:21:51 SQL Execute: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? order by A.YBLB00 desc 202 16:21:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -2.000000 203 16:21:51 SQL Execute: ORACLE - select FBMC00 from BM_BRFBB0 where FBBH00= ? 204 16:21:51 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='入院途径' AND YXBZ00='1' order by XSXH00 205 16:21:51 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 WHERE ZDMC00='治疗类别' AND YXBZ00='1' order by XSXH00 206 16:21:51 SQL Execute: ORACLE - select QTLBMC,QTLBBH from VW_BM_FWBJ00 207 16:21:51 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 208 16:21:51 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 209 16:21:51 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='预交金转账单位维护' and trim(MC0000) is not null and YXBZ00='1' order by BH0000 210 16:21:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费 211 16:21:51 SQL Execute: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? order by A.YBLB00 desc 212 16:21:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 213 16:21:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 214 16:21:51 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 215 16:21:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000 216 16:21:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 217 16:21:51 SQL Execute: ORACLE - select SF_ZY_YGXZZF(?,?)FHXX00 from dual 218 16:21:51 SQL Execute: ORACLE - select * from vw_bm_brzffs where 1=1 and ZFFSBH not in (18,20,26) order by ZFFSBH 219 16:21:52 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null) 220 16:21:52 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null) 221 16:22:02 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null) 222 16:22:12 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null) 223 16:22:22 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null) 224 16:22:32 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '5') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',43,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1143,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1143 AND b.JSKSBH = '43') AND (INSTR (',' || a.jsksbh || ',',',43,') > 0 or a.jsksbh is null)