1       08:26:49  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 <> '') YJE000,(SELECT SUM(HJJE00) FROM SF_BRFY00 WHERE MZID00 = A.GHID00) SSJE00 FROM VW_TJ_BRXXB0 A WHERE SFYX00='Y' AND YYID00 = '220034' AND EXISTS(SELECT 1 FROM SF_BRFY00 WHERE MZID00=A.GHID00 AND JZDH00 <> 0 ) AND TJRQ00 >= '20120229' AND TJRQ00 <= '20120330' ) 

2       08:26:49  SQL Execute: ORACLE - SELECT COUNT(*) FROM BM_YYSFXM WHERE SFXMID = (SELECT TRIM(SF_TJ_GETXTCS('220034', VALUE0)) FROM XT_XTCS00 WHERE TRIM(NAME00) = 'TJ_ZEJMXMID')

3       08:26:49  SQL Execute: ORACLE - Select ZLXMJC,YJKSMC,ZJE000,ZHJE00,FJF000,ZKL000,ZKE000,XMZTMC,KDRQ00,KDYSXM,ZXRQ00,ZXYSXM from VW_TJ_YJ_YW0000 b where ZYGHID='537662' and (not exists (select 'y' from yj_yw0000 a where a.cxdjh0=b.yjdjh0)) and ((b.cxdjh0=0) or (b.cxdjh0 is null))