1       22:44:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
2       22:44:05  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
3       22:44:05  SQL Execute: ORACLE - select a.* from  VW_PY_BQYZYPTYXX a where  1=1 
 and a.SRRQ00>=?  and a.SRRQ00<=?
 and a.BQBMBH='310' 

4       22:44:14  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
5       22:44:14  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
6       22:44:14  SQL Execute: ORACLE - select '20250821~20250821' "SRRQ00",k."BQBMBH",K."BQBMMC",k."YPNM00",k."YPMC00",
sum(k."YPZSL1") "YPZSL1",sum(k."DKSL00") "DKSL00",sum(k."SFSL00") "SFSL00",
(select nvl(sum(b.CXSL00),0) from YF_BQTYJL b where b.BQBMBH=k.BQBMBH and b.YFBMBH=310 and b.YPNM00=k.YPNM00 and b.ZT0000='0') WDKSL0 from (
select a.* from  VW_PY_BQYZYPTYXX a where  1=1 
 and a.SRRQ00>=?  and a.SRRQ00<=?
 and a.BQBMBH='310' 
 ) k group by k."BQBMBH",K."BQBMMC",k."YPNM00",k."YPMC00" 

7       22:44:15  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
8       22:44:15  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
9       22:44:15  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
10      22:44:15  SQL Execute: ORACLE -  select '20250821~20250821' "SRRQ00",
 a.BQBMBH,(select BMMC00 from BM_BMBM00 where BMBH00=a.BQBMBH and rownum=1) BQBMMC,
a.YPNM00,trim(a.YPMC00)||DECODE((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00),NULL,NULL,'['||trim((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00))||']') YPMC00,
(select nvl(sum(b.YPZSL0),0) from YF_YZYPSQ b where   b.CXBZ00 in ('Z','+') and b.QLZT00 not in ('0','1','3','6') 
 and instr(b.YPMC00,'¡ô')=0 and  b.BQBMBH=a.BQBMBH and b.YFBMBH=a.YFBMBH and b.YPNM00=a.YPNM00 
 and b.FYRQ00>=?) YPZSL1,
(select nvl(sum(b.CXSL00),0) from YF_BQTYJL b where b.BQBMBH=a.BQBMBH and b.YFBMBH=a.YFBMBH and b.YPNM00=a.YPNM00  and TYR000='-9' 
 and b.CZRQ00>=?) DKSL00,
 nvl(sum(a.CXSL00),0) WDKSL0,a.YFBMBH
 from YF_BQTYJL a where a.CZRQ00>=to_char(sysdate-60,'YYYYMMDD') and a.CZRQ00>=? and ZT0000='0' 
 and a.BQBMBH='310' 
group by a.BQBMBH,a.YPNM00,a.YPMC00,a.YFBMBH 

11      22:44:18  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
12      22:44:18  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
13      22:44:18  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
14      22:44:18  SQL Execute: ORACLE -  select '20250821~20250821' "SRRQ00",
 a.BQBMBH,(select BMMC00 from BM_BMBM00 where BMBH00=a.BQBMBH and rownum=1) BQBMMC,
a.YPNM00,trim(a.YPMC00)||DECODE((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00),NULL,NULL,'['||trim((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00))||']') YPMC00,
(select nvl(sum(b.YPZSL0),0) from YF_YZYPSQ b where   b.CXBZ00 in ('Z','+') and b.QLZT00 not in ('0','1','3','6') 
 and instr(b.YPMC00,'¡ô')=0 and  b.BQBMBH=a.BQBMBH and b.YFBMBH=a.YFBMBH and b.YPNM00=a.YPNM00 
 and b.FYRQ00>=?) YPZSL1,
(select nvl(sum(b.CXSL00),0) from YF_BQTYJL b where b.BQBMBH=a.BQBMBH and b.YFBMBH=a.YFBMBH and b.YPNM00=a.YPNM00  and TYR000='-9' 
 and b.CZRQ00>=?) DKSL00,
 nvl(sum(a.CXSL00),0) WDKSL0,a.YFBMBH
 from YF_BQTYJL a where a.CZRQ00>=to_char(sysdate-60,'YYYYMMDD') and a.CZRQ00>=? and ZT0000='0' 
 and a.BQBMBH='310' 
group by a.BQBMBH,a.YPNM00,a.YPMC00,a.YFBMBH 

15      22:44:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
16      22:44:19  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
17      22:44:19  SQL Execute: ORACLE -  select '20250821~20250821' "SRRQ00",
 a.BQBMBH,(select BMMC00 from BM_BMBM00 where BMBH00=a.BQBMBH and rownum=1) BQBMMC,
a.YPNM00,trim(a.YPMC00)||DECODE((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00),NULL,NULL,'['||trim((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00))||']') YPMC00,
0 YPZSL1,
0 DKSL00,
 nvl(sum(a.CXSL00),0) WDKSL0,a.YFBMBH
 from YF_BQTYJL a where  a.CZRQ00>=? and a.CZRQ00<=? and BZ0000 like '%-1%' 
 and a.BQBMBH='310' 
group by a.BQBMBH,a.YPNM00,a.YPMC00,a.YFBMBH 

18      22:44:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
19      22:44:19  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
20      22:44:19  SQL Execute: ORACLE -  select '20250821~20250821' "SRRQ00",
 a.BQBMBH,(select BMMC00 from BM_BMBM00 where BMBH00=a.BQBMBH and rownum=1) BQBMMC,
a.YPNM00,trim(a.YPMC00)||DECODE((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00),NULL,NULL,'['||trim((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00))||']') YPMC00,
0 YPZSL1,
0 DKSL00,
 nvl(sum(a.CXSL00),0) WDKSL0,a.YFBMBH
 from YF_BQTYJL a where  a.CZRQ00>=? and a.CZRQ00<=? and BZ0000 like '%-1%' 
 and a.BQBMBH='310' 
group by a.BQBMBH,a.YPNM00,a.YPMC00,a.YFBMBH 

21      22:44:22  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
22      22:44:22  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20250821
23      22:44:22  SQL Execute: ORACLE -  select '20250821~20250821' "SRRQ00",
 a.BQBMBH,(select BMMC00 from BM_BMBM00 where BMBH00=a.BQBMBH and rownum=1) BQBMMC,
a.YPNM00,trim(a.YPMC00)||DECODE((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00),NULL,NULL,'['||trim((select YPGG00 from BM_YD0000 where YPNM00=a.YPNM00))||']') YPMC00,
0 YPZSL1,
0 DKSL00,
 nvl(sum(a.CXSL00),0) WDKSL0,a.YFBMBH
 from YF_BQTYJL a where  a.CZRQ00>=? and a.CZRQ00<=? and BZ0000 like '%-1%' 
 and a.BQBMBH='310' 
group by a.BQBMBH,a.YPNM00,a.YPMC00,a.YFBMBH