--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:55

RollBack




Elapsed time: 0.004

Select 1 from SF_BRXXB0 where GHH000='10597354'

 and LBBH00='0'


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:57

Select 1 from SF_BRXXB0 where GHH000='10597354'

 and LBBH00='0'




Elapsed time: 0.001

select KLDH00 from IC_YHXX00 where BRID00='5316992'

 and ZT0000='1'


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:57

select KLDH00 from IC_YHXX00 where BRID00='5316992'

 and ZT0000='1'




Elapsed time: 0.001

select ICKH00 from IC_YHXX00 where BRID00='5316992'

 and ZT0000='1'


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:57

select ICKH00 from IC_YHXX00 where BRID00='5316992'

 and ZT0000='1'




Elapsed time: 0.001

Select SYSDATE from Dual


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:57

Select SYSDATE from Dual




Elapsed time: 0.001

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'SLE4428'

and KLDH00 not in ('CK','JMCK')


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:57

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'SLE4428'

and KLDH00 not in ('CK','JMCK')




Elapsed time: 0.002

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'SLE4442'

and KLDH00 not in ('CK','JMCK')


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:57

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'SLE4442'

and KLDH00 not in ('CK','JMCK')




Elapsed time: 0.001

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'YB-MMRK'

and KLDH00 not in ('CK','JMCK')


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:57

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'YB-MMRK'

and KLDH00 not in ('CK','JMCK')




Elapsed time: 0.001

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'YB-CPUK'

and KLDH00 not in ('CK','JMCK')


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:57

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'YB-CPUK'

and KLDH00 not in ('CK','JMCK')




Elapsed time: 0.001

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'YB-SBK'

and KLDH00 not in ('CK','JMCK')


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:57

Select KLDH00,KLLB00,KHQZBH from IC_KLDM00

where SYBZ00 <> '0'

and KLDH00 not in ('ALL','YY-ALL','YB-ALL')

and KLDH00 = 'YB-SBK'

and KLDH00 not in ('CK','JMCK')




Elapsed time: 0.003

select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00

where ICKH00 = 'MMRKE10834625'

and ICKNBH = 'MMRKE10834625'


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00

where ICKH00 = 'MMRKE10834625'

and ICKNBH = 'MMRKE10834625'




Elapsed time: 0.002

select * from VW_YS_YBFDMYPSR

 where YFBMBH=:1

 and YPNM00=:2 and SJKCSL>0 


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select * from VW_YS_YBFDMYPSR

 where YFBMBH='47'

 and YPNM00='14644' and SJKCSL>0 




:1=['47']
:2=['14644']


Elapsed time: 0.002

select SF_YS_TSBZJYMXBZD('M04301',15984620) MSG from dual 


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select SF_YS_TSBZJYMXBZD('M04301',15984620) MSG from dual 




Elapsed time: 0.002

select LBBH00 from  vw_ys_ypkcxx where ypnm00=:1 and yfbmbh=:2


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select LBBH00 from  vw_ys_ypkcxx where ypnm00='14644' and yfbmbh='47'




:1=['14644']
:2=['47']


Elapsed time: 0.001

select BZ0000 from  bm_tyzd00 where zdmc00='Õï¶Ï´¦·½ÌìÊýÏÞÖÆ' and MC0000=:1 and rownum=1


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select BZ0000 from  bm_tyzd00 where zdmc00='Õï¶Ï´¦·½ÌìÊýÏÞÖÆ' and MC0000='' and rownum=1




:1=['']


Elapsed time: 0.001

SELECT NDJCTS FROM BM_YD0000 WHERE YPNM00=:1


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

SELECT NDJCTS FROM BM_YD0000 WHERE YPNM00=0.146440000e+005




:1=[0.146440000e+005]


Elapsed time: 0.001

BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00,p_ksbh00 => :p_ksbh00); END;
Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00,p_ksbh00 => :p_ksbh00); END;


:1=['<?€']
:2=['<?€']
:3=['<?€']
:4=['<?€']
:5=['<?€']
:6=['<?€']
:7=['<?€']
:8=['<?€']
:9=['<?€']
:10=['<?€']
:11=['<?€']
p_ypnm00=['14644']
p_mcsl00=[0.100000000e+002]
p_z2j000=[0.120000000e+003]
p_pcid00=['2']
p_zqs000=[0.100000000e+001]
Result=['1']
p_brid00=[0.531699200e+007]
p_sftsbz=['Y']
p_f2j000=[0.100000000e+001]
p_ghid00=[0.159846200e+008]
p_ksbh00=[0.390000000e+003]


Elapsed time: 0.007

 select count(*) COU from BM_TYZD00 where ZDMC00='ÈËÁ÷¿ØÖÆҩƷĿ¼'  and DJ0000 in (14644)


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

 select count(*) COU from BM_TYZD00 where ZDMC00='ÈËÁ÷¿ØÖÆҩƷĿ¼'  and DJ0000 in (14644)




Elapsed time: 0.001

select YPXZ00 from BM_YD0000 where YPNM00=14644


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select YPXZ00 from BM_YD0000 where YPNM00=14644




Elapsed time: 0.000

select b.YPMC00,b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00  from BM_YD0000 b where YPNM00=14644


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select b.YPMC00,b.CFJB00,b.DPDJ00,b.MZDJ00,b.SJDJ00,b.KSSJB0,b.GZDJ00,YPNM00  from BM_YD0000 b where YPNM00=14644




Elapsed time: 0.001

Delete from ys_cfmx00 where cflsh0='10023155' and cfid00 not in (-1)


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

Delete from ys_cfmx00 where cflsh0='10023155' and cfid00 not in (-1)




Elapsed time: 0.001

insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, YYSJ00, YYSJDW, YYZF00 , ZB0000, PSLBID, SFZBY0,YPZSL0, CFDW00, ZHL000, ZQCS00, ZFBL00, YBLB00, THBZ00,ZXCS00,TSYS00,CQLY00,F2J000,ZFFSBZ)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '10023155','14644','ÍÐÀ­ÈûÃ×Ƭ£¨ÌØËÕÃô£©£¨X£©','10mg*12Ƭ','25.02','001','2','10','mg','1','Ìì','','','','N','1','ºÐ','120','1','0','5','0','1','','','1','N')


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, YYSJ00, YYSJDW, YYZF00 , ZB0000, PSLBID, SFZBY0,YPZSL0, CFDW00, ZHL000, ZQCS00, ZFBL00, YBLB00, THBZ00,ZXCS00,TSYS00,CQLY00,F2J000,ZFFSBZ)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '10023155','14644','ÍÐÀ­ÈûÃ×Ƭ£¨ÌØËÕÃô£©£¨X£©','10mg*12Ƭ','25.02','001','2','10','mg','1','Ìì','','','','N','1','ºÐ','120','1','0','5','0','1','','','1','N')




Elapsed time: 0.003

Insert into ys_cfxxb0 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,DJH000,BRLB00,YSGZH0,SSKS00,GHKS00,YPDLBH,CFXZ00,ZYTS00,ZYDJS0,BZID00,CFZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFMBMC,CFZJE0,BRDZ00,TSBZBH,TSYS00,BRZJBH,YBSSSH,YZYZM0,YPXZ00) Values ('10023155','47','15984620','10597354','5316992','ÁÖº£ÕÇ','ÄÐ',0,'3','2433','394','390','0','0',1,0,0,'1',0,'2433',to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),null,25.02,null,'M04301',-1,'350628193807261512','0','','4')


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

Insert into ys_cfxxb0 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,DJH000,BRLB00,YSGZH0,SSKS00,GHKS00,YPDLBH,CFXZ00,ZYTS00,ZYDJS0,BZID00,CFZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFMBMC,CFZJE0,BRDZ00,TSBZBH,TSYS00,BRZJBH,YBSSSH,YZYZM0,YPXZ00) Values ('10023155','47','15984620','10597354','5316992','ÁÖº£ÕÇ','ÄÐ',0,'3','2433','394','390','0','0',1,0,0,'1',0,'2433',to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),null,25.02,null,'M04301',-1,'350628193807261512','0','','4')




Elapsed time: 0.002

select SQ_YS_CFSHRZ_ID0000.NEXTVAL from dual


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select SQ_YS_CFSHRZ_ID0000.NEXTVAL from dual




Elapsed time: 0.011

select a.* from BM_TYZD00 a where ZDMC00='ºÏÀíÓÃÒ©' and BH0000 in('HLYYCJDM','HLYYSHOWMODE','YS_DDSXJG00') 


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select a.* from BM_TYZD00 a where ZDMC00='ºÏÀíÓÃÒ©' and BH0000 in('HLYYCJDM','HLYYSHOWMODE','YS_DDSXJG00') 




Elapsed time: 0.002

select MC0000,BZ0000,BH0000 from BM_TYZD00 where ZDMC00='ºÏÀíÓÃÒ©' AND YXBZ00='1' and BZ0000='Ò½Ôº´úÂë' order by XSXH00 


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select MC0000,BZ0000,BH0000 from BM_TYZD00 where ZDMC00='ºÏÀíÓÃÒ©' AND YXBZ00='1' and BZ0000='Ò½Ôº´úÂë' order by XSXH00 




Elapsed time: 0.001

select GHID00,BRID00,BRXM00,XB0000,CFZJE0,ZYTS00,SRRQ00,SRSJ00,YPDLBH,(select c.LBMC00 from SF_BRXXB0 b,BM_GHLBB0 c where b.GHID00=a.GHID00 and b.LBBH00=c.LBBH00) GHLBMC 

,GHKS00,YSGZH0

,(select BMMC00 from BM_BMBM00 where BMBH00=a.GHKS00) JZKSMC 

,(select BRZJBH from BM_BRXXB0 where BRID00=a.BRID00) BRZJBH 

,(select SF_YS_CSRQTONL(BRCSRQ) from BM_BRXXB0 where BRID00=a.BRID00) NL0000 

,(select KMH000 from IC_YHXX00 where BRID00=a.BRID00 and ZT0000='1') KMH000 

,(select FBBH00 from BM_BRXXB0 where BRID00=a.BRID00) FBBH00 

,(select ZWXM00 from BM_YGBM00 where YGBH00=a.YSGZH0) KDYSXM 

,(select XKH000 from BM_YGBM00 where YGBH00=a.YSGZH0) XKH000 

from YS_CFXXB0 a where CFLSH0='10023155'


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select GHID00,BRID00,BRXM00,XB0000,CFZJE0,ZYTS00,SRRQ00,SRSJ00,YPDLBH,(select c.LBMC00 from SF_BRXXB0 b,BM_GHLBB0 c where b.GHID00=a.GHID00 and b.LBBH00=c.LBBH00) GHLBMC 

,GHKS00,YSGZH0

,(select BMMC00 from BM_BMBM00 where BMBH00=a.GHKS00) JZKSMC 

,(select BRZJBH from BM_BRXXB0 where BRID00=a.BRID00) BRZJBH 

,(select SF_YS_CSRQTONL(BRCSRQ) from BM_BRXXB0 where BRID00=a.BRID00) NL0000 

,(select KMH000 from IC_YHXX00 where BRID00=a.BRID00 and ZT0000='1') KMH000 

,(select FBBH00 from BM_BRXXB0 where BRID00=a.BRID00) FBBH00 

,(select ZWXM00 from BM_YGBM00 where YGBH00=a.YSGZH0) KDYSXM 

,(select XKH000 from BM_YGBM00 where YGBH00=a.YSGZH0) XKH000 

from YS_CFXXB0 a where CFLSH0='10023155'




Elapsed time: 0.002

select (select YSLBMC from bm_yslb00 where YSLB00=a.YSLB00) YSLBMC,ZWXM00 from bm_ygbm00 a where ygbh00=:1


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select (select YSLBMC from bm_yslb00 where YSLB00=a.YSLB00) YSLBMC,ZWXM00 from bm_ygbm00 a where ygbh00='2433'




:1=['2433']


Elapsed time: 0.001

select * from VW_YS_BRXXB0 where BRID00=:1


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select * from VW_YS_BRXXB0 where BRID00='5316992'




:1=['5316992']


Elapsed time: 0.003

select ZDXXID,trim(ICD900) ICD900,ZDMC00,decode(ZZDBZ0,'3',0,1) ZZDBZ0,decode(SFXYZD,'1',2,0) as diagnose_type,decode(ZZDBZ0,'1','ÖÐÒ½Õï¶Ï','2','Ö¤ÐÍ','Î÷Ò½Õï¶Ï') ZDLB00 ,ZDRQ00,ZDSJ00   

,a.JZKS00,(select BMMC00 from BM_BMBM00 where BMBH00=a.JZKS00) JZKSMC 

,a.JZYS00,JZYSXM 

 from ys_brzdxx a 

where a.ghid00=:1 order by decode(ZZDBZ0,'3',0,1)  


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select ZDXXID,trim(ICD900) ICD900,ZDMC00,decode(ZZDBZ0,'3',0,1) ZZDBZ0,decode(SFXYZD,'1',2,0) as diagnose_type,decode(ZZDBZ0,'1','ÖÐÒ½Õï¶Ï','2','Ö¤ÐÍ','Î÷Ò½Õï¶Ï') ZDLB00 ,ZDRQ00,ZDSJ00   

,a.JZKS00,(select BMMC00 from BM_BMBM00 where BMBH00=a.JZKS00) JZKSMC 

,a.JZYS00,JZYSXM 

 from ys_brzdxx a 

where a.ghid00='15984620' order by decode(ZZDBZ0,'3',0,1)  




:1=['15984620']


Elapsed time: 0.001

select  a.*,b.YFBMBH,b.GHID00,b.BRID00,b.BRXM00,b.GHKS00,b.CFZJE0,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00,(select LBBH00 from BM_YD0000 where YPNM00=a.YPNM00) YPLBBH 

,(select XGCFZL from BM_YD0000 where YPNM00=a.YPNM00) XGCFZL  

,(select PCMC00 from BM_PC0000 where PCID00=a.PCID00) PCMC  

,(select YPYFMC from BM_YPYF00 where YFID00=a.YFID00) YFMC  

,(select PZWH00 from BM_YD0000 where YPNM00=a.YPNM00) PZWH00  

,(select JXMC00 from BM_YD0000 c,BM_YPJX00 d where YPNM00=a.YPNM00 and c.JXBH00=d.JXBH00 and d.LBBH00=c.LBBH00 and rownum=1) JXMC00  

,round(a.LSDJ00*a.YPZSL0,2) ZFJE00

 from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0='10023155' and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select  a.*,b.YFBMBH,b.GHID00,b.BRID00,b.BRXM00,b.GHKS00,b.CFZJE0,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00,(select LBBH00 from BM_YD0000 where YPNM00=a.YPNM00) YPLBBH 

,(select XGCFZL from BM_YD0000 where YPNM00=a.YPNM00) XGCFZL  

,(select PCMC00 from BM_PC0000 where PCID00=a.PCID00) PCMC  

,(select YPYFMC from BM_YPYF00 where YFID00=a.YFID00) YFMC  

,(select PZWH00 from BM_YD0000 where YPNM00=a.YPNM00) PZWH00  

,(select JXMC00 from BM_YD0000 c,BM_YPJX00 d where YPNM00=a.YPNM00 and c.JXBH00=d.JXBH00 and d.LBBH00=c.LBBH00 and rownum=1) JXMC00  

,round(a.LSDJ00*a.YPZSL0,2) ZFJE00

 from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0='10023155' and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00




Elapsed time: 0.002

delete YS_CFSHRZ where CFLSH0='10023155'


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

delete YS_CFSHRZ where CFLSH0='10023155'




Elapsed time: 0.001

insert into YS_CFSHRZ(ID0000,CFLSH0,YPNM00,SHJGDM,SHJG00,YPQLPC,JGLX00,SHJY00) values('183884','10023155',14644,'1','Õï¶Ï³¬³ö˵Ã÷ÊéÊÊÓ¦Ö¢·¶Î§',10023155,'»¼ÕßÌõ¼þ','Õï¶ÏÓ¦·ûºÏ˵Ã÷ÊéÊÊÓ¦Ö¢·¶Î§')


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

insert into YS_CFSHRZ(ID0000,CFLSH0,YPNM00,SHJGDM,SHJG00,YPQLPC,JGLX00,SHJY00) values('183884','10023155',14644,'1','Õï¶Ï³¬³ö˵Ã÷ÊéÊÊÓ¦Ö¢·¶Î§',10023155,'»¼ÕßÌõ¼þ','Õï¶ÏÓ¦·ûºÏ˵Ã÷ÊéÊÊÓ¦Ö¢·¶Î§')




Elapsed time: 0.002

select a.*,(select max(SHJGDM) from YS_CFSHRZ where ID0000=a.ID0000) SHJGDM from VW_YS_CFSHRZ a where ID0000=183884


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:49:58

select a.*,(select max(SHJGDM) from YS_CFSHRZ where ID0000=a.ID0000) SHJGDM from VW_YS_CFSHRZ a where ID0000=183884




Elapsed time: 0.004

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 = '8') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',390,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',2433,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =2433 AND b.JSKSBH = '390')

  AND (INSTR (',' || a.jsksbh || ',',',390,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:00

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 = '8') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',390,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',2433,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =2433 AND b.JSKSBH = '390')

  AND (INSTR (',' || a.jsksbh || ',',',390,') > 0 or a.jsksbh is null)  




Elapsed time: 0.001

select * from BM_TYCJBM where CJBM00='' and SFQY00='1' 


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:03

select * from BM_TYCJBM where CJBM00='' and SFQY00='1' 




Elapsed time: 0.001

delete  YS_CFSHJG where MZZYBZ='0' and GHID00=15984620


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:03

delete  YS_CFSHJG where MZZYBZ='0' and GHID00=15984620




Elapsed time: 0.001

insert into YS_CFSHJG(GHID00,SHJGDM,SHJG00,MZZYBZ) select 15984620,SHJGDM,SHJG00,0 from (select SHJGDM,SHJG00 from YS_CFSHRZ where ID0000=183884 order by to_number(SHJGDM) desc) where rownum=1 


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:03

insert into YS_CFSHJG(GHID00,SHJGDM,SHJG00,MZZYBZ) select 15984620,SHJGDM,SHJG00,0 from (select SHJGDM,SHJG00 from YS_CFSHRZ where ID0000=183884 order by to_number(SHJGDM) desc) where rownum=1 




Elapsed time: 0.003

 update YS_CFMX00 a set TSYS00=nvl((select SHJGDM from YS_CFSHRZ where ID0000=183884 and YPNM00=a.YPNM00 and rownum=1 and SHJGDM<>'6'),null)  where CFLSH0='10023155' 


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:03

 update YS_CFMX00 a set TSYS00=nvl((select SHJGDM from YS_CFSHRZ where ID0000=183884 and YPNM00=a.YPNM00 and rownum=1 and SHJGDM<>'6'),null)  where CFLSH0='10023155' 




Elapsed time: 0.004

insert into YF_MZCF00 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,CSRQ00,DJH000,YSGZH0,YSXM00,SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,CFZT00,SFKSLY,PSZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,BZ0000,CFSRBZ,ZYDJS0,ZYMRCS,BCCFH0,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH,YZYZM0,YPXZ00,WGCFBZ,LYKS00)select CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,'19380726',DJH000,YSGZH0,'»ÆÎÄȪ',SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,a.BZID00,BZMC00,'0','N','0',FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,null,'0',ZYDJS0,ZYMRCS,'',TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH,YZYZM0,YPXZ00,WGCFBZ ,'' from YS_CFXXB0 a,BM_DMZD00 b where a.bzid00=b.bzid00(+) and CFLSH0='10023155'


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:03

insert into YF_MZCF00 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,CSRQ00,DJH000,YSGZH0,YSXM00,SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,CFZT00,SFKSLY,PSZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,BZ0000,CFSRBZ,ZYDJS0,ZYMRCS,BCCFH0,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH,YZYZM0,YPXZ00,WGCFBZ,LYKS00)select CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,'19380726',DJH000,YSGZH0,'»ÆÎÄȪ',SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,a.BZID00,BZMC00,'0','N','0',FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,null,'0',ZYDJS0,ZYMRCS,'',TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS,TSYS00,DYCJSL,DYCJQL,DECJSL,DECJQL,BRZJBH,YZYZM0,YPXZ00,WGCFBZ ,'' from YS_CFXXB0 a,BM_DMZD00 b where a.bzid00=b.bzid00(+) and CFLSH0='10023155'




Elapsed time: 0.003

insert into YF_MZCFMX(CFID00,CFLSH0,YPNM00,YPMC00,YPGG00,LSDJ00,YPYFMC,PCMC00,CSL000,JLDW00,YYSJ00,YYSJDW,YFSMMC,ZB0000,ZJYFMC,XMYFMC,YPZSL0,CFDW00,ZHL000,CXBZ00,SFXS00,SFZBY0,THBZ00,PSLBID,ZFBL00,YBLB00,BZ0000,ZXCS00, CQLY00,F2J000,TSYS00,ZFFSBZ,SQYS00)select a.CFID00,a.CFLSH0,a.YPNM00,a.YPMC00,a.YPGG00,(a.LSDJ00*d.NSBL00),b.YPYFMC,c.PCMC00,(DECODE(A.CSL000,NULL,NULL,(ROUND((a.CSL000/d.NSBL00),4)))),a.JLDW00,a.YYSJ00,a.YYSJDW,a.YYZF00,a.ZB0000,b.YPYFMC,a.XMYFMC,(ROUND((a.YPZSL0/d.NSBL00),3)),a.CFDW00,a.ZHL000,'Z','Y',SFZBY0,'0',a.PSLBID,a.ZFBL00,a.YBLB00,a.YYZF00,ZXCS00, a.CQLY00, a.F2J000,a.TSYS00,a.ZFFSBZ,decode(a.TSYS00,7,2433,0) from YS_CFMX00 a,BM_YPYF00 b,BM_PC0000 c, BM_YD0000 d where a.YPNM00=d.YPNM00 AND a.CFLSH0='10023155' and a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+)


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:03

insert into YF_MZCFMX(CFID00,CFLSH0,YPNM00,YPMC00,YPGG00,LSDJ00,YPYFMC,PCMC00,CSL000,JLDW00,YYSJ00,YYSJDW,YFSMMC,ZB0000,ZJYFMC,XMYFMC,YPZSL0,CFDW00,ZHL000,CXBZ00,SFXS00,SFZBY0,THBZ00,PSLBID,ZFBL00,YBLB00,BZ0000,ZXCS00, CQLY00,F2J000,TSYS00,ZFFSBZ,SQYS00)select a.CFID00,a.CFLSH0,a.YPNM00,a.YPMC00,a.YPGG00,(a.LSDJ00*d.NSBL00),b.YPYFMC,c.PCMC00,(DECODE(A.CSL000,NULL,NULL,(ROUND((a.CSL000/d.NSBL00),4)))),a.JLDW00,a.YYSJ00,a.YYSJDW,a.YYZF00,a.ZB0000,b.YPYFMC,a.XMYFMC,(ROUND((a.YPZSL0/d.NSBL00),3)),a.CFDW00,a.ZHL000,'Z','Y',SFZBY0,'0',a.PSLBID,a.ZFBL00,a.YBLB00,a.YYZF00,ZXCS00, a.CQLY00, a.F2J000,a.TSYS00,a.ZFFSBZ,decode(a.TSYS00,7,2433,0) from YS_CFMX00 a,BM_YPYF00 b,BM_PC0000 c, BM_YD0000 d where a.YPNM00=d.YPNM00 AND a.CFLSH0='10023155' and a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+)




Elapsed time: 0.005

BEGIN "SP_YF_YPKCSLYKNEW" (AS_CFLSH0 => :AS_CFLSH0,AD_GHID00 => :AD_GHID00,AD_YFBMBH => :AD_YFBMBH,AD_CFID00 => :AD_CFID00,AD_CZBZ00 => :AD_CZBZ00); END;
Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:03

BEGIN "SP_YF_YPKCSLYKNEW" (AS_CFLSH0 => :AS_CFLSH0,AD_GHID00 => :AD_GHID00,AD_YFBMBH => :AD_YFBMBH,AD_CFID00 => :AD_CFID00,AD_CZBZ00 => :AD_CZBZ00); END;


:1=['??€']
:2=['??€']
:3=['??€']
:4=['??€']
:5=['??€']
AS_CFLSH0=['10023155']
AD_GHID00=['15984620']
AD_YFBMBH=['47']
AD_CFID00=['0']
AD_CZBZ00=['0']


Elapsed time: 0.001

BEGIN "SP_YS_YWMZCF" (AS_CFLSH0 => :AS_CFLSH0); END;
Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:03

BEGIN "SP_YS_YWMZCF" (AS_CFLSH0 => :AS_CFLSH0); END;


:1=['|
?€']
AS_CFLSH0=['10023155']


Elapsed time: 0.001

BEGIN "SP_YS_YJXMZDDC" (AS_YZCFID => :AS_YZCFID,AD_ZYGHID => :AD_ZYGHID,AS_LRXM00 => :AS_LRXM00,AS_JZBZ00 => :AS_JZBZ00,AS_ZYCFPD => :AS_ZYCFPD); END;
Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:03

BEGIN "SP_YS_YJXMZDDC" (AS_YZCFID => :AS_YZCFID,AD_ZYGHID => :AD_ZYGHID,AS_LRXM00 => :AS_LRXM00,AS_JZBZ00 => :AS_JZBZ00,AS_ZYCFPD => :AS_ZYCFPD); END;


:1=['K?€']
:2=['K?€']
:3=['K?€']
:4=['K?€']
:5=['K?€']
AS_YZCFID=['10023155']
AD_ZYGHID=['10597354']
AS_LRXM00=['»ÆÎÄȪ']
AS_JZBZ00=['N']
AS_ZYCFPD=['0']


Elapsed time: 0.140



V_FLAG00=[0.0e+2147483647]
V_GHZYID=[0.159846200e+008]
V_RETURN=[0.200000000e+001]
V_ERROR0=['µ±Ç°²¡È˵ĵ±Ìì´¦·½×ܽð¶î³¬¹ý½ûÓýð¶î£º350']
V_SFZDZD=[0.0e+2147483647]
P_CFLSH0=['10023155']
P_YSBH00=['2433']


Elapsed time: 2.129

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 = '8') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',390,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',2433,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =2433 AND b.JSKSBH = '390')

  AND (INSTR (',' || a.jsksbh || ',',',390,') > 0 or a.jsksbh is null)  


Error occurred: [1036] (ORA-01036: ·Ç·¨µÄ±äÁ¿Ãû/±àºÅ
)

--------------------------------------------------------------------------------
Timestamp: 2021-03-11 15:50:10

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 = '8') )

 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',390,')> 0)

 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',2433,')> 0)

 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =2433 AND b.JSKSBH = '390')

  AND (INSTR (',' || a.jsksbh || ',',',390,') > 0 or a.jsksbh is null)  




Elapsed time: 0.001