20240617  11:16:16  select distinct 'N' XZ0000, A.ZLXMID, A.ZLXMJC, A.SFJE00,D.CKZ000,' ' JGSM00,D.JGDW00, (select zyzfbl*100||'%' zfbl00  from vw_bm_ybsfdy e,xt_zlsfgx f,vw_bm_zlzd00 g where e.sfxmid=f.sfxmid and  f.zlxmid=g.ZLXMID and g.ZLXMID=a.ZLXMID and e.YBZXLB='1' and e.YBBRLB='01' and e.FBBH00='3' and e.SFYP00='N' and  rownum=1) ZFBL00, 0 zxks00, '' zxksmc,decode(A.LBBH00, '3', B.KSXMID, 0) KSXMID,t.bmmc00,t.bmbh00,1 as SL0000,d.PXXH00,d.bwbh00  FROM vw_bq_ybfyyz_dzbl a, XT_kszxxm b, BM_ZLZD00 d ,bm_bmbm00 t where a.ZLXMID = D.ZLXMID and a.ZLXMID = b.ZLXMID(+) and t.bmbh00=b.zxksbh and d.jcmlid in(190) and ((a.YBZXLB = '1' and a.YBBRLB = '01' and a.FBBH00 = '3') or (SFSFXM = 'N')) order by d.PXXH00
/*  */


20240617  11:15:23  select distinct 'N' XZ0000, A.ZLXMID, A.ZLXMJC, A.SFJE00,D.CKZ000,' ' JGSM00,D.JGDW00, (select zyzfbl*100||'%' zfbl00  from vw_bm_ybsfdy e,xt_zlsfgx f,vw_bm_zlzd00 g where e.sfxmid=f.sfxmid and  f.zlxmid=g.ZLXMID and g.ZLXMID=a.ZLXMID and e.YBZXLB='1' and e.YBBRLB='01' and e.FBBH00='3' and e.SFYP00='N' and  rownum=1) ZFBL00, 0 zxks00, '' zxksmc,decode(A.LBBH00, '3', B.KSXMID, 0) KSXMID,t.bmmc00,t.bmbh00,1 as SL0000,d.PXXH00,d.bwbh00  FROM vw_bq_ybfyyz_dzbl a, XT_kszxxm b, BM_ZLZD00 d ,bm_bmbm00 t where a.ZLXMID = D.ZLXMID and a.ZLXMID = b.ZLXMID(+) and t.bmbh00=b.zxksbh and d.jcmlid in(10,190,430,590,191,192,193,194,196,198,203  ,370,371,212 ,390,391,213,215,216,197,200,201,202,232) and ((a.YBZXLB = '1' and a.YBBRLB = '01' and a.FBBH00 = '3') or (SFSFXM = 'N')) order by d.PXXH00
/*  */


20240617  11:15:23   select a.*,(select count(1) from BM_JCMLMX x where x.flid00=a.jcmlid) zjs,JCMLID||','||SF_ZS_GETFLIDSTR(a.JCMLID) FLIDSTR,','||JCMLID||','||SF_YS_GETZJCMLID(JCMLID) ZJCMLID FROM BM_JCMLMX a where flid00=31 order by CC0000, PXH000
/*  */

20240617  11:15:23   select a.*,(select count(1) from BM_JCMLMX x where x.flid00=a.jcmlid) zjs,JCMLID||','||SF_ZS_GETFLIDSTR(a.JCMLID) FLIDSTR,','||JCMLID||','||SF_YS_GETZJCMLID(JCMLID) ZJCMLID FROM BM_JCMLMX a where flid00=30 order by CC0000, PXH000
/*  */

20240617  11:15:23   select a.*,(select count(1) from BM_JCMLMX x where x.flid00=a.jcmlid) zjs,JCMLID||','||SF_ZS_GETFLIDSTR(a.JCMLID) FLIDSTR,','||JCMLID||','||SF_YS_GETZJCMLID(JCMLID) ZJCMLID FROM BM_JCMLMX a where flid00=10 order by CC0000, PXH000
/*  */

20240617  11:15:23   select a.*,(select count(1) from BM_JCMLMX x where x.flid00=a.jcmlid) zjs,JCMLID||','||SF_ZS_GETFLIDSTR(a.JCMLID) FLIDSTR,','||JCMLID||','||SF_YS_GETZJCMLID(JCMLID) ZJCMLID FROM BM_JCMLMX a where flid00=0 order by CC0000, PXH000
/*  */

20240617  11:15:22  parameters :zyid00=1151230 :clbz00=1 
/*  */

20240617  11:15:22  SELECT qyyshs ,a.* FROM VW_ZS_YZLL00_ZYDZBL a  where 1=1 and zyid00=:zyid00 and clbz00=:clbz00 and (yzzt00 in ('0','1','2','7','9') or (zxrq00 >= to_char(sysdate, 'YYYYMMDD') and yzzt00=3 and clbz00=1))  order by Clbz00 desc, CZPC00,QYRQ00,QYSJ00 ,PXSJ00,YZID00,YZMXID
/*  */