XinYu_RZMES/.svn/pristine/49/4973126d4b8d02ff122debc9f5d095e27487ffe4.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="取样委托单">
  
  <query id="UIB020231_01.SELECT" desc="" fetchSize="10">  
        
      SELECT    
      SPM.ROLL_SLAB_SEQ    SEQQQ
   -- ROW_NUMBER() OVER (ORDER BY SPM.ROLL_MANA_NO , SPM.ROLL_SLAB_SEQ  ASC) SEQQQ  
	, a.OLD_SAMPL_NO  
    , DECODE(SUBSTR(A.OLD_SAMPL_NO , 11) , '010' ,  SUBSTR(A.OLD_SAMPL_NO , 1 , 10) , NULL)   PP
    , ROW_NUMBER() OVER ( PARTITION BY SUBSTR(A.OLD_SAMPL_NO,1,10) ORDER BY A.OLD_SAMPL_NO)   SEQ            -- 序号
    , b.SPEC_STL_GRD      --标准钢号
    , a.INSTR_COIL_THK                              COIL_THK
    , a.INSTR_COIL_WTH                              COIL_WTH
    , DECODE(A.SAMPL_PICK_YN , 'Y' , '*' , NULL)    ZZZ
    , a.TOL_T9_VAL         --热态宽度
    , A.COIL_THK_OS
    , A.COIL_THK_CL
    , A.COIL_THK_DS
    , A.DCS_THK         --判定厚度
    , A.DCS_WTH         --判定宽度
    , a.EXTSHAPE_DEC_GRD   --外观判定等级
    , a.MISSNO_CLF_CD      --有无却号
	, a.CRK_CD1  
      FROM        TBH02_COIL_COMM A , TBB01_ORD_HEAD B ,  TBF02_SPEC_MILL SPM  
      WHERE       a.ORD_NO||a.ORD_SEQ   =    b.ORD_NO||b.ORD_SEQ
      AND         SPM.COIL_NO           =    A.COIL_NO
    AND         SPM.ROLL_MANA_NO    =  ?
    ORDER BY    SPM.ROLL_MANA_NO ASC ,  SPM.ROLL_SLAB_SEQ   ASC  

  </query> 

</queryMap>