1       08:44:18  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'T') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',125,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',369,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =369 AND b.JSKSBH = '125')
  AND (INSTR (',' || a.jsksbh || ',',',125,') > 0 or a.jsksbh is null)  

2       08:44:18  SQL Execute: ORACLE - SELECT ghh000,GHID00, brblh0, brxm00, brxb00, brnl00, yje000,ssje00, ROUND ((ssje00 / decode(yje000,0,1,null,1,yje000) * 100)) zkl000 FROM(SELECT A.*,(SELECT SUM(HJJE00) FROM sf_fymx00 WHERE DJH000 IN (SELECT DJH000 FROM sf_brfy00 b WHERE B.MZID00 = A.GHID00) AND xmbh00 <> '2917') YJE000,(SELECT SUM(HJJE00) FROM SF_BRFY00 WHERE MZID00 = A.GHID00) SSJE00 FROM VW_TJ_BRXXB0 A WHERE SFYX00='Y' and nvl(DWID00,0)=0AND YYID00 = '222137' AND EXISTS(SELECT 1 FROM SF_BRFY00 WHERE MZID00=A.GHID00 AND JZDH00 <> 0 ) AND TJRQ00 >= '20211124' AND TJRQ00 <= '20211124' ) 

3       08:44:18  SQL Execute: ORACLE - SELECT COUNT(*) FROM BM_YYSFXM WHERE SFXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZEJMXMID')

4       08:44:18  SQL Execute: ORACLE - SELECT COUNT(*) FROM BM_ZLZD00 WHERE ZLXMID = (SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID')

5       08:44:18  SQL Execute: ORACLE - SELECT TRIM(SF_TJ_GETXTCS('222137', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZLZDZEJMXMID'

6       08:44:18  SQL Execute: ORACLE - Select ZLXMJC,YJKSMC,ZJE000,ZHJE00,FJF000,ZKL000,ZKE000,XMZTMC,KDRQ00,KDYSXM,ZXRQ00,ZXYSXM from VW_TJ_YJ_YW0000 b where ZYGHID='31538338' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null)) UNION 
Select '总额减免收费项目' ZLXMJC, KDKSMC YJKSMC, 0 ZJE000,NVL(ZJE000,0) ZHJE00,0 FJF000,100 ZKL000,0 ZKE000,ZT0000 XMZTMC,KDRQ00,KDYSXM,'' ZXRQ00,'' ZXYSXM from VW_YJ_YW0000 b where ZYGHID='31538338' AND ZLXMID = '4510'