1       11:46:22  SQL Execute: ORACLE - select * from dual 

2       11:46:53  SQL Execute: ORACLE - select * from dual 

3       11:47:23  SQL Execute: ORACLE - select * from dual 

4       11:47:54  SQL Execute: ORACLE - select * from dual 

5       11:48:24  SQL Execute: ORACLE - select * from dual 

6       11:48:47  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

7       11:48:47  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

8       11:48:47  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'003'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'003'||'|',1,1) >0  AND A.YQDH00='AU' 

9       11:48:47  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'003'||'|',1,1) >0  AND YQDH00='AU'

10      11:48:47  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

11      11:48:47  SQL Data In: ORACLE - Rows affected = 0
12      11:48:47  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '133.5', JYJG00 = '133.5', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:47', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4398' AND YQDH00 = 'AU'

13      11:48:47  SQL Data In: ORACLE - Rows affected = 1
14      11:48:47  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4398','AU','133.5','133.5','','','0','0','20170927','20170927','20170927','11:48:47','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4398' AND YQJCRQ='20170927')

15      11:48:47  SQL Data In: ORACLE - Rows affected = 0
16      11:48:47  SQL Execute: ORACLE - commit

17      11:48:47  SQL Data In: ORACLE - Rows affected = 0
18      11:48:47  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

19      11:48:47  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

20      11:48:47  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'004'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'004'||'|',1,1) >0  AND A.YQDH00='AU' 

21      11:48:47  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'004'||'|',1,1) >0  AND YQDH00='AU'

22      11:48:47  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

23      11:48:47  SQL Data In: ORACLE - Rows affected = 0
24      11:48:47  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '55.4', JYJG00 = '55.4', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:47', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4399' AND YQDH00 = 'AU'

25      11:48:47  SQL Data In: ORACLE - Rows affected = 1
26      11:48:47  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4399','AU','55.4','55.4','','','0','0','20170927','20170927','20170927','11:48:47','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4399' AND YQJCRQ='20170927')

27      11:48:47  SQL Data In: ORACLE - Rows affected = 0
28      11:48:47  SQL Execute: ORACLE - commit

29      11:48:47  SQL Data In: ORACLE - Rows affected = 0
30      11:48:47  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

31      11:48:47  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

32      11:48:47  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'005'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'005'||'|',1,1) >0  AND A.YQDH00='AU' 

33      11:48:47  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'005'||'|',1,1) >0  AND YQDH00='AU'

34      11:48:47  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

35      11:48:47  SQL Data In: ORACLE - Rows affected = 0
36      11:48:47  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '19.4', JYJG00 = '19.4', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:47', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4392' AND YQDH00 = 'AU'

37      11:48:48  SQL Data In: ORACLE - Rows affected = 1
38      11:48:48  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4392','AU','19.4','19.4','','','0','0','20170927','20170927','20170927','11:48:47','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4392' AND YQJCRQ='20170927')

39      11:48:48  SQL Data In: ORACLE - Rows affected = 0
40      11:48:48  SQL Execute: ORACLE - commit

41      11:48:48  SQL Data In: ORACLE - Rows affected = 0
42      11:48:48  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

43      11:48:48  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

44      11:48:48  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'015'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'015'||'|',1,1) >0  AND A.YQDH00='AU' 

45      11:48:48  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'015'||'|',1,1) >0  AND YQDH00='AU'

46      11:48:48  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

47      11:48:48  SQL Data In: ORACLE - Rows affected = 0
48      11:48:48  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '367', JYJG00 = '367', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:47', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4404' AND YQDH00 = 'AU'

49      11:48:48  SQL Data In: ORACLE - Rows affected = 1
50      11:48:48  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4404','AU','367','367','','','0','0','20170927','20170927','20170927','11:48:47','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4404' AND YQJCRQ='20170927')

51      11:48:48  SQL Data In: ORACLE - Rows affected = 0
52      11:48:48  SQL Execute: ORACLE - commit

53      11:48:48  SQL Data In: ORACLE - Rows affected = 0
54      11:48:48  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

55      11:48:48  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

56      11:48:48  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'021'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'021'||'|',1,1) >0  AND A.YQDH00='AU' 

57      11:48:48  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'021'||'|',1,1) >0  AND YQDH00='AU'

58      11:48:48  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

59      11:48:48  SQL Data In: ORACLE - Rows affected = 0
60      11:48:48  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '4.10', JYJG00 = '4.10', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:47', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4417' AND YQDH00 = 'AU'

61      11:48:48  SQL Data In: ORACLE - Rows affected = 1
62      11:48:48  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4417','AU','4.10','4.10','','','0','0','20170927','20170927','20170927','11:48:47','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4417' AND YQJCRQ='20170927')

63      11:48:48  SQL Data In: ORACLE - Rows affected = 0
64      11:48:48  SQL Execute: ORACLE - commit

65      11:48:48  SQL Data In: ORACLE - Rows affected = 0
66      11:48:48  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

67      11:48:48  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

68      11:48:48  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'097'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'097'||'|',1,1) >0  AND A.YQDH00='AU' 

69      11:48:48  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'097'||'|',1,1) >0  AND YQDH00='AU'

70      11:48:48  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

71      11:48:48  SQL Data In: ORACLE - Rows affected = 0
72      11:48:48  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '120.1', JYJG00 = '120.1', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:47', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4414' AND YQDH00 = 'AU'

73      11:48:48  SQL Data In: ORACLE - Rows affected = 1
74      11:48:48  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4414','AU','120.1','120.1','','','0','0','20170927','20170927','20170927','11:48:47','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4414' AND YQJCRQ='20170927')

75      11:48:48  SQL Data In: ORACLE - Rows affected = 0
76      11:48:48  SQL Execute: ORACLE - commit

77      11:48:48  SQL Data In: ORACLE - Rows affected = 0
78      11:48:48  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

79      11:48:48  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

80      11:48:48  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'098'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'098'||'|',1,1) >0  AND A.YQDH00='AU' 

81      11:48:48  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'098'||'|',1,1) >0  AND YQDH00='AU'

82      11:48:48  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

83      11:48:48  SQL Data In: ORACLE - Rows affected = 0
84      11:48:48  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '3.77', JYJG00 = '3.77', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:47', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4413' AND YQDH00 = 'AU'

85      11:48:49  SQL Data In: ORACLE - Rows affected = 1
86      11:48:49  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4413','AU','3.77','3.77','','','0','0','20170927','20170927','20170927','11:48:47','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4413' AND YQJCRQ='20170927')

87      11:48:49  SQL Data In: ORACLE - Rows affected = 0
88      11:48:49  SQL Execute: ORACLE - commit

89      11:48:49  SQL Data In: ORACLE - Rows affected = 0
90      11:48:49  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

91      11:48:49  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

92      11:48:49  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'099'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'099'||'|',1,1) >0  AND A.YQDH00='AU' 

93      11:48:49  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'099'||'|',1,1) >0  AND YQDH00='AU'

94      11:48:49  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

95      11:48:49  SQL Data In: ORACLE - Rows affected = 0
96      11:48:49  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '89.9', JYJG00 = '89.9', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:47', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4415' AND YQDH00 = 'AU'

97      11:48:49  SQL Data In: ORACLE - Rows affected = 1
98      11:48:49  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4415','AU','89.9','89.9','','','0','0','20170927','20170927','20170927','11:48:47','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4415' AND YQJCRQ='20170927')

99      11:48:49  SQL Data In: ORACLE - Rows affected = 0
100     11:48:49  SQL Execute: ORACLE - commit

101     11:48:49  SQL Data In: ORACLE - Rows affected = 0
102     11:48:49  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

103     11:48:49  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

104     11:48:49  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'009'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'009'||'|',1,1) >0  AND A.YQDH00='AU' 

105     11:48:49  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'009'||'|',1,1) >0  AND YQDH00='AU'

106     11:48:49  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

107     11:48:49  SQL Data In: ORACLE - Rows affected = 0
108     11:48:49  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '37.3', JYJG00 = '37.3', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:49', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4443' AND YQDH00 = 'AU'

109     11:48:49  SQL Data In: ORACLE - Rows affected = 1
110     11:48:49  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4443','AU','37.3','37.3','','','0','0','20170927','20170927','20170927','11:48:49','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4443' AND YQJCRQ='20170927')

111     11:48:49  SQL Data In: ORACLE - Rows affected = 0
112     11:48:49  SQL Execute: ORACLE - commit

113     11:48:49  SQL Data In: ORACLE - Rows affected = 0
114     11:48:49  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

115     11:48:49  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

116     11:48:49  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'011'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'011'||'|',1,1) >0  AND A.YQDH00='AU' 

117     11:48:49  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'011'||'|',1,1) >0  AND YQDH00='AU'

118     11:48:49  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

119     11:48:49  SQL Data In: ORACLE - Rows affected = 0
120     11:48:49  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '3478', JYJG00 = '3478', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:49', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4448' AND YQDH00 = 'AU'

121     11:48:50  SQL Data In: ORACLE - Rows affected = 1
122     11:48:50  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4448','AU','3478','3478','','','0','0','20170927','20170927','20170927','11:48:49','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4448' AND YQJCRQ='20170927')

123     11:48:50  SQL Data In: ORACLE - Rows affected = 0
124     11:48:50  SQL Execute: ORACLE - commit

125     11:48:50  SQL Data In: ORACLE - Rows affected = 0
126     11:48:50  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

127     11:48:50  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

128     11:48:50  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'013'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'013'||'|',1,1) >0  AND A.YQDH00='AU' 

129     11:48:50  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'013'||'|',1,1) >0  AND YQDH00='AU'

130     11:48:50  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

131     11:48:50  SQL Data In: ORACLE - Rows affected = 0
132     11:48:50  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '107', JYJG00 = '107', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:49', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4402' AND YQDH00 = 'AU'

133     11:48:50  SQL Data In: ORACLE - Rows affected = 1
134     11:48:50  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4402','AU','107','107','','','0','0','20170927','20170927','20170927','11:48:49','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4402' AND YQJCRQ='20170927')

135     11:48:50  SQL Data In: ORACLE - Rows affected = 0
136     11:48:50  SQL Execute: ORACLE - commit

137     11:48:50  SQL Data In: ORACLE - Rows affected = 0
138     11:48:50  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

139     11:48:50  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

140     11:48:50  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'017'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'017'||'|',1,1) >0  AND A.YQDH00='AU' 

141     11:48:50  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'017'||'|',1,1) >0  AND YQDH00='AU'

142     11:48:50  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

143     11:48:50  SQL Data In: ORACLE - Rows affected = 0
144     11:48:50  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '1.98', JYJG00 = '1.98', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:49', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4433' AND YQDH00 = 'AU'

145     11:48:50  SQL Data In: ORACLE - Rows affected = 1
146     11:48:50  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4433','AU','1.98','1.98','','','0','0','20170927','20170927','20170927','11:48:49','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4433' AND YQJCRQ='20170927')

147     11:48:50  SQL Data In: ORACLE - Rows affected = 0
148     11:48:50  SQL Execute: ORACLE - commit

149     11:48:50  SQL Data In: ORACLE - Rows affected = 0
150     11:48:50  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

151     11:48:50  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

152     11:48:50  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'027'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'027'||'|',1,1) >0  AND A.YQDH00='AU' 

153     11:48:50  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'027'||'|',1,1) >0  AND YQDH00='AU'

154     11:48:50  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

155     11:48:50  SQL Data In: ORACLE - Rows affected = 0
156     11:48:50  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '152.4', JYJG00 = '152.4', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:49', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4409' AND YQDH00 = 'AU'

157     11:48:50  SQL Data In: ORACLE - Rows affected = 1
158     11:48:50  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4409','AU','152.4','152.4','','','0','0','20170927','20170927','20170927','11:48:49','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4409' AND YQJCRQ='20170927')

159     11:48:50  SQL Data In: ORACLE - Rows affected = 0
160     11:48:50  SQL Execute: ORACLE - commit

161     11:48:50  SQL Data In: ORACLE - Rows affected = 0
162     11:48:51  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

163     11:48:51  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

164     11:48:51  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'003'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'003'||'|',1,1) >0  AND A.YQDH00='AU' 

165     11:48:51  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'003'||'|',1,1) >0  AND YQDH00='AU'

166     11:48:51  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

167     11:48:51  SQL Data In: ORACLE - Rows affected = 0
168     11:48:51  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '528.0', JYJG00 = '528.0', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:51', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4398' AND YQDH00 = 'AU'

169     11:48:51  SQL Data In: ORACLE - Rows affected = 1
170     11:48:51  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4398','AU','528.0','528.0','','','0','0','20170927','20170927','20170927','11:48:51','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4398' AND YQJCRQ='20170927')

171     11:48:51  SQL Data In: ORACLE - Rows affected = 0
172     11:48:51  SQL Execute: ORACLE - commit

173     11:48:51  SQL Data In: ORACLE - Rows affected = 0
174     11:48:51  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

175     11:48:51  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

176     11:48:51  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'004'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'004'||'|',1,1) >0  AND A.YQDH00='AU' 

177     11:48:51  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'004'||'|',1,1) >0  AND YQDH00='AU'

178     11:48:51  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

179     11:48:51  SQL Data In: ORACLE - Rows affected = 0
180     11:48:51  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '150.6', JYJG00 = '150.6', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:51', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4399' AND YQDH00 = 'AU'

181     11:48:52  SQL Data In: ORACLE - Rows affected = 1
182     11:48:52  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4399','AU','150.6','150.6','','','0','0','20170927','20170927','20170927','11:48:51','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4399' AND YQJCRQ='20170927')

183     11:48:52  SQL Data In: ORACLE - Rows affected = 0
184     11:48:52  SQL Execute: ORACLE - commit

185     11:48:52  SQL Data In: ORACLE - Rows affected = 0
186     11:48:52  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

187     11:48:52  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

188     11:48:52  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'005'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'005'||'|',1,1) >0  AND A.YQDH00='AU' 

189     11:48:52  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'005'||'|',1,1) >0  AND YQDH00='AU'

190     11:48:52  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

191     11:48:52  SQL Data In: ORACLE - Rows affected = 0
192     11:48:52  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '93.8', JYJG00 = '93.8', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:51', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4392' AND YQDH00 = 'AU'

193     11:48:52  SQL Data In: ORACLE - Rows affected = 1
194     11:48:52  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4392','AU','93.8','93.8','','','0','0','20170927','20170927','20170927','11:48:51','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4392' AND YQJCRQ='20170927')

195     11:48:52  SQL Data In: ORACLE - Rows affected = 0
196     11:48:52  SQL Execute: ORACLE - commit

197     11:48:52  SQL Data In: ORACLE - Rows affected = 0
198     11:48:52  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

199     11:48:52  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

200     11:48:52  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'015'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'015'||'|',1,1) >0  AND A.YQDH00='AU' 

201     11:48:52  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'015'||'|',1,1) >0  AND YQDH00='AU'

202     11:48:52  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

203     11:48:52  SQL Data In: ORACLE - Rows affected = 0
204     11:48:52  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '555', JYJG00 = '555', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:51', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4404' AND YQDH00 = 'AU'

205     11:48:52  SQL Data In: ORACLE - Rows affected = 1
206     11:48:52  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4404','AU','555','555','','','0','0','20170927','20170927','20170927','11:48:51','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4404' AND YQJCRQ='20170927')

207     11:48:52  SQL Data In: ORACLE - Rows affected = 0
208     11:48:52  SQL Execute: ORACLE - commit

209     11:48:52  SQL Data In: ORACLE - Rows affected = 0
210     11:48:52  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

211     11:48:52  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

212     11:48:52  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'021'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'021'||'|',1,1) >0  AND A.YQDH00='AU' 

213     11:48:52  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'021'||'|',1,1) >0  AND YQDH00='AU'

214     11:48:52  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

215     11:48:52  SQL Data In: ORACLE - Rows affected = 0
216     11:48:52  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '7.56', JYJG00 = '7.56', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:51', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4417' AND YQDH00 = 'AU'

217     11:48:52  SQL Data In: ORACLE - Rows affected = 1
218     11:48:52  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4417','AU','7.56','7.56','','','0','0','20170927','20170927','20170927','11:48:51','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4417' AND YQJCRQ='20170927')

219     11:48:52  SQL Data In: ORACLE - Rows affected = 0
220     11:48:52  SQL Execute: ORACLE - commit

221     11:48:52  SQL Data In: ORACLE - Rows affected = 0
222     11:48:52  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

223     11:48:52  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

224     11:48:52  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'097'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'097'||'|',1,1) >0  AND A.YQDH00='AU' 

225     11:48:52  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'097'||'|',1,1) >0  AND YQDH00='AU'

226     11:48:52  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

227     11:48:52  SQL Data In: ORACLE - Rows affected = 0
228     11:48:52  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '150.9', JYJG00 = '150.9', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:51', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4414' AND YQDH00 = 'AU'

229     11:48:53  SQL Data In: ORACLE - Rows affected = 1
230     11:48:53  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4414','AU','150.9','150.9','','','0','0','20170927','20170927','20170927','11:48:51','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4414' AND YQJCRQ='20170927')

231     11:48:53  SQL Data In: ORACLE - Rows affected = 0
232     11:48:53  SQL Execute: ORACLE - commit

233     11:48:53  SQL Data In: ORACLE - Rows affected = 0
234     11:48:53  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

235     11:48:53  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

236     11:48:53  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'098'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'098'||'|',1,1) >0  AND A.YQDH00='AU' 

237     11:48:53  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'098'||'|',1,1) >0  AND YQDH00='AU'

238     11:48:53  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

239     11:48:53  SQL Data In: ORACLE - Rows affected = 0
240     11:48:53  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '6.32', JYJG00 = '6.32', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:51', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4413' AND YQDH00 = 'AU'

241     11:48:53  SQL Data In: ORACLE - Rows affected = 1
242     11:48:53  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4413','AU','6.32','6.32','','','0','0','20170927','20170927','20170927','11:48:51','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4413' AND YQJCRQ='20170927')

243     11:48:53  SQL Data In: ORACLE - Rows affected = 0
244     11:48:53  SQL Execute: ORACLE - commit

245     11:48:53  SQL Data In: ORACLE - Rows affected = 0
246     11:48:53  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

247     11:48:53  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

248     11:48:53  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'099'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'099'||'|',1,1) >0  AND A.YQDH00='AU' 

249     11:48:53  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'099'||'|',1,1) >0  AND YQDH00='AU'

250     11:48:53  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

251     11:48:53  SQL Data In: ORACLE - Rows affected = 0
252     11:48:53  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '109.5', JYJG00 = '109.5', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:51', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4415' AND YQDH00 = 'AU'

253     11:48:53  SQL Data In: ORACLE - Rows affected = 1
254     11:48:53  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4415','AU','109.5','109.5','','','0','0','20170927','20170927','20170927','11:48:51','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4415' AND YQJCRQ='20170927')

255     11:48:53  SQL Data In: ORACLE - Rows affected = 0
256     11:48:53  SQL Execute: ORACLE - commit

257     11:48:53  SQL Data In: ORACLE - Rows affected = 0
258     11:48:53  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

259     11:48:53  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

260     11:48:53  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'009'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'009'||'|',1,1) >0  AND A.YQDH00='AU' 

261     11:48:53  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'009'||'|',1,1) >0  AND YQDH00='AU'

262     11:48:53  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

263     11:48:53  SQL Data In: ORACLE - Rows affected = 0
264     11:48:53  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '77.4', JYJG00 = '77.4', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:53', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4443' AND YQDH00 = 'AU'

265     11:48:53  SQL Data In: ORACLE - Rows affected = 1
266     11:48:53  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4443','AU','77.4','77.4','','','0','0','20170927','20170927','20170927','11:48:53','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4443' AND YQJCRQ='20170927')

267     11:48:53  SQL Data In: ORACLE - Rows affected = 0
268     11:48:53  SQL Execute: ORACLE - commit

269     11:48:53  SQL Data In: ORACLE - Rows affected = 0
270     11:48:53  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

271     11:48:53  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

272     11:48:53  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'011'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'011'||'|',1,1) >0  AND A.YQDH00='AU' 

273     11:48:53  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'011'||'|',1,1) >0  AND YQDH00='AU'

274     11:48:53  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

275     11:48:53  SQL Data In: ORACLE - Rows affected = 0
276     11:48:53  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '6563', JYJG00 = '6563', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:53', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4448' AND YQDH00 = 'AU'

277     11:48:54  SQL Data In: ORACLE - Rows affected = 1
278     11:48:54  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4448','AU','6563','6563','','','0','0','20170927','20170927','20170927','11:48:53','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4448' AND YQJCRQ='20170927')

279     11:48:54  SQL Data In: ORACLE - Rows affected = 0
280     11:48:54  SQL Execute: ORACLE - commit

281     11:48:54  SQL Data In: ORACLE - Rows affected = 0
282     11:48:54  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

283     11:48:54  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

284     11:48:54  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'013'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'013'||'|',1,1) >0  AND A.YQDH00='AU' 

285     11:48:54  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'013'||'|',1,1) >0  AND YQDH00='AU'

286     11:48:54  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

287     11:48:54  SQL Data In: ORACLE - Rows affected = 0
288     11:48:54  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '392', JYJG00 = '392', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:53', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4402' AND YQDH00 = 'AU'

289     11:48:54  SQL Data In: ORACLE - Rows affected = 1
290     11:48:54  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4402','AU','392','392','','','0','0','20170927','20170927','20170927','11:48:53','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4402' AND YQJCRQ='20170927')

291     11:48:54  SQL Data In: ORACLE - Rows affected = 0
292     11:48:54  SQL Execute: ORACLE - commit

293     11:48:54  SQL Data In: ORACLE - Rows affected = 0
294     11:48:54  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

295     11:48:54  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

296     11:48:54  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'017'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'017'||'|',1,1) >0  AND A.YQDH00='AU' 

297     11:48:54  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'017'||'|',1,1) >0  AND YQDH00='AU'

298     11:48:54  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

299     11:48:54  SQL Data In: ORACLE - Rows affected = 0
300     11:48:54  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '3.52', JYJG00 = '3.52', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:53', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4433' AND YQDH00 = 'AU'

301     11:48:54  SQL Data In: ORACLE - Rows affected = 1
302     11:48:54  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4433','AU','3.52','3.52','','','0','0','20170927','20170927','20170927','11:48:53','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4433' AND YQJCRQ='20170927')

303     11:48:54  SQL Data In: ORACLE - Rows affected = 0
304     11:48:54  SQL Execute: ORACLE - commit

305     11:48:54  SQL Data In: ORACLE - Rows affected = 0
306     11:48:54  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

307     11:48:54  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

308     11:48:54  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'027'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'027'||'|',1,1) >0  AND A.YQDH00='AU' 

309     11:48:54  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'027'||'|',1,1) >0  AND YQDH00='AU'

310     11:48:54  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

311     11:48:54  SQL Data In: ORACLE - Rows affected = 0
312     11:48:54  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '542.2', JYJG00 = '542.2', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:53', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4409' AND YQDH00 = 'AU'

313     11:48:54  SQL Data In: ORACLE - Rows affected = 1
314     11:48:54  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4409','AU','542.2','542.2','','','0','0','20170927','20170927','20170927','11:48:53','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4409' AND YQJCRQ='20170927')

315     11:48:54  SQL Data In: ORACLE - Rows affected = 0
316     11:48:54  SQL Execute: ORACLE - commit

317     11:48:54  SQL Data In: ORACLE - Rows affected = 0
318     11:48:55  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

319     11:48:55  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

320     11:48:55  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'001'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'001'||'|',1,1) >0  AND A.YQDH00='AU' 

321     11:48:55  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'001'||'|',1,1) >0  AND YQDH00='AU'

322     11:48:55  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

323     11:48:55  SQL Data In: ORACLE - Rows affected = 0
324     11:48:55  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '45.8', JYJG00 = '45.8', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:56', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4395' AND YQDH00 = 'AU'

325     11:48:56  SQL Data In: ORACLE - Rows affected = 1
326     11:48:56  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4395','AU','45.8','45.8','','','0','0','20170927','20170927','20170927','11:48:56','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4395' AND YQJCRQ='20170927')

327     11:48:56  SQL Data In: ORACLE - Rows affected = 0
328     11:48:56  SQL Execute: ORACLE - commit

329     11:48:56  SQL Data In: ORACLE - Rows affected = 0
330     11:48:56  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

331     11:48:56  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

332     11:48:56  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'010'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'010'||'|',1,1) >0  AND A.YQDH00='AU' 

333     11:48:56  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'010'||'|',1,1) >0  AND YQDH00='AU'

334     11:48:56  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

335     11:48:56  SQL Data In: ORACLE - Rows affected = 0
336     11:48:56  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '21.9', JYJG00 = '21.9', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:56', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4389' AND YQDH00 = 'AU'

337     11:48:56  SQL Data In: ORACLE - Rows affected = 1
338     11:48:56  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4389','AU','21.9','21.9','','','0','0','20170927','20170927','20170927','11:48:56','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4389' AND YQJCRQ='20170927')

339     11:48:56  SQL Data In: ORACLE - Rows affected = 0
340     11:48:56  SQL Execute: ORACLE - commit

341     11:48:56  SQL Data In: ORACLE - Rows affected = 0
342     11:48:56  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

343     11:48:56  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

344     11:48:56  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'014'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'014'||'|',1,1) >0  AND A.YQDH00='AU' 

345     11:48:56  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'014'||'|',1,1) >0  AND YQDH00='AU'

346     11:48:56  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

347     11:48:56  SQL Data In: ORACLE - Rows affected = 0
348     11:48:56  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '5.57', JYJG00 = '5.57', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:56', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4405' AND YQDH00 = 'AU'

349     11:48:56  SQL Data In: ORACLE - Rows affected = 1
350     11:48:56  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4405','AU','5.57','5.57','','','0','0','20170927','20170927','20170927','11:48:56','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4405' AND YQJCRQ='20170927')

351     11:48:56  SQL Data In: ORACLE - Rows affected = 0
352     11:48:56  SQL Execute: ORACLE - commit

353     11:48:56  SQL Data In: ORACLE - Rows affected = 0
354     11:48:56  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

355     11:48:56  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

356     11:48:56  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'018'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'018'||'|',1,1) >0  AND A.YQDH00='AU' 

357     11:48:56  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'018'||'|',1,1) >0  AND YQDH00='AU'

358     11:48:56  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

359     11:48:56  SQL Data In: ORACLE - Rows affected = 0
360     11:48:56  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '0.97', JYJG00 = '0.97', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:56', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4432' AND YQDH00 = 'AU'

361     11:48:56  SQL Data In: ORACLE - Rows affected = 1
362     11:48:56  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4432','AU','0.97','0.97','','','0','0','20170927','20170927','20170927','11:48:56','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4432' AND YQJCRQ='20170927')

363     11:48:56  SQL Data In: ORACLE - Rows affected = 0
364     11:48:56  SQL Execute: ORACLE - commit

365     11:48:56  SQL Data In: ORACLE - Rows affected = 0
366     11:48:56  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

367     11:48:56  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

368     11:48:56  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'026'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'026'||'|',1,1) >0  AND A.YQDH00='AU' 

369     11:48:56  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'026'||'|',1,1) >0  AND YQDH00='AU'

370     11:48:56  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

371     11:48:56  SQL Data In: ORACLE - Rows affected = 0
372     11:48:56  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '164.2', JYJG00 = '164.2', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:56', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4410' AND YQDH00 = 'AU'

373     11:48:57  SQL Data In: ORACLE - Rows affected = 1
374     11:48:57  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4410','AU','164.2','164.2','','','0','0','20170927','20170927','20170927','11:48:56','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4410' AND YQJCRQ='20170927')

375     11:48:57  SQL Data In: ORACLE - Rows affected = 0
376     11:48:57  SQL Execute: ORACLE - commit

377     11:48:57  SQL Data In: ORACLE - Rows affected = 0
378     11:48:57  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

379     11:48:57  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

380     11:48:57  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'002'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'002'||'|',1,1) >0  AND A.YQDH00='AU' 

381     11:48:57  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'002'||'|',1,1) >0  AND YQDH00='AU'

382     11:48:57  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

383     11:48:57  SQL Data In: ORACLE - Rows affected = 0
384     11:48:57  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '50.6', JYJG00 = '50.6', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:58', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4396' AND YQDH00 = 'AU'

385     11:48:58  SQL Data In: ORACLE - Rows affected = 1
386     11:48:58  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4396','AU','50.6','50.6','','','0','0','20170927','20170927','20170927','11:48:58','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4396' AND YQJCRQ='20170927')

387     11:48:58  SQL Data In: ORACLE - Rows affected = 0
388     11:48:58  SQL Execute: ORACLE - commit

389     11:48:58  SQL Data In: ORACLE - Rows affected = 0
390     11:48:58  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

391     11:48:58  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

392     11:48:58  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'007'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'007'||'|',1,1) >0  AND A.YQDH00='AU' 

393     11:48:58  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'007'||'|',1,1) >0  AND YQDH00='AU'

394     11:48:58  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

395     11:48:58  SQL Data In: ORACLE - Rows affected = 0
396     11:48:58  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '17.7', JYJG00 = '17.7', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:58', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4393' AND YQDH00 = 'AU'

397     11:48:58  SQL Data In: ORACLE - Rows affected = 1
398     11:48:58  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4393','AU','17.7','17.7','','','0','0','20170927','20170927','20170927','11:48:58','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4393' AND YQJCRQ='20170927')

399     11:48:58  SQL Data In: ORACLE - Rows affected = 0
400     11:48:58  SQL Execute: ORACLE - commit

401     11:48:58  SQL Data In: ORACLE - Rows affected = 0
402     11:48:58  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

403     11:48:58  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

404     11:48:58  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'012'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'012'||'|',1,1) >0  AND A.YQDH00='AU' 

405     11:48:58  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'012'||'|',1,1) >0  AND YQDH00='AU'

406     11:48:58  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

407     11:48:58  SQL Data In: ORACLE - Rows affected = 0
408     11:48:58  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '6.67', JYJG00 = '6.67', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:58', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4401' AND YQDH00 = 'AU'

409     11:48:58  SQL Data In: ORACLE - Rows affected = 1
410     11:48:58  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4401','AU','6.67','6.67','','','0','0','20170927','20170927','20170927','11:48:58','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4401' AND YQJCRQ='20170927')

411     11:48:58  SQL Data In: ORACLE - Rows affected = 0
412     11:48:58  SQL Execute: ORACLE - commit

413     11:48:58  SQL Data In: ORACLE - Rows affected = 0
414     11:48:58  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

415     11:48:58  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

416     11:48:58  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'016'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'016'||'|',1,1) >0  AND A.YQDH00='AU' 

417     11:48:58  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'016'||'|',1,1) >0  AND YQDH00='AU'

418     11:48:58  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

419     11:48:58  SQL Data In: ORACLE - Rows affected = 0
420     11:48:58  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '2.14', JYJG00 = '2.14', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:58', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4416' AND YQDH00 = 'AU'

421     11:48:58  SQL Data In: ORACLE - Rows affected = 1
422     11:48:58  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4416','AU','2.14','2.14','','','0','0','20170927','20170927','20170927','11:48:58','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4416' AND YQJCRQ='20170927')

423     11:48:58  SQL Data In: ORACLE - Rows affected = 0
424     11:48:58  SQL Execute: ORACLE - commit

425     11:48:58  SQL Data In: ORACLE - Rows affected = 0
426     11:48:58  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

427     11:48:58  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

428     11:48:58  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'020'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'020'||'|',1,1) >0  AND A.YQDH00='AU' 

429     11:48:58  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'020'||'|',1,1) >0  AND YQDH00='AU'

430     11:48:58  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

431     11:48:58  SQL Data In: ORACLE - Rows affected = 0
432     11:48:58  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '1.64', JYJG00 = '1.64', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:58', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4418' AND YQDH00 = 'AU'

433     11:48:59  SQL Data In: ORACLE - Rows affected = 1
434     11:48:59  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4418','AU','1.64','1.64','','','0','0','20170927','20170927','20170927','11:48:58','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4418' AND YQJCRQ='20170927')

435     11:48:59  SQL Data In: ORACLE - Rows affected = 0
436     11:48:59  SQL Execute: ORACLE - commit

437     11:48:59  SQL Data In: ORACLE - Rows affected = 0
438     11:48:59  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

439     11:48:59  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

440     11:48:59  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'033'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'033'||'|',1,1) >0  AND A.YQDH00='AU' 

441     11:48:59  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'033'||'|',1,1) >0  AND YQDH00='AU'

442     11:48:59  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

443     11:48:59  SQL Data In: ORACLE - Rows affected = 0
444     11:48:59  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '91.2', JYJG00 = '91.2', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:48:58', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4457' AND YQDH00 = 'AU'

445     11:48:59  SQL Data In: ORACLE - Rows affected = 1
446     11:48:59  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4457','AU','91.2','91.2','','','0','0','20170927','20170927','20170927','11:48:58','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4457' AND YQJCRQ='20170927')

447     11:48:59  SQL Data In: ORACLE - Rows affected = 0
448     11:48:59  SQL Execute: ORACLE - commit

449     11:48:59  SQL Data In: ORACLE - Rows affected = 0
450     11:48:59  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

451     11:48:59  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

452     11:48:59  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'001'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'001'||'|',1,1) >0  AND A.YQDH00='AU' 

453     11:48:59  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'001'||'|',1,1) >0  AND YQDH00='AU'

454     11:48:59  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

455     11:48:59  SQL Data In: ORACLE - Rows affected = 0
456     11:48:59  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '126.8', JYJG00 = '126.8', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:00', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4395' AND YQDH00 = 'AU'

457     11:49:00  SQL Data In: ORACLE - Rows affected = 1
458     11:49:00  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4395','AU','126.8','126.8','','','0','0','20170927','20170927','20170927','11:49:00','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4395' AND YQJCRQ='20170927')

459     11:49:00  SQL Data In: ORACLE - Rows affected = 0
460     11:49:00  SQL Execute: ORACLE - commit

461     11:49:00  SQL Data In: ORACLE - Rows affected = 0
462     11:49:00  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

463     11:49:00  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

464     11:49:00  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'010'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'010'||'|',1,1) >0  AND A.YQDH00='AU' 

465     11:49:00  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'010'||'|',1,1) >0  AND YQDH00='AU'

466     11:49:00  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

467     11:49:00  SQL Data In: ORACLE - Rows affected = 0
468     11:49:00  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '45.0', JYJG00 = '45.0', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:00', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4389' AND YQDH00 = 'AU'

469     11:49:00  SQL Data In: ORACLE - Rows affected = 1
470     11:49:00  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4389','AU','45.0','45.0','','','0','0','20170927','20170927','20170927','11:49:00','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4389' AND YQJCRQ='20170927')

471     11:49:00  SQL Data In: ORACLE - Rows affected = 0
472     11:49:00  SQL Execute: ORACLE - commit

473     11:49:00  SQL Data In: ORACLE - Rows affected = 0
474     11:49:00  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

475     11:49:00  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

476     11:49:00  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'014'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'014'||'|',1,1) >0  AND A.YQDH00='AU' 

477     11:49:00  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'014'||'|',1,1) >0  AND YQDH00='AU'

478     11:49:00  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

479     11:49:00  SQL Data In: ORACLE - Rows affected = 0
480     11:49:00  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '12.57', JYJG00 = '12.57', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:00', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4405' AND YQDH00 = 'AU'

481     11:49:00  SQL Data In: ORACLE - Rows affected = 1
482     11:49:00  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4405','AU','12.57','12.57','','','0','0','20170927','20170927','20170927','11:49:00','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4405' AND YQJCRQ='20170927')

483     11:49:00  SQL Data In: ORACLE - Rows affected = 0
484     11:49:00  SQL Execute: ORACLE - commit

485     11:49:00  SQL Data In: ORACLE - Rows affected = 0
486     11:49:00  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

487     11:49:00  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

488     11:49:00  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'018'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'018'||'|',1,1) >0  AND A.YQDH00='AU' 

489     11:49:00  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'018'||'|',1,1) >0  AND YQDH00='AU'

490     11:49:00  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

491     11:49:00  SQL Data In: ORACLE - Rows affected = 0
492     11:49:00  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '1.67', JYJG00 = '1.67', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:00', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4432' AND YQDH00 = 'AU'

493     11:49:01  SQL Data In: ORACLE - Rows affected = 1
494     11:49:01  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4432','AU','1.67','1.67','','','0','0','20170927','20170927','20170927','11:49:00','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4432' AND YQJCRQ='20170927')

495     11:49:01  SQL Data In: ORACLE - Rows affected = 0
496     11:49:01  SQL Execute: ORACLE - commit

497     11:49:01  SQL Data In: ORACLE - Rows affected = 0
498     11:49:01  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

499     11:49:01  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

500     11:49:01  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'026'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'026'||'|',1,1) >0  AND A.YQDH00='AU' 

501     11:49:01  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'026'||'|',1,1) >0  AND YQDH00='AU'

502     11:49:01  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

503     11:49:01  SQL Data In: ORACLE - Rows affected = 0
504     11:49:01  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '386.2', JYJG00 = '386.2', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:00', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4410' AND YQDH00 = 'AU'

505     11:49:01  SQL Data In: ORACLE - Rows affected = 1
506     11:49:01  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4410','AU','386.2','386.2','','','0','0','20170927','20170927','20170927','11:49:00','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4410' AND YQJCRQ='20170927')

507     11:49:01  SQL Data In: ORACLE - Rows affected = 0
508     11:49:01  SQL Execute: ORACLE - commit

509     11:49:01  SQL Data In: ORACLE - Rows affected = 0
510     11:49:02  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

511     11:49:02  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

512     11:49:02  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'002'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'002'||'|',1,1) >0  AND A.YQDH00='AU' 

513     11:49:02  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'002'||'|',1,1) >0  AND YQDH00='AU'

514     11:49:02  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

515     11:49:02  SQL Data In: ORACLE - Rows affected = 0
516     11:49:02  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '132.8', JYJG00 = '132.8', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:02', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4396' AND YQDH00 = 'AU'

517     11:49:02  SQL Data In: ORACLE - Rows affected = 1
518     11:49:02  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4396','AU','132.8','132.8','','','0','0','20170927','20170927','20170927','11:49:02','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4396' AND YQJCRQ='20170927')

519     11:49:02  SQL Data In: ORACLE - Rows affected = 0
520     11:49:02  SQL Execute: ORACLE - commit

521     11:49:02  SQL Data In: ORACLE - Rows affected = 0
522     11:49:02  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

523     11:49:02  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

524     11:49:02  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'007'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'007'||'|',1,1) >0  AND A.YQDH00='AU' 

525     11:49:02  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'007'||'|',1,1) >0  AND YQDH00='AU'

526     11:49:02  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

527     11:49:02  SQL Data In: ORACLE - Rows affected = 0
528     11:49:02  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '81.6', JYJG00 = '81.6', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:02', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4393' AND YQDH00 = 'AU'

529     11:49:02  SQL Data In: ORACLE - Rows affected = 1
530     11:49:02  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4393','AU','81.6','81.6','','','0','0','20170927','20170927','20170927','11:49:02','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4393' AND YQJCRQ='20170927')

531     11:49:02  SQL Data In: ORACLE - Rows affected = 0
532     11:49:02  SQL Execute: ORACLE - commit

533     11:49:02  SQL Data In: ORACLE - Rows affected = 0
534     11:49:02  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

535     11:49:02  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

536     11:49:02  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'012'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'012'||'|',1,1) >0  AND A.YQDH00='AU' 

537     11:49:02  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'012'||'|',1,1) >0  AND YQDH00='AU'

538     11:49:02  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

539     11:49:02  SQL Data In: ORACLE - Rows affected = 0
540     11:49:02  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '29.23', JYJG00 = '29.23', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:02', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4401' AND YQDH00 = 'AU'

541     11:49:02  SQL Data In: ORACLE - Rows affected = 1
542     11:49:02  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4401','AU','29.23','29.23','','','0','0','20170927','20170927','20170927','11:49:02','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4401' AND YQJCRQ='20170927')

543     11:49:02  SQL Data In: ORACLE - Rows affected = 0
544     11:49:02  SQL Execute: ORACLE - commit

545     11:49:02  SQL Data In: ORACLE - Rows affected = 0
546     11:49:02  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

547     11:49:02  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

548     11:49:02  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'016'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'016'||'|',1,1) >0  AND A.YQDH00='AU' 

549     11:49:02  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'016'||'|',1,1) >0  AND YQDH00='AU'

550     11:49:02  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

551     11:49:02  SQL Data In: ORACLE - Rows affected = 0
552     11:49:02  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '2.90', JYJG00 = '2.90', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:02', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4416' AND YQDH00 = 'AU'

553     11:49:03  SQL Data In: ORACLE - Rows affected = 1
554     11:49:03  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4416','AU','2.90','2.90','','','0','0','20170927','20170927','20170927','11:49:02','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4416' AND YQJCRQ='20170927')

555     11:49:03  SQL Data In: ORACLE - Rows affected = 0
556     11:49:03  SQL Execute: ORACLE - commit

557     11:49:03  SQL Data In: ORACLE - Rows affected = 0
558     11:49:03  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

559     11:49:03  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

560     11:49:03  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'020'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'020'||'|',1,1) >0  AND A.YQDH00='AU' 

561     11:49:03  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'020'||'|',1,1) >0  AND YQDH00='AU'

562     11:49:03  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

563     11:49:03  SQL Data In: ORACLE - Rows affected = 0
564     11:49:03  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '3.48', JYJG00 = '3.48', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:02', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4418' AND YQDH00 = 'AU'

565     11:49:03  SQL Data In: ORACLE - Rows affected = 1
566     11:49:03  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4418','AU','3.48','3.48','','','0','0','20170927','20170927','20170927','11:49:02','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4418' AND YQJCRQ='20170927')

567     11:49:03  SQL Data In: ORACLE - Rows affected = 0
568     11:49:03  SQL Execute: ORACLE - commit

569     11:49:03  SQL Data In: ORACLE - Rows affected = 0
570     11:49:03  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

571     11:49:03  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

572     11:49:03  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'033'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'033'||'|',1,1) >0  AND A.YQDH00='AU' 

573     11:49:03  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'033'||'|',1,1) >0  AND YQDH00='AU'

574     11:49:03  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

575     11:49:03  SQL Data In: ORACLE - Rows affected = 0
576     11:49:03  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '254.5', JYJG00 = '254.5', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:02', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4457' AND YQDH00 = 'AU'

577     11:49:03  SQL Data In: ORACLE - Rows affected = 1
578     11:49:03  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4457','AU','254.5','254.5','','','0','0','20170927','20170927','20170927','11:49:02','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4457' AND YQJCRQ='20170927')

579     11:49:03  SQL Data In: ORACLE - Rows affected = 0
580     11:49:03  SQL Execute: ORACLE - commit

581     11:49:03  SQL Data In: ORACLE - Rows affected = 0
582     11:49:04  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

583     11:49:04  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

584     11:49:04  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'013'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'013'||'|',1,1) >0  AND A.YQDH00='AU' 

585     11:49:04  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'013'||'|',1,1) >0  AND YQDH00='AU'

586     11:49:04  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

587     11:49:04  SQL Data In: ORACLE - Rows affected = 0
588     11:49:04  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '113', JYJG00 = '113', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:04', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4402' AND YQDH00 = 'AU'

589     11:49:04  SQL Data In: ORACLE - Rows affected = 1
590     11:49:04  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4402','AU','113','113','','','0','0','20170927','20170927','20170927','11:49:04','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4402' AND YQJCRQ='20170927')

591     11:49:04  SQL Data In: ORACLE - Rows affected = 0
592     11:49:04  SQL Execute: ORACLE - commit

593     11:49:04  SQL Data In: ORACLE - Rows affected = 0
594     11:49:06  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

595     11:49:06  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

596     11:49:06  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'013'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'013'||'|',1,1) >0  AND A.YQDH00='AU' 

597     11:49:06  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'013'||'|',1,1) >0  AND YQDH00='AU'

598     11:49:06  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

599     11:49:06  SQL Data In: ORACLE - Rows affected = 0
600     11:49:06  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '400', JYJG00 = '400', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:06', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4402' AND YQDH00 = 'AU'

601     11:49:06  SQL Data In: ORACLE - Rows affected = 1
602     11:49:06  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4402','AU','400','400','','','0','0','20170927','20170927','20170927','11:49:06','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4402' AND YQJCRQ='20170927')

603     11:49:06  SQL Data In: ORACLE - Rows affected = 0
604     11:49:06  SQL Execute: ORACLE - commit

605     11:49:06  SQL Data In: ORACLE - Rows affected = 0
606     11:49:08  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

607     11:49:08  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

608     11:49:08  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'018'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'018'||'|',1,1) >0  AND A.YQDH00='AU' 

609     11:49:08  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'018'||'|',1,1) >0  AND YQDH00='AU'

610     11:49:08  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

611     11:49:08  SQL Data In: ORACLE - Rows affected = 0
612     11:49:08  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '1.01', JYJG00 = '1.01', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:08', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4432' AND YQDH00 = 'AU'

613     11:49:08  SQL Data In: ORACLE - Rows affected = 1
614     11:49:08  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4432','AU','1.01','1.01','','','0','0','20170927','20170927','20170927','11:49:08','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4432' AND YQJCRQ='20170927')

615     11:49:08  SQL Data In: ORACLE - Rows affected = 0
616     11:49:08  SQL Execute: ORACLE - commit

617     11:49:08  SQL Data In: ORACLE - Rows affected = 0
618     11:49:10  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

619     11:49:10  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9999' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

620     11:49:10  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'033'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'033'||'|',1,1) >0  AND A.YQDH00='AU' 

621     11:49:10  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'033'||'|',1,1) >0  AND YQDH00='AU'

622     11:49:10  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

623     11:49:10  SQL Data In: ORACLE - Rows affected = 0
624     11:49:10  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '87.4', JYJG00 = '87.4', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:10', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9999' AND PYRQ00 = '20170927' AND BGXMID = '4457' AND YQDH00 = 'AU'

625     11:49:10  SQL Data In: ORACLE - Rows affected = 1
626     11:49:10  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9999','0','4457','AU','87.4','87.4','','','0','0','20170927','20170927','20170927','11:49:10','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9999' AND BGXMID='4457' AND YQJCRQ='20170927')

627     11:49:10  SQL Data In: ORACLE - Rows affected = 0
628     11:49:10  SQL Execute: ORACLE - commit

629     11:49:10  SQL Data In: ORACLE - Rows affected = 0
630     11:49:12  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

631     11:49:12  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

632     11:49:12  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'018'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'018'||'|',1,1) >0  AND A.YQDH00='AU' 

633     11:49:12  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'018'||'|',1,1) >0  AND YQDH00='AU'

634     11:49:12  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

635     11:49:12  SQL Data In: ORACLE - Rows affected = 0
636     11:49:12  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '1.70', JYJG00 = '1.70', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:12', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4432' AND YQDH00 = 'AU'

637     11:49:12  SQL Data In: ORACLE - Rows affected = 1
638     11:49:12  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4432','AU','1.70','1.70','','','0','0','20170927','20170927','20170927','11:49:12','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4432' AND YQJCRQ='20170927')

639     11:49:12  SQL Data In: ORACLE - Rows affected = 0
640     11:49:12  SQL Execute: ORACLE - commit

641     11:49:12  SQL Data In: ORACLE - Rows affected = 0
642     11:49:14  SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00 in ('JY_JLYQYSSJ') 

643     11:49:14  SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE YBH000='AU9998' AND PYRQ00='20170927' and yqdh00='AU' AND JGZT00 IN ('6','8','9')

644     11:49:14  SQL Execute: ORACLE - SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID IN (SELECT JYYWID FROM JY_YW0000 WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927') AND instr('|'||YQXMDM||'|','|'||'033'||'|',1,1) >0 AND YQDH00='AU' and rownum=1 UNION SELECT A.BGXMID FROM JY_JYJG00_TEMP A,JY_BGXMZD B WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND A.BGXMID=B.BGXMID AND instr('|'||B.YQXMDM||'|','|'||'033'||'|',1,1) >0  AND A.YQDH00='AU' 

645     11:49:14  SQL Execute: ORACLE - SELECT JGJZYZ FROM JY_BGXMZD WHERE sybz00='Y'  and  instr('|'||YQXMDM||'|','|'||'033'||'|',1,1) >0  AND YQDH00='AU'

646     11:49:14  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = NULL , JYJG00 = NULL , OD0000 = NULL  WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND YQDH00 = 'AU' AND BGXMID in  (select bgxmid from jy_bgxmzd where YQDH00 = 'AU' and JGLX00='C' ) 

647     11:49:14  SQL Data In: ORACLE - Rows affected = 0
648     11:49:14  SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP  SET YSJYJG = '245.0', JYJG00 = '245.0', OD0000 = '', JGDW00 = '', BGRQ00 = '20170927', YQJCRQ = '20170927', BGSJ00 = '11:49:14', SECTOR = '0', CUPNUM = '0' WHERE YBH000 = 'AU9998' AND PYRQ00 = '20170927' AND BGXMID = '4457' AND YQDH00 = 'AU'

649     11:49:14  SQL Data In: ORACLE - Rows affected = 1
650     11:49:14  SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(YBH000,JYYWID,BGXMID,YQDH00,YSJYJG,JYJG00,OD0000,JGDW00, SECTOR,CUPNUM,PYRQ00,BGRQ00,YQJCRQ,BGSJ00,FSBZ00) SELECT 'AU9998','0','4457','AU','245.0','245.0','','','0','0','20170927','20170927','20170927','11:49:14','Y' FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM JY_JYJG00_TEMP WHERE YBH000='AU9998' AND BGXMID='4457' AND YQJCRQ='20170927')

651     11:49:14  SQL Data In: ORACLE - Rows affected = 0
652     11:49:14  SQL Execute: ORACLE - commit

653     11:49:14  SQL Data In: ORACLE - Rows affected = 0
654     11:49:44  SQL Execute: ORACLE - select * from dual