1 15:29:17 SQL Execute: ORACLE - select SP_YK_YPRKSLBDYCGSL_DGYP(2290,' ') iResult from DUAL 2 15:29:17 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 3 15:29:17 SQL Data In: ORACLE - Param = 2, Name = P_LSH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = YKRKDH 4 15:29:17 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (P_LSH => :P_LSH); END; 5 15:29:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 085755 6 15:29:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 7 15:29:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 369.000000 8 15:29:17 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 337 9 15:29:17 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10279.000000 10 15:29:17 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 11 15:29:17 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 04 12 15:29:17 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 13 15:29:17 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 14 15:29:17 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 15 15:29:17 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 16 15:29:17 SQL Execute: ORACLE - INSERT INTO YK_YPRKD0 (RKDH00,YKBMBH,CZYBH0,CGYBH0,GHDWNM,RKLXBH,FKFSBH,ZKJE00,LBBH00,BZ0000,JHRQ00,JHSJ00,YSRY00 ) VALUES(?,?,?,?,?,?,?,?,?,?, TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS'),?) 17 15:29:17 SQL Data In: ORACLE - Rows affected = 1 18 15:29:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 085755 19 15:29:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 20 15:29:17 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 21 15:29:17 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2290.000000 22 15:29:17 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = èÐë²Ý(Éö²è£© 23 15:29:17 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ÒûƬ 24 15:29:17 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = kg 25 15:29:17 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1000.000000 26 15:29:17 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 27 15:29:17 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 28 15:29:17 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 29 15:29:17 SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 30 15:29:17 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 62.500000 31 15:29:17 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 32 15:29:17 SQL Data In: ORACLE - Param = 15, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 33 15:29:17 SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 34 15:29:17 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 001 35 15:29:17 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20280222 36 15:29:17 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 37 15:29:17 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 38 15:29:17 SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1282 39 15:29:17 SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = ½­Î÷½­ÖÐ 40 15:29:17 SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 41 15:29:17 SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 42 15:29:17 SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 43 15:29:17 SQL Data In: ORACLE - Param = 26, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240223 44 15:29:17 SQL Data In: ORACLE - Param = 27, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 45 15:29:17 SQL Data In: ORACLE - Param = 28, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 46 15:29:17 SQL Data In: ORACLE - Param = 29, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 47 15:29:17 SQL Data In: ORACLE - Param = 30, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 48 15:29:17 SQL Data In: ORACLE - Param = 31, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.250000 49 15:29:17 SQL Data In: ORACLE - Param = 32, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 50 15:29:17 SQL Data In: ORACLE - Param = 33, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 51 15:29:17 SQL Data In: ORACLE - Param = 34, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 52 15:29:17 SQL Data In: ORACLE - Param = 35, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 53 15:29:17 SQL Data In: ORACLE - Param = 36, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 54 15:29:17 SQL Data In: ORACLE - Param = 37, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240223 55 15:29:17 SQL Data In: ORACLE - Param = 38, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 56 15:29:17 SQL Data In: ORACLE - Param = 39, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 57 15:29:17 SQL Data In: ORACLE - Param = 40, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 58 15:29:17 SQL Data In: ORACLE - Param = 41, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 59 15:29:17 SQL Data In: ORACLE - Param = 42, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 60 15:29:17 SQL Execute: ORACLE - insert into YK_YPRKMX (YPRKPC, RKDH00, FPH000, FPFLH0, YPNM00, YPMC00, YPGG00, RKDW00, ZHL000, RKSL00, FPGJDJ, KL0000, GJDJ00, LSDJ00, PFDJ00, GJJE00, PCKCSL, SCPH00, YPSXRQ, YPTHPC, CXRKPC, SCCJBH, SCCJZW, CFWZBH, CFWZMC, BZ0000, JHRQ00,SFYHGZ,WGQK00, SFZBYP, ZBXH00, YPJCL0, ZBQNM0, PZWH00, ZKJE00, FPRQ00,YPZCZ0, SCRQ00,CDID00,CDMC00,FPDM00,FPZLMC, MJPH00 ) values (SQ_YK_YPRKMX_YPRKPC.nextval, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?, ?, ?, ?, ?, ?, ?, ?,?, ?,?,?,?,?,? ) 61 15:29:17 SQL Data In: ORACLE - Rows affected = 1 62 15:29:17 SQL Execute: ORACLE - COMMIT WORK 63 15:29:17 SQL Execute: ORACLE - Commit 64 15:29:17 SQL Data In: ORACLE - Rows affected = 0 65 15:29:18 SQL Execute: ORACLE - SELECT R.YKBMBH,R.RKLXBH,R.GHDWNM,G.GHDWMC,R.CGYBH0,R.JHRQ00,R.FKFSBH,R.ZKJE00,G.SFKLYX,R.BZ0000,R.YSRY00,K.ZWXM00 FROM YK_YPRKD0 R,BM_YPGHDW G,BM_YKRKLX L,BM_YGBM00 K WHERE R.GHDWNM=G.GHDWNM AND R.RKLXBH=L.RKLXBH(+) AND R.YSRY00=K.YGBH00(+) AND R.RKZT00='0' AND R.RKDH00='085755' AND L.RKDLX0='Y' AND R.YKBMBH=14 66 15:29:18 SQL Execute: ORACLE - SELECT X.*,D.LBBH00,D.YPBM00,D.YPMLBZ,D.GJBZBM,d.GJBZMC FROM YK_YPRKMX X,BM_YD0000 D WHERE X.YPNM00=D.YPNM00 AND X.RKDH00='085755' ORDER BY X.YPRKPC 67 15:29:18 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||',', ',14,')> 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 = '14') AND (INSTR (',' || a.jsksbh || ',',',14,') > 0 or a.jsksbh is null) 68 15:29:28 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||',', ',14,')> 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 = '14') AND (INSTR (',' || a.jsksbh || ',',',14,') > 0 or a.jsksbh is null) 69 15:29:48 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||',', ',14,')> 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 = '14') AND (INSTR (',' || a.jsksbh || ',',',14,') > 0 or a.jsksbh is null) 70 15:29:51 SQL Execute: ORACLE - Select FYBZ00 from BM_BMBM00 where BMBH00=14 71 15:29:51 SQL Execute: ORACLE - UPDATE YK_YPRKMX SET XXLSDJ=LSDJ00 WHERE RKDH00 ='085755' 72 15:29:51 SQL Data In: ORACLE - Rows affected = 1 73 15:29:51 SQL Execute: ORACLE - UPDATE YK_YPRKD0 SET RKZT00='3' ,QRRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),QRSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') ,QRRBH0='369' WHERE RKDH00 = '085755' 74 15:29:51 SQL Data In: ORACLE - Rows affected = 1 75 15:29:51 SQL Execute: ORACLE - Commit 76 15:29:51 SQL Data In: ORACLE - Rows affected = 0