20190220  09:52:31  select t.*,to_char(t.zxksbh) charzxksbh,(select a.bmmc00 from bm_bmbm00 a where  a.bmbh00 = t.zxksbh)bmmc00 from xt_kszxxm t where t.zlxmid = '17254'
/*  */

20190220  09:52:31  select  JSXMKS,JSKSMC JSXMMC,to_char(JSXMKS) charzxksbh from VW_XT_XMFWFX_ZXKS_ZYDZBL where ZLXMID =17254 and SQXMKS =490  order by decode(jsxmks,490,0,1),decode(trim(yyid00),'220035',1,2),ksxmid
/*  */

20190220  09:52:31  select t.dlbqzx from bm_zlzd00 t where t.zlxmid='17254'
/*  */

20190220  09:52:31   select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B  where A.zlxmid='17254' AND A.BBID00=B.BBID00
/*  */

20190220  09:52:30  SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,JSKSBH,BRID00 
  FROM VW_HT_XTTSXX_DZBL a
 where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')
   and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = 'V ')) or (XXXZ00 = '0' and xtdm00 = 'V ')) and (JSKSBH IS NULL OR instr(',' || jsksbh || ',', decode(fsdx00,'2',',1913,','0',',490,')) > 0  ) and not exists (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000  AND JSYGBH = 1913 ) order by a.XH0000 desc
/*  */

20190220  09:52:30  select t.*,to_char(t.zxksbh) charzxksbh,(select a.bmmc00 from bm_bmbm00 a where  a.bmbh00 = t.zxksbh)bmmc00 from xt_kszxxm t where t.zlxmid = '21721'
/*  */

20190220  09:52:30  select  JSXMKS,JSKSMC JSXMMC,to_char(JSXMKS) charzxksbh from VW_XT_XMFWFX_ZXKS_ZYDZBL where ZLXMID =21721 and SQXMKS =490  order by decode(jsxmks,490,0,1),decode(trim(yyid00),'220035',1,2),ksxmid
/*  */

20190220  09:52:30  select t.dlbqzx from bm_zlzd00 t where t.zlxmid='21721'
/*  */

20190220  09:52:29   select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B  where A.zlxmid='21721' AND A.BBID00=B.BBID00
/*  */

20190220  09:52:28  select t.*,to_char(t.zxksbh) charzxksbh,(select a.bmmc00 from bm_bmbm00 a where  a.bmbh00 = t.zxksbh)bmmc00 from xt_kszxxm t where t.zlxmid = '17431'
/*  */

20190220  09:52:28  select  JSXMKS,JSKSMC JSXMMC,to_char(JSXMKS) charzxksbh from VW_XT_XMFWFX_ZXKS_ZYDZBL where ZLXMID =17431 and SQXMKS =490  order by decode(jsxmks,490,0,1),decode(trim(yyid00),'220035',1,2),ksxmid
/*  */

20190220  09:52:28  select t.dlbqzx from bm_zlzd00 t where t.zlxmid='17431'
/*  */

20190220  09:52:28   select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B  where A.zlxmid='17431' AND A.BBID00=B.BBID00
/*  */

20190220  09:52:28  select t.*,to_char(t.zxksbh) charzxksbh,(select a.bmmc00 from bm_bmbm00 a where  a.bmbh00 = t.zxksbh)bmmc00 from xt_kszxxm t where t.zlxmid = '21691'
/*  */

20190220  09:52:28  select  JSXMKS,JSKSMC JSXMMC,to_char(JSXMKS) charzxksbh from VW_XT_XMFWFX_ZXKS_ZYDZBL where ZLXMID =21691 and SQXMKS =490  order by decode(jsxmks,490,0,1),decode(trim(yyid00),'220035',1,2),ksxmid
/*  */

20190220  09:52:28  select t.dlbqzx from bm_zlzd00 t where t.zlxmid='21691'
/*  */

20190220  09:52:28   select B.BBID00,B.BBMC00 from BM_JYXMBB A,BM_BBZD00 B  where A.zlxmid='21691' AND A.BBID00=B.BBID00
/*  */

20190220  09:52:28  select t.*,to_char(t.zxksbh) charzxksbh,(select a.bmmc00 from bm_bmbm00 a where  a.bmbh00 = t.zxksbh)bmmc00 from xt_kszxxm t where t.zlxmid = '22694'
/*  */

20190220  09:52:28  select  JSXMKS,JSKSMC JSXMMC,to_char(JSXMKS) charzxksbh from VW_XT_XMFWFX_ZXKS_ZYDZBL where ZLXMID =22694 and SQXMKS =490  order by decode(jsxmks,490,0,1),decode(trim(yyid00),'220035',1,2),ksxmid
/*  */

20190220  09:52:28  select t.dlbqzx from bm_zlzd00 t where t.zlxmid='22694'
/*  */