---原语句
select *
   from (select distinct ZYGHID ZYID00,
                        
                         BRXM00,
                         XB0000,
                         NL0000,
                         TXMMC0,
                         '补打' JBXX01,
                         to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') CYRQSJ,
                         BBMC00,
                         CH0000,
                         TXM000,
                         XMMC00,
                         YBTJ00,
                         YBSM00,
                         BRLB00,
                         BMMC00,
                         JZBZ00,
                         ZYHGHH,
                         '1' ROWNUM1,
                         nvl((select D.ZWXM00
                               from JY_YW0000 C, BM_YGBM00 D
                              where C.SQYS00 = D.YGBH00
                                and C.TXM000 = A.TXM000
                                and rownum = 1),
                             A.SQYSXM) SQYSXM,
                         A.XMMSMC
           from VW_JY_TXMCJD A
          where A.MZZYBZ = '1'
            and ((KDBQ00 = 2044) or (0 = 0))
            and KDRQ00 between '20210812' and '20210827'
            and ZYGHID in (879234)
            and (nvl(CJKSBH, KDBQ00) = 2044 or
                instr(',82294,82429,82298,', ',' || A.ZLXMID || ',') > 0)
            and nvl(TMDYRQ, '0') <> '0'
            and YJDJH0 in ('-1',
                           '59722095',
                           '59722094',
                           '59722096',
                           '59722092',
                           '59722103',
                           '59722090',
                           '59722102',
                           '59722097',
                           '59722098',
                           '59722099',
                           '59722092',
                           '59722089',
                           '59722101',
                           '59722100'))
  order by CH0000, ZYID00, TXM000;



---现场修改后语句
select *
   from (select distinct ZYGHID ZYID00,
                         yjdjh0 yjdjh0,
                         BRXM00,
                         XB0000,
                         NL0000,
                         TXMMC0,
                         '补打' JBXX01,
                         to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') CYRQSJ,
                         BBMC00,
                         CH0000,
                         TXM000,
                         XMMC00,
                         YBTJ00,
                         YBSM00,
                         BRLB00,
                         BMMC00,
                         JZBZ00,
                         ZYHGHH,
                         '1' ROWNUM1,
                         nvl((select D.ZWXM00
                               from JY_YW0000 C, BM_YGBM00 D
                              where C.SQYS00 = D.YGBH00
                                and C.TXM000 = A.TXM000
                                and rownum = 1),
                             A.SQYSXM) SQYSXM,
                         A.XMMSMC
           from VW_JY_TXMCJD A
          where A.MZZYBZ = '1'
            and ((KDBQ00 = 2044) or (0 = 0))
            and KDRQ00 between '20210812' and '20210827'
            and ZYGHID in (879234)
            and (nvl(CJKSBH, KDBQ00) = 2044 or
                instr(',82294,82429,82298,', ',' || A.ZLXMID || ',') > 0)
            and nvl(TMDYRQ, '0') <> '0'
            and YJDJH0 in ('-1',
                           '59722095',
                           '59722094',
                           '59722096',
                           '59722092',
                           '59722103',
                           '59722090',
                           '59722102',
                           '59722097',
                           '59722098',
                           '59722099',
                           '59722092',
                           '59722089',
                           '59722101',
                           '59722100'))
  order by CH0000, ZYID00, YJDJH0, TXM000;