1 15:49:13 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 2 15:49:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 3 15:49:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 4 15:49:13 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 5 15:49:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 6 15:49:13 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 7 15:49:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:49:26 8 15:49:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 9 15:49:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 10 15:49:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 11 15:49:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 12 15:49:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 13 15:49:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 14 15:49:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 15 15:49:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 16 15:49:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 17 15:49:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 18 15:49:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 19 15:49:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 20 15:49:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 21 15:49:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 22 15:49:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 23 15:49:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 24 15:49:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 25 15:50:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:50:06 26 15:50:06 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 27 15:50:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 28 15:50:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 29 15:50:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 30 15:50:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 31 15:50:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 32 15:50:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 33 15:50:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 34 15:50:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 35 15:50:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 36 15:50:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 37 15:50:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 38 15:50:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 39 15:50:06 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 40 15:50:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 41 15:50:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 42 15:50:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 43 15:50:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:50:46 44 15:50:46 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 45 15:50:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 46 15:50:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 47 15:50:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 48 15:50:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 49 15:50:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 50 15:50:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 51 15:50:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 52 15:50:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 53 15:50:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 54 15:50:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 55 15:50:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 56 15:50:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 57 15:50:46 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 58 15:51:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 59 15:51:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 60 15:51:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 61 15:51:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:51:26 62 15:51:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 63 15:51:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 64 15:51:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 65 15:51:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 66 15:51:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 67 15:51:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 68 15:51:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 69 15:51:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 70 15:51:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 71 15:51:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 72 15:51:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 73 15:51:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 74 15:51:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 75 15:51:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 76 15:51:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 77 15:51:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 78 15:51:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 79 15:52:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:52:06 80 15:52:06 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 81 15:52:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 82 15:52:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 83 15:52:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 84 15:52:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 85 15:52:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 86 15:52:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 87 15:52:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 88 15:52:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 89 15:52:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 90 15:52:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 91 15:52:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 92 15:52:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 93 15:52:06 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 94 15:52:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 95 15:52:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 96 15:52:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 97 15:52:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:52:46 98 15:52:46 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 99 15:52:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 100 15:52:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 101 15:52:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 102 15:52:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 103 15:52:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 104 15:52:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 105 15:52:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 106 15:52:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 107 15:52:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 108 15:52:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 109 15:52:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 110 15:52:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 111 15:52:46 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 112 15:53:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 113 15:53:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 114 15:53:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 115 15:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:53:26 116 15:53:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 117 15:53:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 118 15:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 119 15:53:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 120 15:53:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 121 15:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 122 15:53:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 123 15:53:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 124 15:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 125 15:53:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 126 15:53:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 127 15:53:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 128 15:53:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 129 15:53:26 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 130 15:53:46 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 131 15:53:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 132 15:53:46 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 133 15:54:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:54:06 134 15:54:06 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 135 15:54:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 136 15:54:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 137 15:54:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 138 15:54:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 139 15:54:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 140 15:54:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 141 15:54:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 142 15:54:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 143 15:54:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 144 15:54:06 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 145 15:54:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 146 15:54:06 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 147 15:54:06 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 148 15:54:22 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 149 15:54:22 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='R' 150 15:54:22 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 151 15:54:22 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 152 15:54:22 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 153 15:54:23 SQL Execute: ORACLE - select nvl(MC0000,'0') MC0000 from BM_TYZD00 where ZDMC00='事前审方-事前审方系统' and BZ0000='是否启用审方系统' 154 15:54:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 155 15:54:23 SQL Execute: ORACLE - select b.zwxm00,c.* from (select rownum RN, A.* from VW_BM_CKBM00 A where BMBH00 = ? and FLAG00 = '2' )c ,BM_YGBM00 b where c.fyr000 = b.ygbh00(+) 156 15:54:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 157 15:54:23 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 158 15:54:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 159 15:54:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 160 15:54:23 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 9 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 161 15:54:23 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 162 15:54:23 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 163 15:54:23 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 164 15:54:23 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 165 15:54:23 SQL Execute: ORACLE - select rownum RN, A.* from (select * from VW_PY_KDKS00 where 1=1 ) A 166 15:54:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2590 167 15:54:23 SQL Execute: ORACLE - select * from VW_PY_ZKFYCK where BMBH00 = ? 168 15:54:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2590 169 15:54:23 SQL Execute: ORACLE - select * from VW_PY_FYCK00 A where not exists (select 1 from YF_ZKFYCK where BMBH00 = ? and FYCKBH = A.CKBH00) 170 15:54:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 171 15:54:23 SQL Execute: ORACLE - select * from VW_PY_BMCKRY where BMBH00 = ? and CZBZ00='1' order by ryzt00 desc,PYCKBH,XKH000 172 15:54:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 173 15:54:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 174 15:54:23 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 9 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 175 15:54:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 176 15:54:23 SQL Execute: ORACLE - select b.zwxm00, c.* from (select rownum RN, A.* from VW_BM_CKBM00 A where BMBH00 = ? and FLAG00 = '3' )c ,BM_YGBM00 b where c.fyr000 = b.ygbh00(+) 177 15:54:23 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1057,'管理员','192.168.11.1','00-50-56-C0-00-01','R','ACT_PY_CKRYWH','18216953') 178 15:54:23 SQL Data In: ORACLE - Rows affected = 1 179 15:54:23 SQL Execute: ORACLE - Commit 180 15:54:23 SQL Data In: ORACLE - Rows affected = 0 181 15:54:26 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 182 15:54:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 183 15:54:26 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 184 15:54:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 185 15:54:33 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 where CKBH00 = ? and JQMC00='CXH-PC' 186 15:54:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 187 15:54:41 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 188 15:54:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 189 15:54:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 190 15:54:41 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10026 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 191 15:54:41 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 192 15:54:41 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 193 15:54:41 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 194 15:54:41 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 195 15:57:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 196 15:57:26 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 197 15:57:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 198 15:57:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 199 15:57:26 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 9 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 200 15:57:26 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 201 15:57:26 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 202 15:57:26 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 203 15:57:26 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 204 15:57:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 205 15:57:26 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 206 15:57:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 207 15:57:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 208 15:57:26 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 209 15:57:26 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 210 15:57:26 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 211 15:57:26 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 212 15:57:26 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 213 15:57:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 214 15:57:26 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 215 15:57:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 216 15:57:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 217 15:57:26 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 32 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 218 15:57:26 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 219 15:57:26 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 220 15:57:26 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 221 15:57:26 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 222 15:57:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10024 223 15:57:26 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 224 15:57:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10024 225 15:57:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10024 226 15:57:26 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10024 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 227 15:57:27 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 228 15:57:27 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 229 15:57:27 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 230 15:57:27 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 231 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 232 15:57:27 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 233 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 234 15:57:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 235 15:57:27 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10026 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 236 15:57:27 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 237 15:57:27 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 238 15:57:27 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 239 15:57:27 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 240 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 241 15:57:27 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 242 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 243 15:57:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 244 15:57:27 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10026 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 245 15:57:27 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 246 15:57:27 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 247 15:57:27 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 248 15:57:27 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 249 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10026.000000 250 15:57:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 251 15:57:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2272.000000 252 15:57:27 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 中药配药16 253 15:57:27 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 254 15:57:27 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 255 15:57:27 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 256 15:57:27 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 257 15:57:27 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 258 15:57:27 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 259 15:57:27 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2,4,5,6 260 15:57:27 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 261 15:57:27 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 262 15:57:27 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 263 15:57:27 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 264 15:57:27 SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2881.000000 265 15:57:27 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 266 15:57:27 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 267 15:57:27 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 268 15:57:27 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10026.000000 269 15:57:27 SQL Execute: ORACLE - update BM_CKBM00 set CKBH00 = ?, JQBH00 = ?, BMBH00 = ?, CKMC00 = ?, MRXSP0 = ?, DQXSP0 = ?, FLAG00 = ?, ZT0000 = ?, BZ0000 = ?, CFDGS0 = ?, YPDLBH = ?, CKLXID = ?, DLQSH0 = ?, JHCKBH = ?, CKXXDZ = ?, CJR000 = ?, ZKCKBZ = nvl(?,'0'), JQMC00 = ?, FYR000 = ? where CKBH00 = ? 270 15:57:27 SQL Data In: ORACLE - Rows affected = 1 271 15:57:27 SQL Execute: ORACLE - commit 272 15:57:27 SQL Data In: ORACLE - Rows affected = 0 273 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 274 15:57:27 SQL Execute: ORACLE - select b.zwxm00,c.* from (select rownum RN, A.* from VW_BM_CKBM00 A where BMBH00 = ? and FLAG00 = '2' )c ,BM_YGBM00 b where c.fyr000 = b.ygbh00(+) 275 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 276 15:57:27 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 277 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 278 15:57:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 279 15:57:27 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 9 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 280 15:57:27 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 281 15:57:27 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 282 15:57:27 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 283 15:57:27 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 284 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 285 15:57:27 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 286 15:57:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 287 15:57:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 288 15:57:27 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10026 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 289 15:57:27 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 290 15:57:27 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 291 15:57:27 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 292 15:57:27 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 293 15:57:40 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 294 15:57:40 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='R' 295 15:57:40 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 296 15:57:40 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 297 15:57:40 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 298 15:58:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 299 15:58:17 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 300 15:58:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 301 15:58:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 302 15:58:17 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 9 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 303 15:58:17 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 304 15:58:17 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 305 15:58:17 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 306 15:58:17 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 307 15:58:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 308 15:58:17 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 309 15:58:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 310 15:58:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 311 15:58:17 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 312 15:58:18 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 313 15:58:18 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 314 15:58:18 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 315 15:58:18 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 316 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 317 15:58:18 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 318 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 319 15:58:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 32 320 15:58:18 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 32 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 321 15:58:18 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 322 15:58:18 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 323 15:58:18 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 324 15:58:18 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 325 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10024 326 15:58:18 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 327 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10024 328 15:58:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10024 329 15:58:18 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10024 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 330 15:58:18 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 331 15:58:18 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 332 15:58:18 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 333 15:58:18 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 334 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 335 15:58:18 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 336 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 337 15:58:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 338 15:58:18 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10026 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 339 15:58:18 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 340 15:58:18 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 341 15:58:18 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 342 15:58:18 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 343 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 344 15:58:18 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 345 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 346 15:58:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 347 15:58:18 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10026 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 348 15:58:18 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 349 15:58:18 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 350 15:58:18 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 351 15:58:18 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 352 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10026.000000 353 15:58:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 354 15:58:18 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2272.000000 355 15:58:18 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 中药配药16 356 15:58:18 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 357 15:58:18 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 358 15:58:18 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 359 15:58:18 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 360 15:58:18 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 361 15:58:18 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 362 15:58:18 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2,4,5,6 363 15:58:18 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 364 15:58:18 SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 365 15:58:18 SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 366 15:58:18 SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 367 15:58:18 SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2881.000000 368 15:58:18 SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 369 15:58:18 SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 370 15:58:18 SQL Data In: ORACLE - Param = 19, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 371 15:58:18 SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10026.000000 372 15:58:18 SQL Execute: ORACLE - update BM_CKBM00 set CKBH00 = ?, JQBH00 = ?, BMBH00 = ?, CKMC00 = ?, MRXSP0 = ?, DQXSP0 = ?, FLAG00 = ?, ZT0000 = ?, BZ0000 = ?, CFDGS0 = ?, YPDLBH = ?, CKLXID = ?, DLQSH0 = ?, JHCKBH = ?, CKXXDZ = ?, CJR000 = ?, ZKCKBZ = nvl(?,'0'), JQMC00 = ?, FYR000 = ? where CKBH00 = ? 373 15:58:18 SQL Data In: ORACLE - Rows affected = 1 374 15:58:18 SQL Execute: ORACLE - commit 375 15:58:18 SQL Data In: ORACLE - Rows affected = 0 376 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 377 15:58:18 SQL Execute: ORACLE - select b.zwxm00,c.* from (select rownum RN, A.* from VW_BM_CKBM00 A where BMBH00 = ? and FLAG00 = '2' )c ,BM_YGBM00 b where c.fyr000 = b.ygbh00(+) 378 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 379 15:58:18 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 380 15:58:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 381 15:58:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 382 15:58:18 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 9 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 383 15:58:18 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 384 15:58:18 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 385 15:58:18 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 386 15:58:18 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 387 15:58:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 388 15:58:19 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 389 15:58:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 390 15:58:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 391 15:58:19 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10026 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 392 15:58:19 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 393 15:58:19 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 394 15:58:19 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 395 15:58:19 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 396 15:58:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 397 15:58:22 SQL Execute: ORACLE - select b.zwxm00,c.* from (select rownum RN, A.* from VW_BM_CKBM00 A where BMBH00 = ? and FLAG00 = '2' )c ,BM_YGBM00 b where c.fyr000 = b.ygbh00(+) 398 15:58:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 399 15:58:22 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 400 15:58:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 401 15:58:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 402 15:58:23 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 9 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 403 15:58:23 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 404 15:58:23 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 405 15:58:23 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 406 15:58:23 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 407 15:58:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2272 408 15:58:24 SQL Execute: ORACLE - select b.zwxm00,c.* from (select rownum RN, A.* from VW_BM_CKBM00 A where BMBH00 = ? and FLAG00 = '2' )c ,BM_YGBM00 b where c.fyr000 = b.ygbh00(+) 409 15:58:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 410 15:58:24 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 411 15:58:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 412 15:58:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 413 15:58:25 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 9 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 414 15:58:25 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 415 15:58:25 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 416 15:58:25 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 417 15:58:25 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 418 15:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 419 15:58:35 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 420 15:58:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 421 15:58:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 422 15:58:35 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 423 15:58:35 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 424 15:58:35 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 425 15:58:35 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 426 15:58:35 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 427 15:58:46 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 428 15:58:46 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='R' 429 15:58:46 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 430 15:58:46 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 431 15:58:46 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 432 15:58:46 SQL Execute: ORACLE - select CKMC00,CKBH00 from VW_PY_PYCK00 where 1=1 and BMBH00 = 2272 order by CKMC00 433 15:58:46 SQL Execute: ORACLE - select CKMC00,CKBH00 from VW_PY_FYCK00 where 1=1 and CKBH00 in (select DCKBH0 from BM_CKDY00 where SCKBH0 = 10026) order by CKMC00 434 15:58:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 435 15:58:46 SQL Execute: ORACLE - select ZTMC00 from VW_BM_CKBM00 where CKBH00 = ? 436 15:58:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 437 15:58:46 SQL Execute: ORACLE - select ZTMC00 from VW_BM_CKBM00 where CKBH00 = ? 438 15:58:49 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1057,'管理员','192.168.11.1','00-50-56-C0-00-01','R','ACT_PY_CKSZ00','18216953') 439 15:58:49 SQL Data In: ORACLE - Rows affected = 1 440 15:58:49 SQL Execute: ORACLE - Commit 441 15:58:49 SQL Data In: ORACLE - Rows affected = 0 442 15:58:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 443 15:58:51 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 444 15:58:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 445 15:58:51 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 446 15:58:51 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10026 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 447 15:58:51 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 448 15:58:51 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 449 15:58:51 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 450 15:58:51 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 451 15:58:58 SQL Execute: ORACLE - delete from BM_CKDY00 where SCKBH0 = 10026 and DCKBH0 = 33 452 15:58:58 SQL Data In: ORACLE - Rows affected = 1 453 15:58:58 SQL Execute: ORACLE - commit 454 15:58:58 SQL Data In: ORACLE - Rows affected = 0 455 15:59:00 SQL Execute: ORACLE - delete from BM_CKDY00 where SCKBH0 = 10026 and DCKBH0 = 608 456 15:59:00 SQL Data In: ORACLE - Rows affected = 1 457 15:59:00 SQL Execute: ORACLE - commit 458 15:59:00 SQL Data In: ORACLE - Rows affected = 0 459 15:59:01 SQL Execute: ORACLE - insert into BM_CKDY00 (SCKBH0, DCKBH0, CJR000) select 10026, 33, 1057 from dual where not exists (select 1 from BM_CKDY00 where SCKBH0 = 10026 and DCKBH0 = 33) 460 15:59:01 SQL Data In: ORACLE - Rows affected = 1 461 15:59:01 SQL Execute: ORACLE - commit 462 15:59:01 SQL Data In: ORACLE - Rows affected = 0 463 15:59:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 464 15:59:07 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 465 15:59:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 466 15:59:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 467 15:59:07 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 468 15:59:07 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 469 15:59:07 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 470 15:59:07 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 471 15:59:07 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 472 15:59:09 SQL Execute: ORACLE - delete from BM_CKDY00 where SCKBH0 = 10 and DCKBH0 = 33 473 15:59:09 SQL Data In: ORACLE - Rows affected = 1 474 15:59:09 SQL Execute: ORACLE - commit 475 15:59:09 SQL Data In: ORACLE - Rows affected = 0 476 15:59:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 477 15:59:12 SQL Execute: ORACLE - select rownum RN,A.* from (select b.*,c.ckbh00 from VW_PY_KDKS00 b,VW_PY_ZKFYCK c where c.bmbh00=b.bmbh00)A where ckbh00=? 478 15:59:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 479 15:59:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 480 15:59:12 SQL Execute: ORACLE - select * from (select 'Y' NX, SCKBH0, CKMC00, DCKBH0, FLAGMC, ZTMC00, SFYX00 from VW_BM_CKDY00 where SCKBH0 = ? union select 'N' NX, 10026 SCKBH0, CKMC00, CKBH00 DCKBH0, FLAGMC, ZTMC00, '0' SFYX00 from VW_BM_CKBM00 A where BMBH00 = 2272 and FLAG00 in ('1', '2','3') and FLAG00 = '3' and not exists (select 1 from BM_CKDY00 where SCKBH0 = ? and DCKBH0 = A.CKBH00) ) order by NX desc 481 15:59:12 SQL Execute: ORACLE - select * from VW_BM_YPDLBH where 1=1 482 15:59:12 SQL Execute: ORACLE - select * from VW_BM_CFDGS0 where 1=1 483 15:59:12 SQL Execute: ORACLE - select * from VW_BM_PYCKLX where 1=1 484 15:59:12 SQL Execute: ORACLE - select * from BM_YGBM00 where 1=1 and BMBH00=2272 485 15:59:22 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 486 15:59:22 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='R' 487 15:59:22 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 488 15:59:22 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 489 15:59:22 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 490 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 491 15:59:23 SQL Execute: ORACLE - select JZCKBZ from BM_CKBM00 where CKBH00 = ? 492 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 493 15:59:23 SQL Execute: ORACLE - select BMBH00 from BM_CKBM00 where CKBH00 = ? 494 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 495 15:59:23 SQL Execute: ORACLE - select BMBH00 from BM_CKBM00 where CKBH00 = ? 496 15:59:23 SQL Execute: ORACLE - select ZWXM00||'|'||XKH000 from VW_PY_PYXTRY A 497 15:59:23 SQL Execute: ORACLE - select SF_PY_GetYFLB(2272) from dual 498 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 499 15:59:23 SQL Execute: ORACLE - select CKMC00 from VW_BM_CKBM00 where CKBH00 = ? 500 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 10026 501 15:59:23 SQL Execute: ORACLE - select CKMC00 from VW_BM_CKBM00 where CKBH00 = ? 502 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 503 15:59:23 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 where CKBH00 = ? 504 15:59:23 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='退回原因' order by xsxh00 505 15:59:23 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_MZ' 506 15:59:23 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '排队叫号通用接口参数配置' and BH0000 = 'PDJHJK_SFQY' 507 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:59:23 508 15:59:23 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 509 15:59:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 510 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 511 15:59:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 512 15:59:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 513 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 514 15:59:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 515 15:59:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 516 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 517 15:59:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 518 15:59:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 519 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 520 15:59:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 521 15:59:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 522 15:59:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 523 15:59:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 524 15:59:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 525 15:59:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 526 15:59:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 527 15:59:24 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 528 15:59:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 529 15:59:24 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 530 15:59:24 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 531 15:59:24 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '3' order by FYDLXH desc ) A 532 15:59:24 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1057,'管理员','192.168.11.1','00-50-56-C0-00-01','R','ACT_PY_MZPYXT','18216953') 533 15:59:24 SQL Data In: ORACLE - Rows affected = 1 534 15:59:24 SQL Execute: ORACLE - Commit 535 15:59:24 SQL Data In: ORACLE - Rows affected = 0 536 15:59:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 537 15:59:27 SQL Execute: ORACLE - update BM_CKBM00 set ZT0000 = '0',JQMC00=nvl(JQMC00,'CXH-PC'),BZ0000=nvl(BZ0000,to_char(sysdate,'yyyymmddhh24:mi:ss')) where CKBH00 = ? 538 15:59:27 SQL Data In: ORACLE - Rows affected = 1 539 15:59:27 SQL Execute: ORACLE - commit 540 15:59:27 SQL Data In: ORACLE - Rows affected = 0 541 15:59:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 33 542 15:59:27 SQL Execute: ORACLE - select ZT0000 from BM_CKBM00 where CKBH00 = ? 543 15:59:29 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 544 15:59:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 545 15:59:29 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 546 15:59:29 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 547 15:59:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 548 15:59:29 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 549 15:59:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 15:59:32 550 15:59:32 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 551 15:59:32 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 552 15:59:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 553 15:59:32 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 554 15:59:32 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 555 15:59:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 556 15:59:32 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 557 15:59:32 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 558 15:59:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 559 15:59:32 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 560 15:59:32 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 561 15:59:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 562 15:59:32 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 563 15:59:32 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 564 15:59:32 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '3' order by FYDLXH desc ) A 565 15:59:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 566 15:59:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 567 15:59:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 568 16:00:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:00:02 569 16:00:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 570 16:00:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 571 16:00:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 572 16:00:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 573 16:00:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 574 16:00:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 575 16:00:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 576 16:00:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 577 16:00:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 578 16:00:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 579 16:00:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 580 16:00:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 581 16:00:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 582 16:00:03 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 583 16:00:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 584 16:00:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 585 16:00:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 586 16:00:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:00:42 587 16:00:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 588 16:00:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 589 16:00:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 590 16:00:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 591 16:00:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 592 16:00:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 593 16:00:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 594 16:00:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 595 16:00:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 596 16:00:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 597 16:00:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 598 16:00:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 599 16:00:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 600 16:00:43 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 601 16:01:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 602 16:01:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 603 16:01:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 604 16:01:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:01:22 605 16:01:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 606 16:01:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 607 16:01:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 608 16:01:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 609 16:01:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 610 16:01:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 611 16:01:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 612 16:01:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 613 16:01:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 614 16:01:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 615 16:01:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 616 16:01:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 617 16:01:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 618 16:01:23 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 619 16:01:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 620 16:01:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 621 16:01:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 622 16:02:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:02:02 623 16:02:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 624 16:02:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 625 16:02:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 626 16:02:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 627 16:02:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 628 16:02:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 629 16:02:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 630 16:02:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 631 16:02:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 632 16:02:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 633 16:02:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 634 16:02:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 635 16:02:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 636 16:02:03 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 637 16:02:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 638 16:02:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 639 16:02:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 640 16:02:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:02:42 641 16:02:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 642 16:02:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 643 16:02:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 644 16:02:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 645 16:02:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 646 16:02:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 647 16:02:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 648 16:02:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 649 16:02:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 650 16:02:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 651 16:02:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 652 16:02:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 653 16:02:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 654 16:02:43 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 655 16:03:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 656 16:03:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 657 16:03:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 658 16:03:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:03:22 659 16:03:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 660 16:03:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 661 16:03:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 662 16:03:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 663 16:03:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 664 16:03:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 665 16:03:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 666 16:03:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 667 16:03:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 668 16:03:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 669 16:03:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 670 16:03:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 671 16:03:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 672 16:03:23 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 673 16:03:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 674 16:03:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 675 16:03:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 676 16:04:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:04:02 677 16:04:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 678 16:04:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 679 16:04:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 680 16:04:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 681 16:04:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 682 16:04:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 683 16:04:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 684 16:04:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 685 16:04:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 686 16:04:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 687 16:04:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 688 16:04:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 689 16:04:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 690 16:04:03 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 691 16:04:11 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 692 16:04:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 693 16:04:11 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 694 16:04:11 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 695 16:04:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 696 16:04:11 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 697 16:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:04:15 698 16:04:15 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 699 16:04:15 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 700 16:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 701 16:04:15 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 702 16:04:15 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 703 16:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 704 16:04:15 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 705 16:04:15 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 706 16:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 707 16:04:15 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 708 16:04:15 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 709 16:04:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 710 16:04:15 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 711 16:04:15 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 712 16:04:15 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '3' order by FYDLXH desc ) A 713 16:04:17 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 714 16:04:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 715 16:04:17 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 716 16:04:17 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 717 16:04:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 718 16:04:17 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 719 16:04:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:04:22 720 16:04:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 721 16:04:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 722 16:04:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 723 16:04:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 724 16:04:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 725 16:04:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 726 16:04:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 727 16:04:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 728 16:04:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 729 16:04:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 730 16:04:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 731 16:04:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 732 16:04:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 733 16:04:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 734 16:04:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '3' order by FYDLXH desc ) A 735 16:04:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 736 16:04:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 737 16:04:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 738 16:04:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:04:42 739 16:04:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 740 16:04:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 741 16:04:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 742 16:04:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 743 16:04:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 744 16:04:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 745 16:04:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 746 16:04:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 747 16:04:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 748 16:04:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 749 16:04:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 750 16:04:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 751 16:04:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 752 16:04:43 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 753 16:05:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 754 16:05:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 755 16:05:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 756 16:05:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:05:22 757 16:05:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 758 16:05:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 759 16:05:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 760 16:05:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 761 16:05:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 762 16:05:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 763 16:05:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 764 16:05:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 765 16:05:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 766 16:05:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 767 16:05:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 768 16:05:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 769 16:05:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 770 16:05:23 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 771 16:05:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 772 16:05:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 773 16:05:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 774 16:06:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:06:02 775 16:06:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 776 16:06:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 777 16:06:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 778 16:06:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 779 16:06:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 780 16:06:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 781 16:06:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 782 16:06:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 783 16:06:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 784 16:06:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 785 16:06:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 786 16:06:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 787 16:06:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 788 16:06:03 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 789 16:06:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 790 16:06:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 791 16:06:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 792 16:06:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:06:42 793 16:06:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 794 16:06:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 795 16:06:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 796 16:06:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 797 16:06:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 798 16:06:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 799 16:06:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 800 16:06:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 801 16:06:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 802 16:06:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 803 16:06:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 804 16:06:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 805 16:06:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 806 16:06:43 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 807 16:07:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 808 16:07:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 809 16:07:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 810 16:07:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:07:22 811 16:07:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 812 16:07:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 813 16:07:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 814 16:07:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 815 16:07:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 816 16:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 817 16:07:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 818 16:07:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 819 16:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 820 16:07:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 821 16:07:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 822 16:07:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 823 16:07:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 824 16:07:23 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 825 16:07:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 826 16:07:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 827 16:07:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 828 16:08:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:08:02 829 16:08:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 830 16:08:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 831 16:08:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 832 16:08:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 833 16:08:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 834 16:08:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 835 16:08:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 836 16:08:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 837 16:08:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 838 16:08:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 839 16:08:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 840 16:08:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 841 16:08:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 842 16:08:03 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 843 16:08:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 844 16:08:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 845 16:08:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 846 16:08:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:08:42 847 16:08:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 848 16:08:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 849 16:08:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 850 16:08:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 851 16:08:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 852 16:08:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 853 16:08:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 854 16:08:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 855 16:08:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 856 16:08:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 857 16:08:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 858 16:08:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 859 16:08:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 860 16:08:43 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 861 16:09:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 862 16:09:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 863 16:09:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 864 16:09:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:09:22 865 16:09:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 866 16:09:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 867 16:09:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 868 16:09:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 869 16:09:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 870 16:09:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 871 16:09:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 872 16:09:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 873 16:09:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 874 16:09:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 875 16:09:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 876 16:09:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 877 16:09:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 878 16:09:23 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 879 16:09:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 880 16:09:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 881 16:09:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 882 16:10:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:10:02 883 16:10:02 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 884 16:10:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 885 16:10:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 886 16:10:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 887 16:10:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 888 16:10:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 889 16:10:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 890 16:10:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 891 16:10:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 892 16:10:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 893 16:10:03 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 894 16:10:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 895 16:10:03 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 896 16:10:03 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 897 16:10:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 898 16:10:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 899 16:10:22 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 900 16:10:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:10:42 901 16:10:42 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 902 16:10:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 903 16:10:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 904 16:10:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 905 16:10:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 906 16:10:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 907 16:10:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 908 16:10:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 909 16:10:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 910 16:10:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 911 16:10:43 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 912 16:10:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 913 16:10:43 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 914 16:10:43 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 915 16:11:02 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 916 16:11:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 917 16:11:02 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 918 16:11:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:11:22 919 16:11:22 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where YPJE00 >= 0 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ((ZT0000 = '4' and DYSJ00 > ?) or (ZT0000 = '1')) order by FYDLXH) A 920 16:11:22 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 921 16:11:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 922 16:11:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 923 16:11:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 924 16:11:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 925 16:11:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 926 16:11:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 927 16:11:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 928 16:11:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 929 16:11:23 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 930 16:11:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 931 16:11:23 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00 932 16:11:23 SQL Execute: ORACLE - select 'N' NX, A.* from (select * from VW_PY_FYCFDL A where 1=1 and PHRQ00 between '20220228' and '20220228' and FYCKBH = 33 and ZT0000 = '2' and THBZ00<>'1' order by JHXH00 desc ) A 933 16:11:42 SQL Execute: ORACLE - select GMS000 from ys_mzblws where BRID00 = 660736 and rownum = 1 order by GHID00 desc 934 16:11:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1790170 935 16:11:42 SQL Execute: ORACLE - select * from VW_PY_BRCFMX_DSQL where CFLSH0 = ? order by CFID00