补发log.txt.bak

来自「行业应急系统 包括: 应急系统（待遇核发） 发放系统 开」· BAK 代码 · 共 466 行 · 第 1/2 页

工商无组

4       17:46:49  SQL Execute: ORACLE - select a.xm as 姓名, a.sfzh as 身份证号,       
       a.zh as 帐号, a.khh as 开户行,          
       a.hrdd as 汇入地点, a.ffje as 发放金额, 
       b.dm as 地区代码, b.mc as 地区名称,     
       c.dwdm as 单位代码, c.dwmc as 单位名称, 
       a.ryid_ff as 人员标识,'200011' as 所属月份 
from tff_ryxx a, tff_rydqxx b, tff_dwxx c, tff_ryfkxx d
where b.ryid_ff (+)= a.ryid_ff and
      a.dwid_ff = a.ssdwid and
      d.ffbz=1 and
      a.ssdwid = c.dwid_ff and
      d.ryid_ff = a.ryid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and 
      d.ffyf = to_date('2000.11','yyyy.mm') and
      d.ffjgid = '1000000001' and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by b.dm, a.ssdwid, a.ryid_ff

工商有组

5       17:46:49  SQL Execute: ORACLE - select a.dwjbr as 姓名, a.zh as 帐号,
       a.khmc as 开户行, a.dwdz as 汇入地点,
       d.ffje as 发放金额, d.dwdm as 单位代码,
       a.dwmc as 单位名称, d.dwid_ff as 组标识,
       d.zrs as 人数,'2000.11' as 所属月份
from tff_dwxx a, tff_zfkxx d
where a.dwid_ff = d.dwid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffjgid = '1000000001' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

农行无组

6       17:46:49  SQL Execute: ORACLE - select a.xm as 姓名, a.sfzh as 身份证号,       
       a.zh as 帐号, a.khh as 开户行,          
       a.hrdd as 汇入地点, a.ffje as 发放金额, 
       b.dm as 地区代码, b.mc as 地区名称,     
       c.dwdm as 单位代码, c.dwmc as 单位名称, 
       a.ryid_ff as 人员标识,'200011' as 所属月份 
from tff_ryxx a, tff_rydqxx b, tff_dwxx c, tff_ryfkxx d
where b.ryid_ff (+)= a.ryid_ff and
      d.ffbz=1 and
      a.dwid_ff = a.ssdwid and
      a.ssdwid = c.dwid_ff and
      d.ryid_ff = a.ryid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      d.ffjgid = '1000000002' and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by b.dm, a.ssdwid, a.ryid_ff

农行有组

7       17:46:50  SQL Execute: ORACLE - select a.dwjbr as 姓名, a.zh as 帐号,
       a.khmc as 开户行, a.dwdz as 汇入地点,
       d.ffje as 发放金额, d.dwdm as 单位代码,
       a.dwmc as 单位名称, d.dwid_ff as 组标识,
       d.zrs as 人数,'2000.11' as 所属月份
from tff_dwxx a, tff_zfkxx d
where a.dwid_ff = d.dwid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffjgid = '1000000002' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

中行无组

8       17:46:50  SQL Execute: ORACLE - select a.xm as 姓名, a.sfzh as 身份证号,       
       a.zh as 帐号, a.khh as 开户行,          
       a.hrdd as 汇入地点, a.ffje as 发放金额, 
       b.dm as 地区代码, b.mc as 地区名称,     
       c.dwdm as 单位代码, c.dwmc as 单位名称, 
       a.ryid_ff as 人员标识,'200011' as 所属月份 
from tff_ryxx a, tff_rydqxx b, tff_dwxx c, tff_ryfkxx d
where b.ryid_ff (+)= a.ryid_ff and
      d.ffbz=1 and
      a.dwid_ff = a.ssdwid and
      a.ssdwid = c.dwid_ff and
      d.ryid_ff = a.ryid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      d.ffjgid = '1000000003' and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by b.dm, a.ssdwid, a.ryid_ff

中行有组

9       17:46:50  SQL Execute: ORACLE - select a.dwjbr as 姓名, a.zh as 帐号,
       a.khmc as 开户行, a.dwdz as 汇入地点,
       d.ffje as 发放金额, d.dwdm as 单位代码,
       a.dwmc as 单位名称, d.dwid_ff as 组标识,
       d.zrs as 人数,'2000.11' as 所属月份
from tff_dwxx a, tff_zfkxx d
where a.dwid_ff = d.dwid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffjgid = '1000000003' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

建设无组

10      17:46:50  SQL Execute: ORACLE - select a.xm as 姓名, a.sfzh as 身份证号,       
       a.zh as 帐号, a.khh as 开户行,          
       a.hrdd as 汇入地点, a.ffje as 发放金额, 
       b.dm as 地区代码, b.mc as 地区名称,     
       c.dwdm as 单位代码, c.dwmc as 单位名称, 
       a.ryid_ff as 人员标识,'200011' as 所属月份 
from tff_ryxx a, tff_rydqxx b, tff_dwxx c, tff_ryfkxx d
where b.ryid_ff (+)= a.ryid_ff and
      d.ffbz=1 and
      a.dwid_ff = a.ssdwid and
      a.ssdwid = c.dwid_ff and
      d.ryid_ff = a.ryid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      d.ffjgid = '1000000004' and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by b.dm, a.ssdwid, a.ryid_ff

建行有组

11      17:46:50  SQL Execute: ORACLE - select a.dwjbr as 姓名, a.zh as 帐号,
       a.khmc as 开户行, a.dwdz as 汇入地点,
       d.ffje as 发放金额, d.dwdm as 单位代码,
       a.dwmc as 单位名称, d.dwid_ff as 组标识,
       d.zrs as 人数,'2000.11' as 所属月份
from tff_dwxx a, tff_zfkxx d
where a.dwid_ff = d.dwid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffjgid = '1000000004' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

邮储无组

12      17:46:50  SQL Execute: ORACLE - select a.xm as 姓名, a.sfzh as 身份证号,
       a.zh as 账号, a.khh as 开户行,
       a.hrdd as 汇入地点, a.ffje as 发放金额,
       a.yzbm as 邮政编码, a.dz as 地址,
       b.dm as 地区代码, b.mc as 地区名称,
       c.dwdm as 单位代码, c.dwmc as 单位名称,
       a.ryid_ff as 人员标识,'2000.11' as 所属月份
from tff_ryxx a, tff_rydqxx b, tff_dwxx c, tff_ryfkxx d
where b.ryid_ff (+)= a.ryid_ff and
      d.ffbz=1 and
      a.dwid_ff = a.ssdwid and
      a.ssdwid = c.dwid_ff and
      d.ryid_ff = a.ryid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      d.ffjgid = '1000000006' and
      (a.ffjgid = '1000000006' or a.ffjgid = '1000000007')
order by b.dm, a.ssdwid, a.ryid_ff

邮储有组

13      17:46:51  SQL Execute: ORACLE - select a.dwjbr as 姓名, a.zh as 帐号,
       a.khmc as 开户行, a.dwdz as 汇入地点,
       d.ffje as 发放金额, d.dwdm as 单位代码,
       a.yzbm as 邮政编码, a.dwdz as 地址,
       a.dwmc as 单位名称, d.dwid_ff as 组标识,
       d.zrs as 人数,'2000.11' as 所属月份
from tff_dwxx a, tff_zfkxx d
where a.dwid_ff = d.dwid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffjgid = '1000000006' and
      d.ffyf = '2000.11' and
      a.ffjgid <> '1000000006' or a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

邮汇无组
14      17:46:51  SQL Execute: ORACLE - select nvl(a.skr,a.xm) as 姓名, a.sfzh as 身份证号,
       a.zh as 账号, a.khh as 开户行,
       a.hrdd as 汇入地点, a.ffje as 发放金额,
       a.yzbm as 邮政编码, a.dz as 地址,
       b.dm as 地区代码, b.mc as 地区名称,
       c.dwdm as 单位代码, c.dwmc as 单位名称,
       a.ryid_ff as 人员标识,'2000.11' as 所属月份
from tff_ryxx a, tff_rydqxx b, tff_dwxx c, tff_ryfkxx d
where b.ryid_ff (+)= a.ryid_ff and
      d.ffbz=1 and
      a.dwid_ff = a.ssdwid and
      a.ssdwid = c.dwid_ff and
      d.ryid_ff = a.ryid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      d.ffjgid = '1000000007' and
      (a.ffjgid = '1000000006' or a.ffjgid = '1000000007')
order by b.dm, a.ssdwid, a.ryid_ff

邮汇有组
15      17:46:51  SQL Execute: ORACLE - select a.dwjbr as 姓名, a.zh as 帐号,
       a.khmc as 开户行, a.dwdz as 汇入地点,
       d.ffje as 发放金额, d.dwdm as 单位代码,
       a.yzbm as 邮政编码, a.dwdz as 地址,
       a.dwmc as 单位名称, d.dwid_ff as 组标识,
       d.zrs as 人数,'2000.11' as 所属月份
from tff_dwxx a, tff_zfkxx d
where a.dwid_ff = d.dwid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffjgid = '1000000007' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      a.ffjgid <> '1000000006' or a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

其他无组
16      17:46:51  SQL Execute: ORACLE - select a.xm as 姓名, a.sfzh as 身份证号,       
       a.zh as 帐号, a.khh as 开户行,          
       a.hrdd as 汇入地点, a.ffje as 发放金额, 
       b.dm as 地区代码, b.mc as 地区名称,     
       c.dwdm as 单位代码, c.dwmc as 单位名称, 
       a.ryid_ff as 人员标识,'200011' as 所属月份 
from tff_ryxx a, tff_rydqxx b, tff_dwxx c, tff_ryfkxx d
where b.ryid_ff (+)= a.ryid_ff and
      d.ffbz=1 and
      a.dwid_ff = a.ssdwid and
      a.ssdwid = c.dwid_ff and
      d.ryid_ff = a.ryid_ff and
      to_char(d.fkrq,'yyyy.mm')='2000.12' and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      (d.ffjgid = '1000000005' or d.ffjgid = '1000000009') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by b.dm, a.ssdwid, a.ryid_ff

17      17:46:51  SQL Execute: ORACLE - select a.dwjbr as 姓名, a.zh as 帐号,
       a.khmc as 开户行, a.dwdz as 汇入地点,