1       11:38:30  SQL Execute: ORACLE - SELECT RKLXMC,YPBM00,YPMC00,YPGG00,RKDW00,SUM(RKSL00) RKSL00,
FPGJDJ,SUM(RKSL00*FPGJDJ) GJJE00,LSDJ00,SUM(RKSL00*LSDJ00) LSJE00,
SUM(RKSL00*RKSL00)-SUM(RKSL00*LSDJ00) JXCJ00,PYSM00,ZBXH00,SCCJZW,GHDWMC,YLMC00,ypxz01,JXMC00,CDMC00 
FROM VW_YK_YPRKCX 
 WHERE YKBMBH= 11
 AND JHRQ00>='20180101' AND JHRQ00<='20180131' 
 AND LBBH00 LIKE '0%'
 AND YLBH00 LIKE '%'
 AND JXBH00 LIKE '%'
 GROUP BY RKLXMC,YPBM00,YPMC00,YPGG00,RKDW00,FPGJDJ,LSDJ00,PYSM00,ZBXH00,SCCJZW,GHDWMC,YLMC00,ypxz01,JXMC00,CDMC00
 ORDER BY YPBM00

2       11:38:30  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

3       11:38:31  SQL Execute: ORACLE - RollBack

4       11:38:31  SQL Data In: ORACLE - Rows affected = 0
5       11:38:34  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '3') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',11,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1150,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1150 AND b.JSKSBH = '11')
  AND (INSTR (',' || a.jsksbh || ',',',11,') > 0 or a.jsksbh is null)  

6       14:16:25  Log started for: Ʊ¾Ý´òÓ¡ºǫ́ÅäÖÃ