1       19:08:35  SQL Execute: ORACLE - SELECT Q.YPQLDH,Q.CKLXBH,Q.QLRQ00,Q.QLSJ00,Q.QRRQ00,Q.QRSJ00,
 (SELECT V.BMMC00 FROM VW_YK_YPCKFX V WHERE Q.CKQXBH=V.BMBH00) BMMC00,
 Y1.ZWXM00 AS LYRXM0,Y2.ZWXM00 AS QRRXM0
 FROM YK_YPQLD0 Q,BM_YGBM00 Y1,BM_YGBM00 Y2
 WHERE YKBMBH=12
 AND Q.CKQXBH in (select BMBH00 from VW_YK_YPCKFX)
 AND Q.LYRBH0=Y1.YGBH00(+) AND Q.QRRBH0=Y2.YGBH00
 AND Q.QRRQ00>='20230201' AND Q.QRRQ00<='20230228'
 AND Q.QLZT00<>'0'
 ORDER BY Q.CKQXBH,Q.YPQLDH

2       19:08:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 159951
3       19:08:36  SQL Execute: ORACLE - select * from YK_YPQLMX where YPQLDH=?

4       19:08:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 159951
5       19:08:36  SQL Execute: ORACLE - select * from YK_YPQLMX where YPQLDH=?

6       19:08:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 159951
7       19:08:36  SQL Execute: ORACLE - select * from YK_YPQLMX where YPQLDH=?

8       19:08:36  SQL Execute: ORACLE - SELECT R.RKDH00,R.JHRQ00,
 (SELECT V.BMMC00 FROM VW_YK_YPCKFX V WHERE R.GHDWNM=V.BMBH00) BMMC00
 FROM YK_YPRKD0 R
 WHERE R.RKZT00<>'0' AND R.YKBMBH=12
 AND R.GHDWNM in (select BMBH00 from VW_YK_YPCKFX)
 AND R.QRRQ00>='20230201' AND R.QRRQ00<='20230228'
 AND R.RKLXBH='06'
 ORDER BY R.GHDWNM,R.RKDH00

9       19:08:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 082936
10      19:08:36  SQL Execute: ORACLE - SELECT "YPRKPC", "RKDH00", "FPH000", "FPFLH0", "YPNM00", "YPMC00", "YPGG00", "RKDW00", "ZHL000", "RKSL00", "FPGJDJ", "KL0000", "GJDJ00", "LSDJ00", "PFDJ00", "GJJE00", "PCKCSL", "SCPH00", "YPSXRQ", "YPTHPC", "CXBZ00", "CXRKPC", "SFXYTJ", "SCCJBH", "SCCJZW", "CFWZBH", "CFWZMC", "BZ0000", "JHRQ00", "SFZBYP", "XXLSDJ", "ZBXH00", "YPJCL0", "ZBQNM0", "PZWH00", "ZKJE00", "FPRQ00", "YPZCZ0", "SCRQ00", "BHID00", "BH0000", "CDID00", "CDMC00", "SFYHGZ", "WGQK00", "YGJDJ0", "FPDM00", "FPZLMC", "MJPH00", "XMID00", "GCBZID" FROM "YK_YPRKMX" WHERE ("RKDH00") = (?)
11      19:08:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 082936
12      19:08:36  SQL Execute: ORACLE - SELECT "YPRKPC", "RKDH00", "FPH000", "FPFLH0", "YPNM00", "YPMC00", "YPGG00", "RKDW00", "ZHL000", "RKSL00", "FPGJDJ", "KL0000", "GJDJ00", "LSDJ00", "PFDJ00", "GJJE00", "PCKCSL", "SCPH00", "YPSXRQ", "YPTHPC", "CXBZ00", "CXRKPC", "SFXYTJ", "SCCJBH", "SCCJZW", "CFWZBH", "CFWZMC", "BZ0000", "JHRQ00", "SFZBYP", "XXLSDJ", "ZBXH00", "YPJCL0", "ZBQNM0", "PZWH00", "ZKJE00", "FPRQ00", "YPZCZ0", "SCRQ00", "BHID00", "BH0000", "CDID00", "CDMC00", "SFYHGZ", "WGQK00", "YGJDJ0", "FPDM00", "FPZLMC", "MJPH00", "XMID00", "GCBZID" FROM "YK_YPRKMX" WHERE ("RKDH00") = (?)
13      19:08:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 082936
14      19:08:36  SQL Execute: ORACLE - SELECT "YPRKPC", "RKDH00", "FPH000", "FPFLH0", "YPNM00", "YPMC00", "YPGG00", "RKDW00", "ZHL000", "RKSL00", "FPGJDJ", "KL0000", "GJDJ00", "LSDJ00", "PFDJ00", "GJJE00", "PCKCSL", "SCPH00", "YPSXRQ", "YPTHPC", "CXBZ00", "CXRKPC", "SFXYTJ", "SCCJBH", "SCCJZW", "CFWZBH", "CFWZMC", "BZ0000", "JHRQ00", "SFZBYP", "XXLSDJ", "ZBXH00", "YPJCL0", "ZBQNM0", "PZWH00", "ZKJE00", "FPRQ00", "YPZCZ0", "SCRQ00", "BHID00", "BH0000", "CDID00", "CDMC00", "SFYHGZ", "WGQK00", "YGJDJ0", "FPDM00", "FPZLMC", "MJPH00", "XMID00", "GCBZID" FROM "YK_YPRKMX" WHERE ("RKDH00") = (?)
15      19:08:36  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 082936
16      19:08:36  SQL Execute: ORACLE - SELECT "YPRKPC", "RKDH00", "FPH000", "FPFLH0", "YPNM00", "YPMC00", "YPGG00", "RKDW00", "ZHL000", "RKSL00", "FPGJDJ", "KL0000", "GJDJ00", "LSDJ00", "PFDJ00", "GJJE00", "PCKCSL", "SCPH00", "YPSXRQ", "YPTHPC", "CXBZ00", "CXRKPC", "SFXYTJ", "SCCJBH", "SCCJZW", "CFWZBH", "CFWZMC", "BZ0000", "JHRQ00", "SFZBYP", "XXLSDJ", "ZBXH00", "YPJCL0", "ZBQNM0", "PZWH00", "ZKJE00", "FPRQ00", "YPZCZ0", "SCRQ00", "BHID00", "BH0000", "CDID00", "CDMC00", "SFYHGZ", "WGQK00", "YGJDJ0", "FPDM00", "FPZLMC", "MJPH00", "XMID00", "GCBZID" FROM "YK_YPRKMX" WHERE ("RKDH00") = (?)