14:03:55  SQL Prepare: ORACLE - SELECT 'a' BRXM00,'a' YSXM00,X.YPMC00,X.YPGG00,D.KCDW00 QLDW00,SUM(ROUND(X.YPZSL0*X.ZHL000/D.K2J000,3)) YPZSL0,
1 LSDJ00,'a' FYR000,'20030303' FYRQ00,'00:00:00' FYSJ00, 
 'a' BZMC00, 'a' YYSJ00, 'a' KB0000, 'a' XB0000, '19510602' NL0000
FROM VW_YF_BRYY X,BM_YGBM00 Y1,BM_YD0000 D 
WHERE X.YFBMBH+0=50 AND X.FYR000=Y1.YGBH00 AND X.YPNM00=D.YPNM00
AND NOT EXISTS (SELECT 1 FROM YF_YPKCXX D WHERE D.GZDJ00='0' 
                AND X.YFBMBH=D.YFBMBH AND X.YPNM00=D.YPNM00) 
AND FYRQ00>='20100818' AND FYRQ00<='20100818' 
AND FYRQ00||FYSJ00>='2010081800:00:00' AND FYRQ00||FYSJ00<='2010081823:59:59' 
GROUP BY X.YPMC00,X.YPGG00,D.KCDW00 

14:03:55  SQL Execute: ORACLE - SELECT 'a' BRXM00,'a' YSXM00,X.YPMC00,X.YPGG00,D.KCDW00 QLDW00,SUM(ROUND(X.YPZSL0*X.ZHL000/D.K2J000,3)) YPZSL0,
1 LSDJ00,'a' FYR000,'20030303' FYRQ00,'00:00:00' FYSJ00, 
 'a' BZMC00, 'a' YYSJ00, 'a' KB0000, 'a' XB0000, '19510602' NL0000
FROM VW_YF_BRYY X,BM_YGBM00 Y1,BM_YD0000 D 
WHERE X.YFBMBH+0=50 AND X.FYR000=Y1.YGBH00 AND X.YPNM00=D.YPNM00
AND NOT EXISTS (SELECT 1 FROM YF_YPKCXX D WHERE D.GZDJ00='0' 
                AND X.YFBMBH=D.YFBMBH AND X.YPNM00=D.YPNM00) 
AND FYRQ00>='20100818' AND FYRQ00<='20100818' 
AND FYRQ00||FYSJ00>='2010081800:00:00' AND FYRQ00||FYSJ00<='2010081823:59:59' 
GROUP BY X.YPMC00,X.YPGG00,D.KCDW00