1       11:20:13  SQL Execute: ORACLE - SELECT D.QRRQ00,D.QRSJ00,D.RKDH00,D.ZKJE00,X.YPSXRQ,
(SELECT L.LBMC00 FROM BM_YPLB00 L WHERE L.LBBH00=D.LBBH00) YPLB00,
X.FPH000,X.YPMC00,X.YPGG00,X.RKDW00,X.RKSL00,X.GJDJ00,nvl(X.YGJDJ0,X.FPGJDJ) FPGJDJ,X.PFDJ00,
X.KL0000,nvl(round(X.YGJDJ0*X.RKSL00,2),X.GJJE00) GJJE00,X.LSDJ00,H.CRBMMC,X.BZ0000,X.SCCJZW,X.SCPH00,
ROUND(X.RKSL00*X.FPGJDJ,2) AS FPGJJE,X.ZKJE00 MXZKJE,
ROUND(X.RKSL00*X.LSDJ00,2) AS LSJE00,ROUND(X.RKSL00*X.PFDJ00,2) AS PFJE00,
ROUND(ROUND(X.RKSL00*X.LSDJ00,2)-nvl(round(X.YGJDJ0*X.RKSL00,2),X.GJJE00),2) AS JXCJ00,G.ZWXM00 CGY000,
(SELECT G1.ZWXM00 FROM BM_YGBM00 G1 WHERE D.QRRBH0=G1.YGBH00) QRR000,
ROUND(ROUND(X.RKSL00*X.PFDJ00,2)-nvl(round(X.YGJDJ0*X.RKSL00,2),X.GJJE00),2) AS CJ0000,
ROUND(X.RKSL00*X.LSDJ00,2)-ROUND(X.RKSL00*X.PFDJ00,2) AS PLCJ00
 FROM YK_YPRKMX X,YK_YPRKD0 D,VW_YK_YPCRKDW H,BM_YGBM00 G
 WHERE X.RKDH00=D.RKDH00 AND D.GHDWNM=H.CRBMNM AND D.CGYBH0=G.YGBH00(+)
   AND X.RKDH00='087444'
 ORDER BY X.YPRKPC

2       11:20:14  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 = '3') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',12,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '12')
  AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)  

3       11:20:14  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

4       11:20:14  SQL Execute: ORACLE - update YK_YPRKD0 set HBDYCS=nvl(HBDYCS,0)+1 where RKDH00 ='087444' 

5       11:20:14  SQL Error: ORACLE - ORA-20006: 该记录已经被确认,不能再修改！*
ORA-06512: 在 "SD_HOSPITAL.TR_YK_YPRKD0_BFUPDDET", line 28
ORA-04088: 触发器 'SD_HOSPITAL.TR_YK_YPRKD0_BFUPDDET' 执行过程中出错

6       11:20:14  SQL Error: ORACLE - Unmapped SQL Error Code: 20006
7       11:20:14  SQL Data In: ORACLE - Rows affected = 0
8       11:27:05  Log started for: Sickberth