1       18:07:15  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',487,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '487')
  AND (INSTR (',' || a.jsksbh || ',',',487,') > 0 or a.jsksbh is null)  

2       18:07:17  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
3       18:07:17  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
4       18:07:17  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
5       18:07:17  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
6       18:07:17  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
7       18:07:17  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
8       18:07:17  SQL Execute: ORACLE - SELECT COUNT(ZYID00) FROM ZY_BRXXB0
       WHERE BRZT00 IN ('20','22','23') AND DQBQ00=?
UNION ALL
SELECT COUNT (DISTINCT ZYID00) FROM BQ_BRLDXX
       WHERE QSZT00='新入' AND BQH000=? AND QSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT (ZYID00) FROM ZY_BRXXB0
       WHERE BRZT00>='3' AND DQBQ00=? and CYDJRQ=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT(ZYID00) FROM ZY_BRXXB0
       WHERE BRZT00='3' AND DQBQ00=? and CYDJRQ=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT (DISTINCT ZYID00) FROM BQ_BRLDXX
       WHERE QSZT00='转入' AND BQH000=? AND QSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')
UNION ALL
SELECT COUNT (DISTINCT ZYID00) FROM BQ_BRLDXX
       WHERE JSZT00='转出' AND BQH000=? AND JSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD')


 

9       18:07:17  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
10      18:07:17  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
11      18:07:17  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 482.000000
12      18:07:17  SQL Execute: ORACLE - SELECT 
C.CH0000,ZYH000,XM0000,XB0000,
(select JBMC00 from XT_ICD900 where ICD900=z.ryzd00)  RYZD00,
ZZYSXM,
(select FBMC00 from BM_BRFBB0 where FBBH00=Z.FBBH00) FBMC00,
(select ZLXMJC from BM_ZLZD00 where ZLXMID=Z.HLJBID) ZLXMJC,
SF_BQ_CSRQTONL(CSRQ00) NL0000,
TO_CHAR(TO_DATE(RYRQ00,'YYYYMMDD'),'YYYY.MM.DD') RYRQ00 ,
KYJE00,ZYE000,
BRZT00,Z.ZYID00,C.CWZT00,Z.BRID00,
decode(HLJBID,null,-1,hljbid-100) hljbid,
(select YBMC00 from IC_YBBRLB where YBLB00=B.YBLB00) YBMC00,
B.YBLB00,
BJJE00,
b.MRN000,B.BRZJBH,B.BRZJLX,B.BRLXXM,B.BRLXDH,B.YBID00,
Z.FBBH00,
(select SFXNH0 from IC_YBBRLB where YBLB00=B.YBLB00)  SFXNH0,
0 as BRFY00,0 as YZBL00,0 as ZFYPBL,round(sysdate-to_date(Z.RYRQ00,'YYYYMMDD')) ZYTS00
FROM ZY_BRXXB0 Z,BM_CWK000 C, VW_BQ_ZYBRJE J,
 BM_BRXXB0 B 
WHERE Z.DQBQ00=? AND C.CWZT00 IN ('1','2') AND C.BQH000=?  AND C.ZYID00 IS NOT NULL
AND C.ZYID00=Z.ZYID00   AND C.ZYID00=J.ZYID00
AND  Z.BRID00=B.BRID00
UNION ALL
SELECT CH0000,'','','','','','',
'','','',0,0,'',0,CWZT00,0,0,'','',0,'','','','','','',0,'',0,0,0,0
FROM BM_CWK000
WHERE BQH000=? AND CWZT00 IN ('0','3')
ORDER BY CH0000





13      18:07:19  SQL Error: ORACLE - ORA-01427: 单行子查询返回多个行

14      18:07:19  SQL Error: ORACLE - Unmapped SQL Error Code: 1427
15      18:07:19  SQL Data In: ORACLE - Rows affected = 0