1 15:38:14 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 2 15:38:14 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 3 15:38:14 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 4 15:38:14 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 5 15:38:14 SQL Prepare: ORACLE - SELECT b.ZYID00,sf_xt_yymc00(46) YYJC00, Y.CKDH00,Y.ZYH000,Y.CH0000,Y.BRXM00,Y.TQDJH0,Y.YPQLPC,B.CSRQ00,B.XB0000,Y.YPYFMC, Y.YPMC00,Y.YPGG00,(select YPTYM0 FROM BM_YD0000 WHERE YPNM00=Y.YPNM00) AS YPTYM0, Y.LSDJ00,Y.YPZSL0,Y.QLDW00,Y.PCMC00,Y.YZID00,Y.ZYTS00,Y.YPDLBH,Y.FYRQ00,Y.FYSJ00,Y.YFSMMC, DECODE(SUBSTR(Y.CSL000,1,1),'.','0','')||Y.CSL000||Y.JLDW00 AS DJL000, TRIM(Y.YPYFMC)||TRIM(Y.XMYFMC) as YYFF00, (SELECT M.ZWXM00 FROM BM_YGBM00 M WHERE M.YGBH00=Y.YSGZH0) YSXM00, Y.THBZ00,Y.FJFDJH,Y.SRRQ00,Y.SRSJ00,Y.PCSJ00,Y.FYRQ00,Y.FYSJ00,Y.BZ0000,Y.ZYDJS0, SF_YF_EXROUND(Y.YPZSL0*Y.LSDJ00,0,2) AS C_YPJE ,(select trim(zqs000||zqdw00) from BQ_YPYZ00 e where e.yzid00=Y.YZID00 AND ROWNUM=1) CXTS00 FROM YF_YZYPSQ Y,ZY_BRXXB0 B WHERE Y.ZYID00=B.ZYID00 AND Y.CKDH00='138423' ORDER BY Y.CH0000,Y.YPDLBH,Y.SRRQ00,DECODE(Y.YPDLBH,'2',TO_CHAR(Y.YZID00), Y.YPMC00),DECODE(Y.YPDLBH,'2',Y.TQDJH0),Y.YZMXID 6 15:38:14 SQL Execute: ORACLE - SELECT b.ZYID00,sf_xt_yymc00(46) YYJC00, Y.CKDH00,Y.ZYH000,Y.CH0000,Y.BRXM00,Y.TQDJH0,Y.YPQLPC,B.CSRQ00,B.XB0000,Y.YPYFMC, Y.YPMC00,Y.YPGG00,(select YPTYM0 FROM BM_YD0000 WHERE YPNM00=Y.YPNM00) AS YPTYM0, Y.LSDJ00,Y.YPZSL0,Y.QLDW00,Y.PCMC00,Y.YZID00,Y.ZYTS00,Y.YPDLBH,Y.FYRQ00,Y.FYSJ00,Y.YFSMMC, DECODE(SUBSTR(Y.CSL000,1,1),'.','0','')||Y.CSL000||Y.JLDW00 AS DJL000, TRIM(Y.YPYFMC)||TRIM(Y.XMYFMC) as YYFF00, (SELECT M.ZWXM00 FROM BM_YGBM00 M WHERE M.YGBH00=Y.YSGZH0) YSXM00, Y.THBZ00,Y.FJFDJH,Y.SRRQ00,Y.SRSJ00,Y.PCSJ00,Y.FYRQ00,Y.FYSJ00,Y.BZ0000,Y.ZYDJS0, SF_YF_EXROUND(Y.YPZSL0*Y.LSDJ00,0,2) AS C_YPJE ,(select trim(zqs000||zqdw00) from BQ_YPYZ00 e where e.yzid00=Y.YZID00 AND ROWNUM=1) CXTS00 FROM YF_YZYPSQ Y,ZY_BRXXB0 B WHERE Y.ZYID00=B.ZYID00 AND Y.CKDH00='138423' ORDER BY Y.CH0000,Y.YPDLBH,Y.SRRQ00,DECODE(Y.YPDLBH,'2',TO_CHAR(Y.YZID00), Y.YPMC00),DECODE(Y.YPDLBH,'2',Y.TQDJH0),Y.YZMXID 7 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19320701) AS NL FROM DUAL 8 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19320701) AS NL FROM DUAL 9 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19300801) AS NL FROM DUAL 10 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19300801) AS NL FROM DUAL 11 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19270701) AS NL FROM DUAL 12 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19270701) AS NL FROM DUAL 13 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19290801) AS NL FROM DUAL 14 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19290801) AS NL FROM DUAL 15 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19360601) AS NL FROM DUAL 16 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19360601) AS NL FROM DUAL 17 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19420701) AS NL FROM DUAL 18 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19420701) AS NL FROM DUAL 19 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19220518) AS NL FROM DUAL 20 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19220518) AS NL FROM DUAL 21 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19320701) AS NL FROM DUAL 22 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19320701) AS NL FROM DUAL 23 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19480801) AS NL FROM DUAL 24 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19480801) AS NL FROM DUAL 25 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19340701) AS NL FROM DUAL 26 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19340701) AS NL FROM DUAL 27 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19270801) AS NL FROM DUAL 28 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19270801) AS NL FROM DUAL 29 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19340801) AS NL FROM DUAL 30 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19340801) AS NL FROM DUAL 31 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19380801) AS NL FROM DUAL 32 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19380801) AS NL FROM DUAL 33 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19480701) AS NL FROM DUAL 34 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19480701) AS NL FROM DUAL 35 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19420801) AS NL FROM DUAL 36 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19420801) AS NL FROM DUAL 37 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19700701) AS NL FROM DUAL 38 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19700701) AS NL FROM DUAL 39 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19740801) AS NL FROM DUAL 40 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19740801) AS NL FROM DUAL 41 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19370621) AS NL FROM DUAL 42 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19370621) AS NL FROM DUAL 43 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19570801) AS NL FROM DUAL 44 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19570801) AS NL FROM DUAL 45 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19250701) AS NL FROM DUAL 46 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19250701) AS NL FROM DUAL 47 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19270517) AS NL FROM DUAL 48 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19270517) AS NL FROM DUAL 49 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19640203) AS NL FROM DUAL 50 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19640203) AS NL FROM DUAL 51 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19630801) AS NL FROM DUAL 52 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19630801) AS NL FROM DUAL 53 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19630801) AS NL FROM DUAL 54 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19630801) AS NL FROM DUAL 55 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19470708) AS NL FROM DUAL 56 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19470708) AS NL FROM DUAL 57 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19230801) AS NL FROM DUAL 58 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19230801) AS NL FROM DUAL 59 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19500526) AS NL FROM DUAL 60 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19500526) AS NL FROM DUAL 61 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19480530) AS NL FROM DUAL 62 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19480530) AS NL FROM DUAL 63 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19400801) AS NL FROM DUAL 64 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19400801) AS NL FROM DUAL 65 15:38:14 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19370701) AS NL FROM DUAL 66 15:38:14 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19370701) AS NL FROM DUAL