XinYu_RZMES/.svn/pristine/88/88cb9c72142119ccce56113b21422027e4d5cdc4.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Project A">
	<query id="ACommCode.Nor.Select" desc="订单.公用代码.Normal-查询" fetchSize="10">
        <![CDATA[
			SELECT SM_CD, SM_CFNM, CD_SEQ
			FROM TBZ00_COMMCD
			WHERE LG_CD = :1
			AND USED_YN = 'Y'
			ORDER BY CD_SEQ
        ]]>
    </query>
												
	<query id="ACommCode.AllNor.Select" desc="订单.公用代码.AllNor-查询" fetchSize="10">
        <![CDATA[
			SELECT '%'         AS SM_CD
			     , '-- ALL --' AS SM_CFNM
			     , 0           AS CD_SEQ
			FROM DUAL
			UNION ALL
			SELECT SM_CD, SM_CFNM, CD_SEQ
			FROM TBZ00_COMMCD
			WHERE LG_CD = :1
			AND USED_YN = 'Y'
			ORDER BY CD_SEQ
        ]]>
    </query>

	<query id="ACommCode.SpecStlGrd.Select" desc="订单.订单钢号.SpecStlGrd-查询" fetchSize="10">
        <![CDATA[
			SELECT SPEC_STL_GRD AS SPEC_STL_GRD
				 , SPEC_STL_GRD AS SPEC_STL_GRD_NM
			     , ROW_NUMBER() OVER (ORDER BY SPEC_STL_GRD) AS CD_SEQ
			FROM TBB01_SPEC_INGR
			GROUP BY SPEC_STL_GRD
        ]]>
    </query>

	<query id="ACommCode.AllSpecStlGrd.Select" desc="订单.订单钢号.AllSpecStlGrd-查询" fetchSize="10">
        <![CDATA[
			SELECT '%'         AS SPEC_STL_GRD_CD
			     , '-- ALL --' AS SPEC_STL_GRD_NM
			     , 0           AS CD_SEQ
			FROM DUAL
			UNION ALL
			SELECT SPEC_STL_GRD, SPEC_STL_GRD, ROW_NUMBER() OVER (ORDER BY SPEC_STL_GRD) AS CD_SEQ
			FROM TBB01_SPEC_INGR
			GROUP BY SPEC_STL_GRD
        ]]>
    </query>

</queryMap>