XinYu_RZMES/.svn/pristine/a7/a757056048e25a3172d935b63317f23c3d259eb8.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||'%'
        ]]>
    </query>
    <query id="tbd01_slabdn_assemble.call" desc="板坯组合业务处理">
        <![CDATA[
            {call C_PKG_UID.PRD_SLAB_ASSEMBLE(:1,:2,:3,:4,:5,:6)}
        ]]>
    </query>
</queryMap>