/* Formatted on 12-4ÔÂ-2024 19:39:02 (QP5 v5.206) */
  SELECT c.zyh000,
         c.brxm00,
         c.xb0000,
         c.ch0000,
         (SELECT SUBSTRB (sf_bq_csrqtonl (c.csrq00), 1, 100) FROM DUAL) brnl00,
         COUNT (c.cflsh0) cfsl00
    FROM yf_zycf00 c, bm_ygbm00 g
   WHERE     c.czy000 = g.ygbh00
         AND ( (c.sfksly = '-1') OR ('-1' = '-1'))
         AND c.srrq00 >= '20240409'
         AND c.srrq00 <= '20240412'
         AND c.dqbq00 = '549'
         AND c.yfbmbh = 203
         AND (   (c.cfzt00 IN ('0') AND c.bccfh0 IS NULL)
              OR (    c.cfzt00 IN ('1')
                  AND c.bccfh0 IS NULL
                  AND NOT EXISTS
                              (SELECT 1
                                 FROM yf_zycf00 d
                                WHERE     c.cflsh0 = d.bccfh0
                                      AND c.zyid00 = d.zyid00
                                      AND cfzt00 IN ('0', '1'))))
         AND c.cfxz00 = '0'
         AND EXISTS
                 (SELECT 1
                    FROM yf_zycfmx a, bq_ypyz00 b, bq_ypyzmx e
                   WHERE     a.cflsh0 = c.cflsh0
                         AND a.yzid00 = b.yzid00
                         AND b.yzid00 = e.yzid00
                         AND a.yzmxid = e.yzmxid
                         AND b.yzly00 = '1'
                         AND e.yzcllb = '³öÔº´øÒ©')
GROUP BY c.zyh000,
         c.brxm00,
         c.xb0000,
         c.ch0000,
         c.csrq00
ORDER BY c.zyh000,
         c.brxm00,
         c.xb0000,
         c.ch0000,
         c.csrq00