1       14:29:43  Log started for: 易家健康管理服务系统
2       14:30:38  SQL Prepare: ORACLE - delete from PE_TMP_JAXXB0

3       14:30:38  SQL Execute: ORACLE - delete from PE_TMP_JAXXB0

4       14:30:38  SQL Data In: ORACLE - Rows affected = 1750
5       14:30:38  SQL Prepare: ORACLE - Commit

6       14:30:38  SQL Execute: ORACLE - Commit

7       14:30:38  SQL Data In: ORACLE - Rows affected = 0
8       14:30:38  SQL Prepare: ORACLE - insert into PE_TMP_JAXXB0(TJH000,JCKSID,BMMC00,DJRQ00, XM0000, XBMC00,  NL0000, JABZ00, DH0000, TTMC00, TJLXMC, JASFCL, TTID00, RWID00,SFXMMC)  SELECT distinct a.tjh000, b.JCKSID, c.bmmc00, a.djrq00, a.XM0000, a.XBMC00, a.NL0000, a.JABZ00, a.DH0000, a.TTMC00,  case when A.LXID00 = 6 then LXMC00 when A.YBJGMC is not null then A.YBJGMC else a.TJLXMC end YGTJLX, a.JASFCL, a.TTID00, a.RWID00, SFXMMC  FROM vw_pe_tjz000 a, SY_PE_YWSJ_TJYW00 b, BM_BMBm00 c  WHERE a.tjh000 = b.tjh000 and b.jcksid = c.bmbh00 and a.zjrq00 = '20991231'  and a.djrq00||'A' <= '20140306A' AND a.djrq00||'A' >= '20110101A' and a.fjwc00 = '0'  AND a.ykstj0 <> '0' AND QJ0000 = '0' AND b.TFNTBZ = '0'  AND not EXISTS (SELECT 1 FROM sy_pe_ywsj_tjfkjc  WHERE tjh000 = a.tjh000 and KSSH00='1' and bmbh00=b.jcksid)  and exists (select 1 from SY_PE_YWSJ_TJYW00 where tjh000= A.tjh000 and fkksrq <=20140306  )  and not exists (select 1 from SY_PE_YWZD_TJSQXM where SQXMID = b.SQXMID and SFJCXM = '0')  AND (trim(nvl(A.YYID00, '0')) = '0' or A.YYID00 = '220006') and (B.SFSF00 = '1' or B.SFJZ00 in ('1', '2'))  ORDER BY djrq00 

9       14:30:38  SQL Execute: ORACLE - insert into PE_TMP_JAXXB0(TJH000,JCKSID,BMMC00,DJRQ00, XM0000, XBMC00,  NL0000, JABZ00, DH0000, TTMC00, TJLXMC, JASFCL, TTID00, RWID00,SFXMMC)  SELECT distinct a.tjh000, b.JCKSID, c.bmmc00, a.djrq00, a.XM0000, a.XBMC00, a.NL0000, a.JABZ00, a.DH0000, a.TTMC00,  case when A.LXID00 = 6 then LXMC00 when A.YBJGMC is not null then A.YBJGMC else a.TJLXMC end YGTJLX, a.JASFCL, a.TTID00, a.RWID00, SFXMMC  FROM vw_pe_tjz000 a, SY_PE_YWSJ_TJYW00 b, BM_BMBm00 c  WHERE a.tjh000 = b.tjh000 and b.jcksid = c.bmbh00 and a.zjrq00 = '20991231'  and a.djrq00||'A' <= '20140306A' AND a.djrq00||'A' >= '20110101A' and a.fjwc00 = '0'  AND a.ykstj0 <> '0' AND QJ0000 = '0' AND b.TFNTBZ = '0'  AND not EXISTS (SELECT 1 FROM sy_pe_ywsj_tjfkjc  WHERE tjh000 = a.tjh000 and KSSH00='1' and bmbh00=b.jcksid)  and exists (select 1 from SY_PE_YWSJ_TJYW00 where tjh000= A.tjh000 and fkksrq <=20140306  )  and not exists (select 1 from SY_PE_YWZD_TJSQXM where SQXMID = b.SQXMID and SFJCXM = '0')  AND (trim(nvl(A.YYID00, '0')) = '0' or A.YYID00 = '220006') and (B.SFSF00 = '1' or B.SFJZ00 in ('1', '2'))  ORDER BY djrq00 

10      14:30:38  SQL Data In: ORACLE - Rows affected = 1750
11      14:30:38  SQL Prepare: ORACLE - insert into PE_TMP_JAXXB0(TJH000,JCKSID,BMMC00,DJRQ00, XM0000, XBMC00, NL0000, JABZ00, DH0000, TTMC00, TJLXMC, JASFCL, TTID00, RWID00,SFXMMC)  SELECT distinct a.tjh000, '00', '退项未退费', a.djrq00, a.XM0000, a.XBMC00,  a.NL0000, a.JABZ00, a.DH0000, a.TTMC00, decode(A.YBJGMC, null, a.TJLXMC, A.YBJGMC) YGTJLX, a.JASFCL, a.TTID00, a.RWID00, SFXMMC  FROM vw_pe_tjz000 a  WHERE a.zjrq00 = '20991231' and a.djrq00||'A' <= '20140306A'  and exists (select 1 from SY_PE_YWSJ_TJYW00 where tjh000= A.tjh000 and fkksrq <=20140306  )  AND a.djrq00||'A' >= '20110101A' and a.fjwc00 = '0'  AND sf_pe_getsfje (a.tjh000, 7) <> 0 and A.YKSTJ0 <> 0  AND (select count(1) from SY_PE_YWSJ_TJYW00 where TJH000 = A.TJH000 AND (SFSF00 <> '0' or SFJZ00 <> '0')) <> 0  and (trim(nvl(A.YYID00, '0')) = '0' or A.YYID00 = '220006') 

12      14:30:38  SQL Execute: ORACLE - insert into PE_TMP_JAXXB0(TJH000,JCKSID,BMMC00,DJRQ00, XM0000, XBMC00, NL0000, JABZ00, DH0000, TTMC00, TJLXMC, JASFCL, TTID00, RWID00,SFXMMC)  SELECT distinct a.tjh000, '00', '退项未退费', a.djrq00, a.XM0000, a.XBMC00,  a.NL0000, a.JABZ00, a.DH0000, a.TTMC00, decode(A.YBJGMC, null, a.TJLXMC, A.YBJGMC) YGTJLX, a.JASFCL, a.TTID00, a.RWID00, SFXMMC  FROM vw_pe_tjz000 a  WHERE a.zjrq00 = '20991231' and a.djrq00||'A' <= '20140306A'  and exists (select 1 from SY_PE_YWSJ_TJYW00 where tjh000= A.tjh000 and fkksrq <=20140306  )  AND a.djrq00||'A' >= '20110101A' and a.fjwc00 = '0'  AND sf_pe_getsfje (a.tjh000, 7) <> 0 and A.YKSTJ0 <> 0  AND (select count(1) from SY_PE_YWSJ_TJYW00 where TJH000 = A.TJH000 AND (SFSF00 <> '0' or SFJZ00 <> '0')) <> 0  and (trim(nvl(A.YYID00, '0')) = '0' or A.YYID00 = '220006') 

13      14:30:38  SQL Error: ORACLE - ORA-00904: "SFXMMC": 标识符无效

14      14:30:38  SQL Data In: ORACLE - Rows affected = 0