XinYu_RZMES/.svn/pristine/91/91d9841b3ea61bc649614e75539e97422e4086ef.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="板坏设计组合与分解">
	<query id="tbd01_slabdn_rst.select" desc="板坏设计结果查询">
        <![CDATA[
            SELECT 'false' AS CHK
			       ,K.INGR_YN
			       ,T.* 
			FROM TBD01_SLABDN_RST T
			     ,(SELECT DISTINCT ORD_NO
			                       ,ORD_SEQ
			                       ,'Y' INGR_YN
			       FROM TBE02_ORD_PRC T1 
			       WHERE (T1.CUST_SPEC_NO_INGR IS NOT NULL OR T1.CUST_SPEC_NO_QLTY IS NOT NULL OR T1.CUST_SPEC_NO_DEL IS NOT NULL)
			       AND   T1.ORD_PROG_CD NOT IN ('F','G')
			       ) K
			WHERE T.ORD_NO = K.ORD_NO(+) 
			AND T.ORD_SEQ = K.ORD_SEQ(+) 
			AND T.COMB_YN = 'N'
			AND T.ORD_NO LIKE :1||'%'
			AND T.ORD_SEQ LIKE :2||'%'
			AND T.SLAB_WTH BETWEEN NVL(:3, 0) AND NVL(:4, 999999)
   			AND T.SLAB_LEN BETWEEN NVL(:5, 0) AND NVL(:6, 999999)
   			AND T.COIL_THK BETWEEN NVL(:7, 0) AND NVL(:8, 999999)
   			AND T.COIL_WTH BETWEEN NVL(:9, 0) AND NVL(:10, 999999)
        ]]>
    </query>
    <query id="tbd01_slabdn_assemble.call" desc="板坯组合业务处理">
        <![CDATA[
            {call C_PKG_UID.PRD_SLAB_ASSEMBLE(:1,:2,:3,:4,:5,:6)}
        ]]>
    </query>
      <query id="tbd01_slabdn_addassemble.call" desc="板坯组合业务处理">
        <![CDATA[
            {call C_PKG_UID.prd_addslab_assemble(:1,:2,:3,:4,:5,:6)}
        ]]>
    </query>
</queryMap>