CURSOR CUR_ZY_FYMX00_JZ0000_FPXM IS --记帐明细(发票项目)
         select E.BH0000,sum(A.HJJE00) HJJE00,c.ZYID00 KDBQ00,a.kdbq00
              from ZY_FYMX00 A,ZY_BRFY00 C,BM_YYSFXM D,BM_FPXM00 E--,BQ_BRLDXX F
               where  A.DJH000=C.DJH000
                 AND  A.XMBH00=D.SFXMID
                 AND  D.ZYFPID=E.FPXMID
                 AND  C.CZRQ00>=as_KSRQ00
                 AND  C.CZRQ00<=as_JSRQ00
                 AND  C.CZRQ00||C.CZSJ00>=as_KSRQ00||as_KSSJ00
                 AND  C.CZRQ00||C.CZSJ00<=as_JSRQ00||as_JSSJ00
                 and c.zyid00 in (select ZYID00 from bq_brldxx f where (F.QSZT00='转入' or F.JSZT00='转出' ) and f.yxbz00='1' group by ZYID00)
             --    AND (F.QSZT00='转入' or F.JSZT00='转出')
             --    AND F.QSRQ00>=as_KSRQ00
             --    AND F.QSRQ00<=as_JSRQ00
               --  AND F.ZYID00=C.ZYID00
               --  and F.BQH000=A.KDBQ00
               
          group by c.ZYID00,a.kdbq00,E.BH0000  having  sum(A.HJJE00)<>0  ORDER BY E.BH0000 ;