1       15:57:01  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20231225
2       15:57:01  SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20231226
3       15:57:01  SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:00:01
4       15:57:01  SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:00:00
5       15:57:01  SQL Data In: ORACLE - Param = 5, Name = AS_SFY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
6       15:57:01  SQL Data In: ORACLE - Param = 6, Name = AS_KSSJSJ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
7       15:57:01  SQL Data In: ORACLE - Param = 7, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
8       15:57:01  SQL Data In: ORACLE - Param = 8, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
9       15:57:01  SQL Data In: ORACLE - Param = 9, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
10      15:57:01  SQL Data In: ORACLE - Param = 10, Name = AS_TJFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
11      15:57:01  SQL Data In: ORACLE - Param = 11, Name = as_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
12      15:57:01  SQL Execute: ORACLE - BEGIN "SP_SF_SFJKQR_TJ0000" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_SFY000 => :AS_SFY000,AS_KSSJSJ => :AS_KSSJSJ,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_TJFS00 => :AS_TJFS00,as_YYID00 => :as_YYID00); END;
13      15:57:01  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50076931.000000
14      15:57:01  SQL Execute: ORACLE -  select  ID0000,XMHJ00,GHRQ00,GHKS01,GHKS02,GHKS03,GHKS04,GHKS05,GHKS06,GHKS07,GHKS08,GHKS09,GHKS10,GHKS12,GHKS24,GHKS25,BEIZHU,BEIZH1 from  BM_GHKSTJ where  ID0000 =?  
 order by XMHJ00 

15      15:57:13  SQL Execute: ORACLE - select a.sfy000,a.zwxm00,a.xmje00,a.xmje01,
( 
select trim(min(aa.PJQSH0))||'-'||trim(max(aa.PJZZH0))
from bm_jkb000 aa 
where aa.sfy000=a.sfy000
and aa.JKRQ00>='20231226'
and aa.JKRQ00<='20231226'
and aa.JKRQ00||aa.JKSJ00>='20231226'||'00:00:00' 
and aa.JKRQ00||aa.JKSJ00<='20231226'||'23:59:59' 
and aa.mzbz00='0' and aa.PJBH00=1
) fpxh00, 
(  
select trim(min(aa.PJQSH0))||'-'||trim(max(aa.PJZZH0))
from bm_jkb000 aa 
where aa.sfy000=a.sfy000
and aa.JKRQ00>='20231226'
and aa.JKRQ00<='20231226'
and aa.JKRQ00||aa.JKSJ00>='20231226'||'00:00:00' 
and aa.JKRQ00||aa.JKSJ00<='20231226'||'23:59:59' 
and aa.mzbz00='0' and aa.PJBH00=7
) yjjxh0,
 a.qm0000 FROM (
select sfy000,zwxm00,sum(xmje00) xmje00,substr(SP_BM_RMB000(sum(xmje00)),1,20) xmje01,'         ' qm0000 from
(select distinct(a.jkdh00) jkdh00,b.xmje00 xmje00,a.sfy000 sfy000,c.zwxm00 zwxm00 
 from bm_jkb000 a,bm_jkkjmx b,bm_ygbm00 c,BM_BMBM00 D where a.jkdh00 =b.jkdh00 and b.xmbh00='07'
 and a.sfy000=c.ygbh00
and a.JKRQ00>='20231226'
and a.JKRQ00<='20231226'
 and C.BMBH00=D.BMBH00 and ('0' ='0' or D.YYID00=rpad('0',6,' '))
and a.JKRQ00||a.JKSJ00>='20231226'||'00:00:00' 
and a.JKRQ00||a.JKSJ00<='20231226'||'23:59:59' 
and a.mzbz00='0' )
group by sfy000,zwxm00
)A
union all
select -1,'ºÏ¼Æ',sum(xmje00) xmje00,substr(SP_BM_RMB000(sum(xmje00)),1,20) xmje01,'         ' fpxh00,'         ' yjjxh0,'         ' qm0000 from (
select sfy000,zwxm00,sum(xmje00) xmje00,substr(SP_BM_RMB000(sum(xmje00)),1,20) xmje01,'         ' qm0000 from
(select distinct(a.jkdh00) jkdh00,b.xmje00 xmje00,a.sfy000 sfy000,c.zwxm00 zwxm00 
 from bm_jkb000 a,bm_jkkjmx b,bm_ygbm00 c,BM_BMBM00 D where a.jkdh00 =b.jkdh00 and b.xmbh00='07'
and a.sfy000=c.ygbh00
and a.JKRQ00>='20231226'
and a.JKRQ00<='20231226'
 and C.BMBH00=D.BMBH00 and ('0' ='0' or D.YYID00=rpad('0',6,' '))
and a.JKRQ00||a.JKSJ00>='20231226'||'00:00:00' 
and a.JKRQ00||a.JKSJ00<='20231226'||'23:59:59' 
and a.mzbz00='0' )
group by sfy000,zwxm00)