1 16:59:18 SQL Prepare: ORACLE - select X.YPQLDH,X.YPNM00,X.YPMC00,X.YPGG00,X.CKSL00, X. CKDW00,X.ZHL000,X.CXBZ00, X.GJDJ00,X.LSDJ00,B.FPH000,B.KL0000,B.SCPH00,B.FPRQ00 from YK_YPQLMX B,YK_YPCKMX X where B.YPNM00=X.YPNM00 AND B.YPQLDH=X.YPQLDH AND B.YPQLDH=:1 order by B.YPQLPC 2 16:59:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 063208 3 16:59:18 SQL Execute: ORACLE - select X.YPQLDH,X.YPNM00,X.YPMC00,X.YPGG00,X.CKSL00, X. CKDW00,X.ZHL000,X.CXBZ00, X.GJDJ00,X.LSDJ00,B.FPH000,B.KL0000,B.SCPH00,B.FPRQ00 from YK_YPQLMX B,YK_YPCKMX X where B.YPNM00=X.YPNM00 AND B.YPQLDH=X.YPQLDH AND B.YPQLDH=? order by B.YPQLPC 4 16:59:18 SQL Prepare: 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" FROM "YK_YPRKMX" WHERE ("RKDH00") = (:1) ORDER BY "YPRKPC" 5 16:59:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 030960 6 16:59:18 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" FROM "YK_YPRKMX" WHERE ("RKDH00") = (?) ORDER BY "YPRKPC" 7 16:59:18 SQL Prepare: 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" FROM "YK_YPRKMX" WHERE ("RKDH00") = (:1) ORDER BY "YPRKPC" 8 16:59:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 030960 9 16:59:18 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" FROM "YK_YPRKMX" WHERE ("RKDH00") = (?) ORDER BY "YPRKPC" 10 16:59:18 SQL Prepare: ORACLE - select X.YPQLDH,X.YPNM00,X.YPMC00,X.YPGG00,X.CKSL00, X. CKDW00,X.ZHL000,X.CXBZ00, X.GJDJ00,X.LSDJ00,B.FPH000,B.KL0000,B.SCPH00,B.FPRQ00 from YK_YPQLMX B,YK_YPCKMX X where B.YPNM00=X.YPNM00 AND B.YPQLDH=X.YPQLDH AND B.YPQLDH=:1 order by B.YPQLPC 11 16:59:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 063208 12 16:59:18 SQL Execute: ORACLE - select X.YPQLDH,X.YPNM00,X.YPMC00,X.YPGG00,X.CKSL00, X. CKDW00,X.ZHL000,X.CXBZ00, X.GJDJ00,X.LSDJ00,B.FPH000,B.KL0000,B.SCPH00,B.FPRQ00 from YK_YPQLMX B,YK_YPCKMX X where B.YPNM00=X.YPNM00 AND B.YPQLDH=X.YPQLDH AND B.YPQLDH=? order by B.YPQLPC 13 16:59:18 SQL Prepare: 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" FROM "YK_YPRKMX" WHERE ("RKDH00") = (:1) ORDER BY "YPRKPC" 14 16:59:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 030960 15 16:59:18 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" FROM "YK_YPRKMX" WHERE ("RKDH00") = (?) ORDER BY "YPRKPC" 16 16:59:18 SQL Prepare: 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" FROM "YK_YPRKMX" WHERE ("RKDH00") = (:1) ORDER BY "YPRKPC" 17 16:59:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 030960 18 16:59:18 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" FROM "YK_YPRKMX" WHERE ("RKDH00") = (?) ORDER BY "YPRKPC" 19 16:59:18 SQL Prepare: ORACLE - SELECT B.LBMC00 FROM BM_YPLB00 B,BM_YD0000 D WHERE B.LBBH00=D.LBBH00 AND D.YPNM00='9366' 20 16:59:18 SQL Execute: ORACLE - SELECT B.LBMC00 FROM BM_YPLB00 B,BM_YD0000 D WHERE B.LBBH00=D.LBBH00 AND D.YPNM00='9366' 21 16:59:18 SQL Prepare: ORACLE - Select FKFSMC from BM_FKFS00 Where FKFSBH='01' 22 16:59:18 SQL Execute: ORACLE - Select FKFSMC from BM_FKFS00 Where FKFSBH='01' 23 16:59:18 SQL Prepare: ORACLE - Select SUM(ZKJE00) as HJJE00 from YK_YPRKD0 Where RKDH00 in ('030960') 24 16:59:18 SQL Execute: ORACLE - Select SUM(ZKJE00) as HJJE00 from YK_YPRKD0 Where RKDH00 in ('030960') 25 16:59:18 SQL Prepare: ORACLE - Select COUNT(DISTINCT FPH000) as FPZS00 from YK_YPRKMX Where RKDH00 in ('030960') 26 16:59:18 SQL Execute: ORACLE - Select COUNT(DISTINCT FPH000) as FPZS00 from YK_YPRKMX Where RKDH00 in ('030960') 27 16:59:18 SQL Prepare: ORACLE - Select SUM(GJJE00) as HJJE00, SUM(ROUND(LSDJ00*RKSL00,2)) AS LSZJE00,SUM(ROUND(PFDJ00*RKSL00,2)) PFJE00 from YK_YPRKMX Where RKDH00 in ('030960') 28 16:59:18 SQL Execute: ORACLE - Select SUM(GJJE00) as HJJE00, SUM(ROUND(LSDJ00*RKSL00,2)) AS LSZJE00,SUM(ROUND(PFDJ00*RKSL00,2)) PFJE00 from YK_YPRKMX Where RKDH00 in ('030960') 29 16:59:18 SQL Prepare: ORACLE - Select instr('030960',',') COUNT from DUAL 30 16:59:18 SQL Execute: ORACLE - Select instr('030960',',') COUNT from DUAL 31 16:59:18 SQL Prepare: ORACLE - Select KHYY00,YHZH00,GHDWMC from BM_YPGHDW Where GHDWNM=10087 32 16:59:18 SQL Execute: ORACLE - Select KHYY00,YHZH00,GHDWMC from BM_YPGHDW Where GHDWNM=10087 33 16:59:18 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 34 16:59:18 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL