1       16:21:41  SQL Execute: ORACLE - select BMBH00 from BM_BMBM00 where BMXZ00 in ('2','3') and FLAG00='1' and YYID00='222285'

2       16:21:41  SQL Execute: ORACLE - select 'N' XZ,a.KCSL00,a.KCSL00+(select round(nvl(sum(SJKCSL), 0)/a.K2J000,3) from YF_YPKCXX where YPNM00 = a.YPNM00) as QYKCSL,a.KCSL00+(select round(nvl(sum(SJKCSL), 0)/a.K2J000,3) from YF_YPKCXX where YPNM00 = a.YPNM00 and YFBMBH<>'0') as QYBFKC,a.* from (select b.*,(select nvl(sum(FCSL00), 0) from VW_YK_YPXHL0 where YPNM00 = b.YPNM00 and YKBMBH=b.YKBMBH and JZRQ00 between '20230501' and '20230531') SYHL00, (select nvl(sum(FCSL00), 0) from VW_YF_YPXHL0 where YPNM00 = b.YPNM00 and YFBMBH in ('28','29','602','641','766','635','636','30','735','967','1141','1159','1137') and JZRQ00 between '20230501' and '20230531') YFSYHL from VW_YK_YPKCXX b where YKBMBH = '27') a where 1=1  and a.KCSL00 < a.KCXX00  and a.CGBZ00 = '0' and a.KCSL00 = 0  order by a.YLBH00,a.YPBM00