1 11:29:31 SQL Prepare: ORACLE - select D.YBMC00,sum(decode(sign(Instrb(','||Trim(D.YBBHSB)||',',',14,')),1,GRZHZF+TCJJZF,GRZHZF+TCJJZF+SBGRZH+SBTCJJ)) JE0000 from zy_jzb000 A,zy_pjsyqk B,bm_brxxb0 C,ic_ybbrlb D where A.pjh000 = B.pjh000 and A.BRID00 = C.BRID00 and C.YBLB00 = D.YBLB00 and C.FBBH00 = D.FBBH00 and D.YBLB00 <> '0' and B.JKDID0 = 68388 group by D.YBMC00 2 11:29:31 SQL Execute: ORACLE - select D.YBMC00,sum(decode(sign(Instrb(','||Trim(D.YBBHSB)||',',',14,')),1,GRZHZF+TCJJZF,GRZHZF+TCJJZF+SBGRZH+SBTCJJ)) JE0000 from zy_jzb000 A,zy_pjsyqk B,bm_brxxb0 C,ic_ybbrlb D where A.pjh000 = B.pjh000 and A.BRID00 = C.BRID00 and C.YBLB00 = D.YBLB00 and C.FBBH00 = D.FBBH00 and D.YBLB00 <> '0' and B.JKDID0 = 68388 group by D.YBMC00 3 11:29:31 SQL Prepare: ORACLE - select ZPKHYH,sum(JFJE00) JFJE00 from zy_brjfb0 where zffs00 = 8 and jkbid0 = 68388 group by ZPKHYH 4 11:29:31 SQL Execute: ORACLE - select ZPKHYH,sum(JFJE00) JFJE00 from zy_brjfb0 where zffs00 = 8 and jkbid0 = 68388 group by ZPKHYH 5 11:29:31 SQL Prepare: ORACLE - select JKRQ00||' '||JKSJ00 JSSJ,czy000,SFY000 from BM_JKB000 where jkdh00 =68388 and mzbz00=1 6 11:29:31 SQL Execute: ORACLE - select JKRQ00||' '||JKSJ00 JSSJ,czy000,SFY000 from BM_JKB000 where jkdh00 =68388 and mzbz00=1 7 11:29:31 SQL Prepare: ORACLE - select max(JKRQ00||' '||JKSJ00) KSSJ from BM_JKB000 where JKDH00<68388 and mzbz00=1 and sfy000=158 8 11:29:31 SQL Execute: ORACLE - select max(JKRQ00||' '||JKSJ00) KSSJ from BM_JKB000 where JKDH00<68388 and mzbz00=1 and sfy000=158 9 11:29:31 SQL Prepare: ORACLE - select max(SFYXM0) SFY from VW_ZY_JKB000 where JKDH00 = '68388' 10 11:29:31 SQL Execute: ORACLE - select max(SFYXM0) SFY from VW_ZY_JKB000 where JKDH00 = '68388' 11 11:29:31 SQL Prepare: ORACLE - select * from BM_JKKJMX where JKDH00 = '68388' and BZ0000 = '1' 12 11:29:31 SQL Execute: ORACLE - select * from BM_JKKJMX where JKDH00 = '68388' and BZ0000 = '1'