select to_char(a.SSDH00)  displayname, to_char(to_char(a.SSDH00))  cmbvalue from SS_YW0000 a    where a.SSJXZT='4'  and a.zyghid in (select zyid00 from zy_brxxb0 where dqbq00=114 and brzt00 like '2%') and not exists(select 1 from SS_YWLSB0 where SSDH00=a.SSDH00 and ywlx00='0')

  SELECT * FROM vw_yzcfmx_yzzxqk  a WHERE 1 = 1 AND (yzzt00 in ('0', '1', '2','9')  or (yzzt00=3 and a.zxrq00<nvl(a.tzrq00,'20991231')) or ZXBZ00 in('01','02'))  AND DQBQ00='114'  AND ZYID00 in(1748528) and ZXKS00='114'  AND ZXRQ00 BETWEEN '20231108' AND '20231108'  order by RYCWH0,decode(ZXBZ00,'01',2,'02',1,0),CLBZ00,jhzxsj,YZID00,YZMXID 

declare
   P_ZXMXID   VARCHAR2(4000);
begin SP_BQ_YZZXQR('0','1748528','114','15144018','1','20231108','15:33:59','20231108','02:00:00','52863099',P_ZXMXID);
end;

 SELECT count(1) num   from VW_HT_XTTSXX_DZBL a  where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')    and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = 'MC')) or XXXZ00 = '0')    AND NOT EXISTS  (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND b.JSYGBH = '1'  )  and (  (INSTR(',' || a.jsksbh || ',', ',114,') > 0 and FSDX00='0')   or (INSTR(',' || jsksbh || ',', ',1,') > 0 and FSDX00='2') ) 

 SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,BRID00   FROM Vw_ht_xttsxx_dzbl a  where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')       AND NOT EXISTS  (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND b.JSYGBH = '1'  )  and (  (INSTR(',' || a.jsksbh || ',', ',114,') > 0 and FSDX00='0')   or (INSTR(',' || jsksbh || ',', ',1,') > 0 and FSDX00='2') )  and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = 'MC')) or XXXZ00 = '0')   order by a.XH0000 desc

select * from VW_BQ_XYZTX0_ZYHSZ0 a where 1 = 1  and  BQH000 = '114' order by zyid00 

select * from VW_BQ_XYZTX0_ZYHSZ0 a where 1 = 1  and  BQH000 = '114' order by zyid00 

select * from VW_BQ_XYZTX0_ZYHSZ0 a where 1 = 1  and  BQH000 = '114' order by zyid00 

  SELECT * FROM vw_yzcfmx_yzzxqk  a WHERE 1 = 1 AND (yzzt00 in ('0', '1', '2','9')  or (yzzt00=3 and a.zxrq00<nvl(a.tzrq00,'20991231')) or ZXBZ00 in('01','02'))  AND DQBQ00='114'  AND ZYID00 in(1748528) and ZXKS00='114'  AND ZXRQ00 BETWEEN '20231108' AND '20231108'  order by RYCWH0,decode(ZXBZ00,'01',2,'02',1,0),CLBZ00,jhzxsj,YZID00,YZMXID 

insert into xt_yhxxrz(id0000,xh0000,xtdm00,jsksbh,jsygbh,jsrq00,jssj00) values (sq_xt_yhxxrz_id0000.NEXTVAL,'40986','MC','114','1','20231108','15:32:16')

 SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,BRID00   FROM Vw_ht_xttsxx_dzbl a  where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')       AND NOT EXISTS  (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND b.JSYGBH = '1'  )  and (  (INSTR(',' || a.jsksbh || ',', ',114,') > 0 and FSDX00='0')   or (INSTR(',' || jsksbh || ',', ',1,') > 0 and FSDX00='2') )  and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = 'MC')) or XXXZ00 = '0')   order by a.XH0000 desc

 SELECT count(1) num   from VW_HT_XTTSXX_DZBL a  where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')    and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = 'MC')) or XXXZ00 = '0')    AND NOT EXISTS  (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND b.JSYGBH = '1'  )  and (  (INSTR(',' || a.jsksbh || ',', ',114,') > 0 and FSDX00='0')   or (INSTR(',' || jsksbh || ',', ',1,') > 0 and FSDX00='2') ) 

 SELECT XH0000, XTDM00, CZYKSM, CZRQ00, XXNR00,XXXZ00,XXBH00,XXGLLX,XXGLBZ,BRID00   FROM Vw_ht_xttsxx_dzbl a  where yxq000 >= TO_CHAR(SYSDATE, 'YYYYMMDD')       AND NOT EXISTS  (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND b.JSYGBH = '1'  )  and (  (INSTR(',' || a.jsksbh || ',', ',114,') > 0 and FSDX00='0')   or (INSTR(',' || jsksbh || ',', ',1,') > 0 and FSDX00='2') )  and ((XXXZ00 = '1' and (xtdm00 = '-1' OR xtdm00 = 'MC')) or XXXZ00 = '0')   order by a.XH0000 desc

SELECT * FROM VW_BQ_ZYBRLB_YDHL where 1 = 1  and  DQBQ00 = '114' and  ZYID00 > 0  and substr(BRZT00,0,1)='2' order by DQBQ00,decode(sf_xt_isnumber(RYCWH0),'1',to_number(RYCWH0),0), RYCWH0

select * from VW_BQ_XYZTX0_ZYHSZ0 a where 1 = 1  and  BQH000 = '114' order by zyid00 

select * from VW_BQ_XYZTX0_ZYHSZ0 a where 1 = 1  and  BQH000 = '114' order by zyid00