1       08:43:05  SQL Execute: ORACLE - select GHLBBH,GHLBMC,GHXHS0,GHYGHS from SF_YSGHHB where GHKSBH=474 and GHYSBH=1197 and GHMZSJ=TO_CHAR(sysdate,'YYYYMMDD') and GHQSSJ<=TO_CHAR(sysdate,'HH24:MI:SS') and GHJSSJ>=TO_CHAR(sysdate,'HH24:MI:SS')

2       08:43:05  SQL Execute: ORACLE - select sf_ys_ghxz00(474,1197,601750) from dual

3       08:43:05  SQL Execute: ORACLE - select LBMC00,LBBH00 from VW_BM_GHLBB0
 where  lbbh00 in (4,40,45 ) 

4       08:43:05  SQL Execute: ORACLE - select HZLBMC,HZLB00 from BM_HZLB00

5       08:43:05  SQL Execute: ORACLE - select GHLBBH,GHLBMC from SF_YSGHHB where GHKSBH=474
 and GHYSBH=1197 and GHMZSJ=to_char(sysdate,'yyyymmdd')
 and GHQSSJ<=to_char(sysdate,'hh24:mi:ss')
 and GHJSSJ>=to_char(sysdate,'hh24:mi:ss')

6       08:43:05  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 601750.000000
7       08:43:05  SQL Data In: ORACLE - Param = 2, Name = PGHLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
8       08:43:05  SQL Data In: ORACLE - Param = 3, Name = PGHKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
9       08:43:05  SQL Data In: ORACLE - Param = 4, Name = PBRLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
10      08:43:05  SQL Data In: ORACLE - Param = 5, Name = PYDJM00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
11      08:43:05  SQL Data In: ORACLE - Param = 6, Name = PSFYY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
12      08:43:05  SQL Data In: ORACLE - Param = 7, Name = PSFGHF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
13      08:43:05  SQL Data In: ORACLE - Param = 8, Name = PGHFZJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
14      08:43:05  SQL Data In: ORACLE - Param = 9, Name = PGHXJJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
15      08:43:05  SQL Data In: ORACLE - Param = 10, Name = PGHYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
16      08:43:05  SQL Data In: ORACLE - Param = 11, Name = PGHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
17      08:43:05  SQL Execute: ORACLE - BEGIN "SP_YS_GHF000" (PBRID00 => :PBRID00,PGHLB00 => :PGHLB00,PGHKS00 => :PGHKS00,PBRLB00 => :PBRLB00,PYDJM00 => :PYDJM00,PSFYY00 => :PSFYY00,PSFGHF0 => :PSFGHF0,PGHFZJE => :PGHFZJE,PGHXJJE => :PGHXJJE,PGHYS00 => :PGHYS00,PGHHBID => :PGHHBID); END;
18      08:43:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
19      08:43:05  SQL Execute: ORACLE - select a.ZDXXID, a.GHID00, a.GHH000,a. ZZDBZ0,a.ICD900, a.ZDMSMC,
       a.JZYS00, a.JZYSXM, a.JZKS00, a.ZDMC00, a.SFYZ00, a.SFXYZD, b.SFCRB0
from   YS_BRZDXX a, XT_ICD900 b 
where  a.ICD900=b.ICD900(+) and a.SFXYZD='1'and a.GHID00=? 


20      08:43:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
21      08:43:05  SQL Execute: ORACLE - select ZDXXID, GHID00, GHH000, ZZDBZ0, ICD900, ZDMSMC,
       JZYS00, JZYSXM, JZKS00, ZDMC00, SFYZ00, SFXYZD 
from   YS_BRZDXX 
where  SFXYZD='0'and GHID00=? 


22      08:43:05  SQL Execute: ORACLE - select count(1) from YS_BRBQB0 where ghid00 in (select ghid00 from sf_brxxb0 b where brid00=601750)  and rownum=1

23      08:43:05  SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1

24      08:43:06  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=1197 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1'

25      08:43:09  SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHH000.nextval from dual where rownum=1

26      08:43:09  SQL Execute: ORACLE - select SQ_SF_BRXXB0_GHID00.nextval from dual where rownum=1

27      08:43:09  SQL Execute: ORACLE - commit

28      08:43:09  SQL Data In: ORACLE - Rows affected = 0
29      08:43:09  SQL Execute: ORACLE - insert into YS_BRBQB0 (ZS0000,GHID00,BRBQID,GHH000,JZYS00,SJYS00,JZRQSJ,CZRQ00,CZSJ00,JZYSXM,FBRQ00)Values('',7894990,SQ_YS_BRBQB0_BRBQID.Nextval,'3324231',1197,0,to_char(sysdate,'yyyymmdd')||substr(to_char(sysdate,'hh24:mi:ss'),1,2)||substr(to_char(sysdate,'hh24:mi:ss'),4,2),to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),'Íõ×Ó½¨','20180704')

30      08:43:09  SQL Data In: ORACLE - Rows affected = 1
31      08:43:09  SQL Execute: ORACLE - commit

32      08:43:09  SQL Data In: ORACLE - Rows affected = 0
33      08:43:11  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=1197 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1'

34      08:43:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
35      08:43:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
36      08:43:11  SQL Execute: ORACLE - select * from vw_ys_hzbr00
where jzks00=? and jzys00=?
and PBLX00='0'
and dlxh00>=0
order by decode(HZZT00,'4',-1,0),YYSJC0,dlxh00

37      08:43:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
38      08:43:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
39      08:43:12  SQL Execute: ORACLE - select total,a.hzlb00,hzlbmc from bm_hzlb00 a,
 (select count(*) total,hzlb00 from VW_YS_HZBR00
  where hzlb00>1 and jzys00=? and jzks00=?
    and PBLX00='0'
  group by hzlb00 ) b 

where  a.hzlb00=b.hzlb00

40      08:43:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
41      08:43:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
42      08:43:12  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3
43      08:43:12  SQL Execute: ORACLE - select * from vw_ys_yzbr00
where jzks00=? and jzys00=?
and PBLX00='0' and HZZT00=?
 order by dlxh00





44      08:43:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 474.000000
45      08:43:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000
46      08:43:12  SQL Execute: ORACLE - select a.YYH000,a.YYJSSJ,a.YYZT00,a.BRXM00,a.BRXB00 from vw_yy_bryyxxcx  a where a.YYRQ00=to_char(sysdate,'YYYYMMDD')
and a.YYKSBH=? and a.YYYSBH=?  and a.YYZT00<>'2' order by a.GHHBID,a.YYH000

47      08:43:16  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=1197 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1'

48      08:43:21  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=1197 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1'

49      08:43:26  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=1197 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1'