/* Formatted on 2011/05/05 11:13 (Formatter Plus v4.8.7) */
SELECT yjdjh0, zlxmid, txm000, zyhghh, mzzybz,
       (SELECT zlxmjc
          FROM bm_zlzd00
         WHERE zlxmid = a.zlxmid) zlxmjc,                          -- 项目名称
                                         (SELECT sjid00
                                            FROM jy_qdpz00
                                           WHERE zlxmid = a.zlxmid) sjid00,
       (SELECT ddid00
          FROM jy_qdpz00
         WHERE zlxmid = a.zlxmid) ddid00,
       sf_jy_get_qdsj00 (a.jyywid, a.zlxmid) qdsj00,
       (SELECT ddmc00
          FROM jy_qdpz00 b, jy_qddd00 c
         WHERE b.zlxmid = a.zlxmid AND b.ddid00 = c.ddid00) ddmc00,
       (SELECT qzmc00
          FROM jy_qdxhqz
         WHERE cjxq00 =
                  (SELECT TO_CHAR (TO_DATE (b.bbcyrq, 'yyyymmdd'),
                                   'day'
                                  )
                     FROM jy_yw0000 b
                    WHERE b.yjdjh0 = a.yjdjh0 AND ROWNUM = 1)) qzmc00
                                                                    --取单前缀
  FROM jy_yw0000 a
 WHERE mzzybz = '0' AND jgzt00 = '1'