XinYu_RZMES/.svn/pristine/5f/5f225a5392c4e4dd27166f30bd6337287f23b978.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="">
	<query id="SELECT.ORD_SEQ" desc="订单号" fetchSize="10">
		<![CDATA[
			SELECT '' ORD_SEQ FROM DUAL
			UNION ALL
			SELECT ORD_SEQ		-- 订单号
			FROM TBE02_ORD_PRC
			WHERE ORD_NO = ?	-- 合同号
		]]>
	</query> 

	<query id="SELECT.COMMCD" desc="" fetchSize="10">
		<![CDATA[
			/*
				A01001: 接收订单区分(订货区分)		A01002: 库存销售区分
				A01003: 结算条件代码				A01004: 产品代码
				A01005: 订单取消使用区分			A01006: 订单修改事由区分
				A01007: 订单用途区分				A01008: LABEL(标签)标记方法区分
				A01009: 目的地代码				A01010: 包装方法区分
				A01011: 订单序号??代码				A01012: 运输手段区分

				B01001: 标准号					B01002: 钢号组
				B01003: 				B01004: 去向
				B01006: 				B02001: 
				D01001: COIL宽度					D01002: 设计SLAB厚度
				D01003: 短SLAB长度(MIN/MAX)		D01004: 长SLAB长度(MIN/MAX)
				D01005: SLAB修复方法

				E01001: 订单进度代码				E01002: 物料进程代码
				E01003: 异常订单类型代码			E01004: 异常物料类型代码
				E01005: 生产保留区分代码			E01006: 订单结束代码
				E01007: 订单材余材代码				E01008: 替代方法
				E01009: 替代分类					E01010: 余材原因
				E01011: 紧急材代码				E01012: HCR分类
				E01013: 生产结束代码

				F01001: 物料进程					F01002: 工厂
				F01003: 记录状态代码				F01004: 炼钢工艺流程
				F01005: 返送原因代码

				G02001: 	G03001: 
				G03002: 

				H02001: 操作故障

				J01001: 发货进程状态区分			J01002: 运输公司区分(Un-Used 2009.03.02 Commented by Mr.GONG)

				Z01001: 作业状态
			*/
			SELECT '' SM_CD, '--全部--' SM_CFNM,'--全部--' SM_EFNM , 'A' LG_CD FROM DUAL
			UNION ALL
			SELECT * FROM (
				SELECT SM_CD, SM_CFNM,SM_EFNM, LG_CD FROM TBZ00_COMMCD
				WHERE UPPER(USED_YN) = 'Y'  AND LG_CD IN (
					SELECT COLUMN_VALUE FROM TABLE(CAST(XB_PACKAGE.GF_TABSTR(?) AS TABSTR_T)))
				ORDER BY LG_CD, SM_CD,CD_SEQ )
		]]>
	</query> 

	<query id="SELECT.CUSTOMER" desc="客户" fetchSize="10">
		<![CDATA[
			SELECT '' CUST_CD, '--全部--' CUST_NM FROM DUAL
			UNION ALL
			SELECT * FROM (
				SELECT CUST_CD, CUST_NM
				FROM TBZ00_CUSTOMER
				ORDER BY CUST_NM)
		]]>
	</query> 

	<query id="SELECT.STL_GRD" desc="钢号" fetchSize="10">
		<![CDATA[
			SELECT '' STL_GRD FROM DUAL
			UNION ALL
			SELECT * FROM (
				SELECT DISTINCT FAC_STL_GRD FROM TBB01_FAC_INGR
				ORDER BY FAC_STL_GRD)
		]]>
	</query> 
	
	<query id="SELECT.SPEC_STL_GRD" desc="钢号" fetchSize="10">
		<![CDATA[			
			SELECT '' SPEC_STL_GRD FROM  DUAL
			UNION ALL
			SELECT * FROM(
				SELECT  DISTINCT SPEC_STL_GRD
				  FROM  TBA01_ORD_LINE X
				ORDER BY SPEC_STL_GRD)
		]]>
	</query>
	
	<query id="ORD_HIS_INSERT.call" desc="充当降级历史记录" fetchSize="10">
		<![CDATA[			
			{call C_PKG_ORD_REP.PRD_ORD_HIS(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13)}
		]]>
	</query>
</queryMap>