XinYu_RZMES/.svn/pristine/85/85dbb0122ca8d7369b7ca67cdd2e96608ec2db3f.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="">
	
	<query  id="UIB020310_01.SELECT" desc="">
		<![CDATA[
SELECT      ROWNUM
,SLAB_NO                                                         --板坯号         
,SLAB_THK                                                        --厚度
,SLAB_WTH                                                        --宽度
,SLAB_LEN                                                        --长度 
,SLAB_WGT                                                        --重量
,STL_GRD                                                         --厂内钢号
,SQ_QD_COMMON.COMMCD_CDTOCFNM('G03004',CRK_CD1)||CRK_CD1_LOC CRK_CD1    --不合格类别
--板坯来源
,TO_CHAR(TO_DATE(EXTSHAPE_DEC_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS EXTSHAPE_DEC_DTIME   --板坯判定日
,EXTSHAPE_DEC_EMP_ID                                             --板坯判定人
,SQ_QD_COMMON.COMMCD_FINDGR_SHIFT(slab_cut_dtime) GR_SHIFT       --检验班次
,SQ_QD_COMMON.COMMCD_FINDGR_GROUP(slab_cut_dtime) GR_GROUP       --检验班组         
FROM        TBG02_SLAB_COMM t
WHERE       t.EXTSHAPE_GRD                                       =        '2'
AND         T.EXTSHAPE_DEC_DTIME                                 >=       ?||'000000'
AND         T.EXTSHAPE_DEC_DTIME                                 <=       ?||'235959'  
AND         t.STL_GRD                                            LIKE     ?||'%'
AND         SUBSTR(T.SLAB_NO,2,2)||SUBSTR(T.SLAB_NO,5,5)         >=       NVL(SUBSTR(?,2,2)||SUBSTR(?,5,5),'0000000')               
AND         SUBSTR(T.SLAB_NO,2,2)||SUBSTR(T.SLAB_NO,5,5)         <=       NVL(SUBSTR(?,2,2)||SUBSTR(?,5,5),'9999999')		
		]]>	
	</query>
	
	<query  id="UIB020310_02.SELECT" desc="">
		<![CDATA[
SELECT          DISTINCT stl_grd
FROM            TBG02_SLAB_COMM 			
	    ]]>	
	</query>

	<query  id="UIB020310_03.SELECT" desc="">
		<![CDATA[
SELECT          DISTINCT SUBSTR(SLAB_NO,1,10) CHARGE_NO
FROM            TBG02_SLAB_COMM 			
	    ]]>	
	</query>		
</queryMap>