= ?||'000000' AND DECODE(?,'1',G02CC.INGR_DEC_DTIME,'2',G02CC.CASTING_END_DTIME) <= ?||'235959' AND G02CC.STL_GRD LIKE ?||'%' GROUP BY G02CC.CHARGE_NO)X, (SELECT G02CC.CHARGE_NO ,SUM(DECODE(G02SC.EXTSHAPE_GRD,'2',1,0)) OFF ,SUM(DECODE(G02SC.CRK_CD1,'07',1,0) +DECODE(G02SC.CRK_CD2,'07',1,0) +DECODE(G02SC.CRK_CD3,'07',1,0) +DECODE(G02SC.CRK_CD4,'07',1,0) +DECODE(G02SC.CRK_CD5,'07',1,0) +DECODE(G02SC.CRK_CD6,'07',1,0) +DECODE(G02SC.CRK_CD7,'07',1,0) +DECODE(G02SC.CRK_CD8,'07',1,0) +DECODE(G02SC.CRK_CD9,'07',1,0) +DECODE(G02SC.CRK_CD10,'07',1,0)) LIEWEN --裂纹(G03004) ,SUM(DECODE(G02SC.CRK_CD1,'10',1,0) +DECODE(G02SC.CRK_CD2,'10',1,0) +DECODE(G02SC.CRK_CD3,'10',1,0) +DECODE(G02SC.CRK_CD4,'10',1,0) +DECODE(G02SC.CRK_CD5,'10',1,0) +DECODE(G02SC.CRK_CD6,'10',1,0) +DECODE(G02SC.CRK_CD7,'10',1,0) +DECODE(G02SC.CRK_CD8,'10',1,0) +DECODE(G02SC.CRK_CD9,'10',1,0) +DECODE(G02SC.CRK_CD10,'10',1,0)) JIAZA --夹杂(G03004) ,SUM(DECODE(G02SC.CRK_CD1,'31',1,0) +DECODE(G02SC.CRK_CD2,'31',1,0) +DECODE(G02SC.CRK_CD3,'31',1,0) +DECODE(G02SC.CRK_CD4,'31',1,0) +DECODE(G02SC.CRK_CD5,'31',1,0) +DECODE(G02SC.CRK_CD6,'31',1,0) +DECODE(G02SC.CRK_CD7,'31',1,0) +DECODE(G02SC.CRK_CD8,'31',1,0) +DECODE(G02SC.CRK_CD9,'31',1,0) +DECODE(G02SC.CRK_CD10,'31',1,0)) fenceng --分层 ,SUM(DECODE(G02SC.CRK_CD1,'14',1,0) +DECODE(G02SC.CRK_CD2,'14',1,0) +DECODE(G02SC.CRK_CD3,'14',1,0) +DECODE(G02SC.CRK_CD4,'14',1,0) +DECODE(G02SC.CRK_CD5,'14',1,0) +DECODE(G02SC.CRK_CD6,'14',1,0) +DECODE(G02SC.CRK_CD7,'14',1,0) +DECODE(G02SC.CRK_CD8,'14',1,0) +DECODE(G02SC.CRK_CD9,'14',1,0) +DECODE(G02SC.CRK_CD10,'14',1,0)) qikong --气孔 ,SUM(DECODE(G02SC.CRK_CD1,'30',1,0) +DECODE(G02SC.CRK_CD2,'30',1,0) +DECODE(G02SC.CRK_CD3,'30',1,0) +DECODE(G02SC.CRK_CD4,'30',1,0) +DECODE(G02SC.CRK_CD5,'30',1,0) +DECODE(G02SC.CRK_CD6,'30',1,0) +DECODE(G02SC.CRK_CD7,'30',1,0) +DECODE(G02SC.CRK_CD8,'30',1,0) +DECODE(G02SC.CRK_CD9,'30',1,0) +DECODE(G02SC.CRK_CD10,'30',1,0)) shuangjiao --双浇 ,SUM(DECODE(G02SC.CRK_CD1,'18',1,0) +DECODE(G02SC.CRK_CD2,'18',1,0) +DECODE(G02SC.CRK_CD3,'18',1,0) +DECODE(G02SC.CRK_CD4,'18',1,0) +DECODE(G02SC.CRK_CD5,'18',1,0) +DECODE(G02SC.CRK_CD6,'18',1,0) +DECODE(G02SC.CRK_CD7,'18',1,0) +DECODE(G02SC.CRK_CD8,'18',1,0) +DECODE(G02SC.CRK_CD9,'18',1,0) +DECODE(G02SC.CRK_CD10,'18',1,0)) aokeng --凹坑 ,SUM(DECODE(G02SC.CRK_CD1,'17',1,0) +DECODE(G02SC.CRK_CD2,'17',1,0) +DECODE(G02SC.CRK_CD3,'17',1,0) +DECODE(G02SC.CRK_CD4,'17',1,0) +DECODE(G02SC.CRK_CD5,'17',1,0) +DECODE(G02SC.CRK_CD6,'17',1,0) +DECODE(G02SC.CRK_CD7,'17',1,0) +DECODE(G02SC.CRK_CD8,'17',1,0) +DECODE(G02SC.CRK_CD9,'17',1,0) +DECODE(G02SC.CRK_CD10,'17',1,0)) tukuai --凸块 --'', --化废 --'', --弯曲 ,SUM(DECODE(G02SC.CRK_CD1,'01',1,0) +DECODE(G02SC.CRK_CD2,'01',1,0) +DECODE(G02SC.CRK_CD3,'01',1,0) +DECODE(G02SC.CRK_CD4,'01',1,0) +DECODE(G02SC.CRK_CD5,'01',1,0) +DECODE(G02SC.CRK_CD6,'01',1,0) +DECODE(G02SC.CRK_CD7,'01',1,0) +DECODE(G02SC.CRK_CD8,'01',1,0) +DECODE(G02SC.CRK_CD9,'01',1,0) +DECODE(G02SC.CRK_CD10,'01',1,0)) tuofang --脱方 --'', --疏松 FROM TBG02_CHARGE_COMM G02CC ,TBG02_SLAB_COMM G02SC WHERE G02CC.CHARGE_NO = SUBSTR(G02SC.SLAB_NO,1,10) AND DECODE(?,'1',G02SC.SMS_YARD_EXT_DTIME,'2',G02CC.CASTING_END_DTIME , '3' , G02CC.INGR_DEC_DTIME) >= ?||'01000000' AND DECODE(?,'1',G02SC.SMS_YARD_EXT_DTIME,'2',G02CC.CASTING_END_DTIME , '3' , G02CC.INGR_DEC_DTIME) <= ?||'235959' AND G02CC.STL_GRD LIKE ?||'%' GROUP BY G02CC.CHARGE_NO)Y WHERE X.CHARGE_NO = Y.CHARGE_NO AND X.CHARGE_NO BETWEEN ? AND ? ]]> SELECT * FROM -------------A (SELECT SUM(DECODE(SC.CRK_CD1,'07',1,0)) LIEWEN --裂纹 ,SUM(DECODE(SC.CRK_CD1,'10',1,0)) JIAZA --夹杂 ,SUM(DECODE(SC.CRK_CD1,'31',1,0)) FENCENG --分层 ,SUM(DECODE(SC.CRK_CD1,'14',1,0)) QIKONG --气孔 ,SUM(DECODE(SC.CRK_CD1,'30',1,0)) SHUANGJIAO --双浇 ,SUM(DECODE(SC.CRK_CD1,'18',1,0)) AOKENG --凹坑 ,SUM(DECODE(SC.CRK_CD1,'17',1,0)) TUKUAI --凸块 ,SUM(DECODE(SC.CRK_CD1,'01',1,0)) TUOFANG --脱方 ,( SUM(DECODE(SC.CRK_CD1,'07',1,0)) --裂纹 +SUM(DECODE(SC.CRK_CD1,'10',1,0)) --夹杂 +SUM(DECODE(SC.CRK_CD1,'31',1,0)) --分层 +SUM(DECODE(SC.CRK_CD1,'14',1,0)) --气孔 +SUM(DECODE(SC.CRK_CD1,'30',1,0)) --双浇 +SUM(DECODE(SC.CRK_CD1,'18',1,0)) --凹坑 +SUM(DECODE(SC.CRK_CD1,'17',1,0)) --凸块 +SUM(DECODE(SC.CRK_CD1,'01',1,0)) --脱方 ) OFF ,( SUM(DECODE(SC.CRK_CD1,'07',SC.SLAB_WGT,0)) --裂纹 +SUM(DECODE(SC.CRK_CD1,'10',SC.SLAB_WGT,0)) --夹杂 +SUM(DECODE(SC.CRK_CD1,'31',SC.SLAB_WGT,0)) --分层 +SUM(DECODE(SC.CRK_CD1,'14',SC.SLAB_WGT,0)) --气孔 +SUM(DECODE(SC.CRK_CD1,'30',SC.SLAB_WGT,0)) --双浇 +SUM(DECODE(SC.CRK_CD1,'18',SC.SLAB_WGT,0)) --凹坑 +SUM(DECODE(SC.CRK_CD1,'17',SC.SLAB_WGT,0)) --凸块 +SUM(DECODE(SC.CRK_CD1,'01',SC.SLAB_WGT,0)) --脱方 ) DUNWEI ,SUBSTR(SC.SLAB_NO , 1,10)SLAB_NO ,SC.SMS_YARD_EXT_DTIME FROM TBG02_SLAB_COMM SC GROUP BY SUBSTR(SC.SLAB_NO , 1,10) , SC.SMS_YARD_EXT_DTIME ) A -----------B ,( SELECT G02CC.CHARGE_NO ,G02CC.STL_GRD ,G02CC.CASTING_END_DTIME ,G02CC.INGR_DEC_DTIME ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'C',B02WI.CHEM_VAL)) C ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'MN',B02WI.CHEM_VAL)) MN ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'S',B02WI.CHEM_VAL)) S ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'P',B02WI.CHEM_VAL)) P ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'SI',B02WI.CHEM_VAL)) SI ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'CR',B02WI.CHEM_VAL)) CR ,MAX(DECODE(UPPER(B02WI.CHEM_CD),'NI',B02WI.CHEM_VAL)) NI ,MAX(DECODE(UPPER(B02WI.CHEM_CD) ,'QB1',B02WI.CHEM_VAL ,'QB2',B02WI.CHEM_VAL ,'QB3',B02WI.CHEM_VAL))CEQ FROM TBG02_CHARGE_COMM G02CC ,TBB02_WORK_INGR B02WI WHERE G02CC.CHARGE_NO = B02WI.CHARGE_NO AND G02CC.LST_INGR_CD = B02WI.PROC_CD||B02WI.CHEM_SEQ GROUP BY G02CC.CHARGE_NO ,G02CC.STL_GRD ,G02CC.CASTING_END_DTIME ,G02CC.INGR_DEC_DTIME) B ----------WHERE WHERE SUBSTR(A.SLAB_NO ,1,10 ) = B.CHARGE_NO AND B.CHARGE_NO BETWEEN ? AND ? AND DECODE(?,'1',A.SMS_YARD_EXT_DTIME,'2',B.CASTING_END_DTIME , '3' , B.INGR_DEC_DTIME) BETWEEN ?||'0000' AND ?||'9999' AND B.STL_GRD LIKE ?||'%' SELECT SUM(DECODE(WIR.CHEM_L2_PROC_CD , 'FCP' , 1 , 0))/COUNT(*) FU FROM TBB02_WORK_INGR WIR , TBG02_CHARGE_COMM CCM WHERE WIR.CHARGE_NO = CCM.CHARGE_NO AND WIR.PROC_CD||WIR.CHEM_SEQ = CCM.LST_INGR_CD AND CHEM_CD = 'C' AND WIR.REG_DTIME BETWEEN ?||'0000' AND ?||'9999' AND WIR.CHARGE_NO BETWEEN ? AND ?