补发log.txt.bak

行业应急系统 包括: 应急系统（待遇核发） 发放系统 开发环境:Delphi5 (sp1)+ Oracle 8.05 MultiExport是一个可以将数据按指定字段倒出

       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 = '1000000005' or d.ffjgid = '1000000009') and
      d.ffyf = to_date('2000.11','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

18      17:47:23  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 人员标识,'200012' 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.12','yyyy.mm') and
      d.ffjgid = '1000000001' and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by b.dm, a.ssdwid, a.ryid_ff

19      17:47:23  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.12' 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.12','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

20      17:47:23  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 人员标识,'200012' 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.12','yyyy.mm') and
      d.ffjgid = '1000000002' and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by b.dm, a.ssdwid, a.ryid_ff

21      17:47:23  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.12' 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.12','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

22      17:47:23  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 人员标识,'200012' 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.12','yyyy.mm') and
      d.ffjgid = '1000000003' and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by b.dm, a.ssdwid, a.ryid_ff

23      17:47:24  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.12' 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.12','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

24      17:47:24  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 人员标识,'200012' 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.12','yyyy.mm') and
      d.ffjgid = '1000000004' and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by b.dm, a.ssdwid, a.ryid_ff

25      17:47:24  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.12' 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.12','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

26      17:47:24  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.12' 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.12','yyyy.mm') and
      d.ffjgid = '1000000006' and
      (a.ffjgid = '1000000006' or a.ffjgid = '1000000007')
order by b.dm, a.ssdwid, a.ryid_ff

27      17:47:24  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.12' 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.12' and
      a.ffjgid <> '1000000006' or a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

28      17:47:24  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.12' 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.12','yyyy.mm') and
      d.ffjgid = '1000000007' and
      (a.ffjgid = '1000000006' or a.ffjgid = '1000000007')
order by b.dm, a.ssdwid, a.ryid_ff

29      17:47:24  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.12' 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.12','yyyy.mm') and
      a.ffjgid <> '1000000006' or a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff

30      17:47:24  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 人员标识,'200012' 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.12','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

31      17:47:24  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.12' 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 = '1000000005' or d.ffjgid = '1000000009') and
      d.ffyf = to_date('2000.12','yyyy.mm') and
      a.ffjgid <> '1000000006' and a.ffjgid <> '1000000007'
order by d.dwdm, d.dwid_ff