XinYu_RZMES/.svn/pristine/d3/d3105989baa3ccaad312a44e1ab191553ffc9f4d.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc=" 中厚板板坯充当  ">
 <query id="UIG040110_UNORDER_SLAB.select" desc=" 查询炼钢板坯库内可充当坯料 ">
	   <![CDATA[
			SELECT 'false' CHK
			       ,T1.SLAB_NO
			       ,T1.STL_GRD
			       ,T1.SLAB_THK
			       ,T1.SLAB_WTH
			       ,T1.SLAB_LEN
			       ,T1.SLAB_WGT
			       ,T1.CUR_LOAD_LOC 
			
			FROM TBG02_SLAB_COMM T1
			WHERE 1=1
			AND   T1.SLAB_STAT = '2'
			AND   T1.ORD_FL = '2'
			AND   T1.ORD_NO IS  NULL
			AND   T1.ORD_SEQ IS  NULL
			AND   T1.DSN_SLAB_NO IS NULL
			--AND   T1.CUR_LOAD_LOC  LIKE 'L%'
			AND   T1.STL_GRD LIKE :1||'%'
			AND   T1.SLAB_THK BETWEEN :2 AND :3
			AND   T1.SLAB_WTH BETWEEN :4 AND :5	
			AND   T1.SLAB_NO  LIKE :6||'%'	
		]]>
 </query>
 <query id="UIG040110_ORDER_SLAB.select" desc=" 查询炼钢板坯库内可充当坯料 ">
	   <![CDATA[
			SELECT 'false' CHK
			       ,T1.SLAB_NO
			       ,T1.STL_GRD
			       ,T1.SLAB_THK
			       ,T1.SLAB_WTH
			       ,T1.SLAB_LEN
			       ,T1.SLAB_WGT
			       ,T1.CUR_LOAD_LOC 
				   ,t1.DSN_SLAB_NO
                   ,t1.ORD_NO,t1.ORD_SEQ
			FROM TBG02_SLAB_COMM T1
			WHERE 1=1
			AND   T1.SLAB_STAT = '2'
			AND   T1.ORD_FL = '1'
			AND   T1.ORD_NO IS  not null
			AND   T1.ORD_SEQ IS  not null
			AND   T1.DSN_SLAB_NO IS not NULL
			--AND   T1.CUR_LOAD_LOC  LIKE 'L%'
			AND   T1.STL_GRD LIKE :1||'%'
			AND   T1.SLAB_THK BETWEEN :2 AND :3
			AND   T1.SLAB_WTH BETWEEN :4 AND :5	
			AND   T1.SLAB_NO  LIKE :6||'%'	
		]]>
 </query> 
 <query id="UIG040110_SLAB_INS.select" desc=" 查询跟选定坯料匹配的坯料计划 ">
	   <![CDATA[
			SELECT 'false' CHK
           ,T1.L2_SCH_NO
             ,T1.DSN_SLAB_NO
             ,T1.FAC_STL_GRD
             ,T1.SLAB_THK
             ,T1.SLAB_WTH
             ,T1.SLAB_LEN
             ,T1.SLAB_WGT
             ,'' SUB_DSN_SLAB_NO
      FROM TBD01_SLABDN_OBJ2 T1
           ,TBG02_SLAB_COMM T2
           ,TBB01_ORD_MAP T3
      WHERE 1 = 1
      AND   T1.PROC_STAT = '01'
      AND   T1.ORD_NO = T3.ZH_ORD_NO
          AND   T1.ORD_SEQ = T3.ZH_ORD_SEQ
      AND   T1.ORD_NO IS NOT NULL
      AND   T1.ORD_SEQ IS NOT NULL
      AND   T2.ORD_FL = '2'
      AND   T2.ORD_NO IS NULL
      AND   T2.ORD_SEQ IS NULL
      AND   T2.DSN_SLAB_NO IS NULL
      AND   T2.SLAB_NO = :1
      AND   T1.L2_SCH_NO||'&' LIKE :2||'%'
      AND ('Y' <> NVL(:3, 'N') OR (T1.FAC_STL_GRD = T2.STL_GRD ))  -- 同牌号
      AND ('Y' <> NVL(:4, 'N') OR (GF_NIB028720(T2.SLAB_NO, T3.ORD_NO, T3.ORD_SEQ) = 'YY'))  -- 检查成分项目
      AND ('Y' <> NVL(:5, 'N') OR (T2.SLAB_WGT BETWEEN (T1.SLAB_WGT - 1000) AND (T1.SLAB_WGT + 1000))) --同单重
      AND ('Y' <> NVL(:6, 'N') OR ((T2.SLAB_WTH BETWEEN T1.SLAB_WTH AND T1.SLAB_WTH + 100) AND T2.SLAB_THK = T1.SLAB_THK)) --同尺寸
      
      UNION ALL
      
      SELECT 'false' CHK
               ,T1.L2_SCH_NO
                 ,T1.DSN_SLAB_NO
                 ,T3.FAC_STL_GRD
                 ,T1.SLAB_THK
                 ,T1.SLAB_WTH
                 ,T1.SLAB_LEN
                 ,T1.SLAB_WGT
                 ,T1.SUB_DSN_SLAB_NO
          FROM TBD01_SLABDN_OBJ2_DETAIL T1
               ,TBD01_SLABDN_OBJ2 T3
               ,TBG02_SLAB_COMM T2
               ,TBB01_ORD_MAP T4
               --,TBD01_SLABDN_OBJ2_DETAIL T3
          WHERE 1 = 1
          AND   T1.DSN_SLAB_NO = T3.DSN_SLAB_NO
          AND   T2.ORD_NO = T4.ZH_ORD_NO
              AND   T2.ORD_SEQ = T4.ZH_ORD_SEQ
          AND   T1.PROC_STAT = '01'
          AND   T1.ORD_NO IS NOT NULL
          AND   T1.ORD_SEQ IS NOT NULL
          AND   T2.ORD_FL = '2'
          AND   T2.ORD_NO IS NULL
          AND   T2.ORD_SEQ IS NULL
          AND   T2.DSN_SLAB_NO IS NULL
          AND   T2.SLAB_NO = :7
          AND   T3.L2_SCH_NO||'&' LIKE :8||'%'
          AND ('Y' <> NVL(:9, 'N') OR (T3.FAC_STL_GRD = T2.STL_GRD ))  -- 同牌号
          AND ('Y' <> NVL(:10, 'N') OR (GF_NIB028720(T2.SLAB_NO, T4.ORD_NO, T4.ORD_SEQ) = 'YY'))  -- 检查成分项目
          AND ('Y' <> NVL(:11, 'N') OR (T2.SLAB_WGT BETWEEN (T1.SLAB_WGT - 1000) AND (T1.SLAB_WGT + 1000))) --同单重
          AND ('Y' <> NVL(:12, 'N') OR ((T2.SLAB_WTH BETWEEN T1.SLAB_WTH AND T1.SLAB_WTH + 100) AND T2.SLAB_THK = T1.SLAB_THK)) --同尺寸	
		]]>
 </query> 
 <query id="UIH040110.zhb_slab_rep" desc=" 中厚板坯料充当 " fetchSize="10">
		<![CDATA[
         	{call PKG_UIG.PROD_PLT_SLAB_REP(:1,:2,:3,:4,:5,:6,:7)}
		]]>
 </query>
 <query id="UIH040120.zhb_slab_disrep" desc=" 中厚板坯料充当 " fetchSize="10">
		<![CDATA[
         	{call PKG_UIG.PROD_PLT_SLAB_DISREP(:1,:2,:3)}
		]]>
 </query>
</queryMap>