XinYu_LZMES/.svn/pristine/1d/1df3cb0a4299789879e41956bcb0159ffc5e5a92.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="入库待机钢卷查询">
	<query id="UIK020040_08.SELECT" desc="无时间查询"> 
		<![CDATA[
							SELECT
							  ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO,A.ROLL_COIL_SEQ )  ROWSEQ    
							 ,A.ROLL_COIL_SEQ SEQ --轧辊内顺序
							 ,A.STL_GRD                                        --热轧牌号 
							 ,C_PKG_UIM.GET_STDDATESTR(B.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME                               --入库时间
							 ,B.COIL_THK                                                  --热卷厚度
							 ,B.COIL_INDIA                                                  --热卷内径
							 ,B.COIL_OUTDIA                                                  --热卷外径
							 ,B.ORD_FL                                                         --订单区分
							 ,B.COIL_WTH                                                 --热卷宽度
							 ,B.COIL_LEN                                                 --热卷长度
							 ,B.ACT_WGT COIL_WGT                                         --热卷重量 
			               ,E.ORD_THK H_ORD_THK                                        --热轧订单厚度
			               ,E.ORD_WTH H_ORD_WTH                                        --热轧订单宽度
			               ,E.ORD_LEN H_ORD_LEN                                        --热轧订单长度
			               ,E.ORD_INDIA H_ORD_INDIA                                    --热轧订单内径
			               ,E.ORD_OUTDIA H_ORD_OUTDIA                                  --热轧订单外径
			               ,B.CUR_LOAD_LOC
										 ,E.C_ORD_THK ORD_THK                                         --成品订单厚度
			               ,E.C_ORD_WTH ORD_WTH                                         --成品订单宽度
			               ,E.ORD_UNIT_WGT ORD_WGT                                      --成品订单重量
			               ,E.C_SPEC_STL_GRD                                            --冷轧牌号
			               ,E.C_ORD_INDIA INSTR_COIL_INDIA                              --订单内径
			               ,E.C_ORD_OUTDIA INSTR_COIL_OUTDIA                            --订单外径
			               ,E.C_ORD_LEN INSTR_COIL_LEN                                  --订单长度
			               ,XB_PACKAGE.GF_COMNNAME_FIND('H02001' , B.CRK_CD1)||CASE WHEN B.CRK_CD2 IS NOT NULL THEN '+' ELSE ' ' END ||XB_PACKAGE.GF_COMNNAME_FIND('H02001' , B.CRK_CD2)  COIL_CRK --缺陷
			                --20130111
			               ,A.COIL_NO                                                   --热卷号
			               ,A.C_COIL_NO OLD_SAMPL_NO                                    --实绩冷卷号
			               ,(select E.C_EXTSHAPE_REQ from TBE02_ORD_PRC E WHERE E.ORD_SEQ = A.ORD_SEQ AND E.ORD_NO = A.ORD_NO ) C_EXTSHAPE_REQ                --表面要求
			               ,(select E.ACID_PROD_PATH from TBE02_ORD_PRC E WHERE E.ORD_SEQ = A.ORD_SEQ AND E.ORD_NO = A.ORD_NO ) ACID_PROD_PATH                  --工艺流程
			               -- ,SUBSTR(A.SLAB_NO,1,10)                          CHARGE_NO  --炉号
			               ,T2.SM_CFNM                                      BZ   --发货方式
			               ,T3.SM_CFNM ORDCUST_CD              --发货单位
			               ,T1.SM_CFNM                          --订货单位
			               --,A.C_COIL_NO                                                     --酸轧卷号
			               ,CASE  WHEN (A.STATUS_CD = 'A' AND B.COIL_STAT = '2' )    THEN '轧制作业待机'
			               WHEN (A.STATUS_CD = 'E'                           )  THEN '轧制吊销'
			               WHEN (A.STATUS_CD = 'B'                           )  THEN '上料完成'
			               WHEN (A.STATUS_CD = 'C')                            THEN '轧制进行'
			               WHEN (A.STATUS_CD = 'D' AND H.MISSNO_CLF_CD is null) THEN '轧制完成'
			               WHEN (A.STATUS_CD = 'D' AND H.MISSNO_CLF_CD =  '1')  THEN '轧废'
			               ELSE ''                                      END    STATUS_CD
			               ,A.ROLL_MANA_NO                                   --轧制单元号
			               ,A.ORD_NO                         --合同号
			               ,A.ORD_SEQ                      --订单号
			               ,H.CUR_LOAD_LOC  C_COIL_LOAD_LOC                    --酸轧卷位置
			               ,H.ACT_WGT                                --酸轧卷实际重量
			               ,B.CUR_LOAD_LOC  H_COIL_LOAD_LOC     --热轧卷位置
			               ,DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN     --客户特殊要求
			               ,C_PKG_UIM.GET_STDTIMESTR(H.MILL_DTIME) MILL_DTIME               --轧制时间
			               ,DECODE(B.INGR_DEC_GRD,'0','待判定','1','合格','2','不合格','') INGR_DEC_GRD    --成份等级 
                           ,A.PRODNM_CD||'/'||L.C_EXTSHAPE_REQ||'/'||SUBSTR(PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP ),0,1)||'/大于'||L.PROD_WGT_MIN||'小于'||L.PROD_WGT_MAX||'/'||PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP )||'/厚度('||E.C_ORD_THK_MIN||'~'||E.C_ORD_THK_MAX||')/宽度('||E.C_ORD_WTH_MIN||'~'||E.C_ORD_WTH_MAX||')/内径('||L.C_ORD_INDIA||')'   JISHUYAOQIU
                             ,CASE WHEN SUBSTR(B.ORD_NO  , 0,2)= '42' THEN '过度材' ELSE '订单材' END ||DECODE(L.EDGE_PROC_YN , 'Y' , '切边' , '不切边')   ORD_RMK
                             ,L.PROD_LINE
                             ,  (DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MIN, E.SUAN_THK_MIN) +
       DECODE(E.SUAN_THK_MAX, NULL, E.C_ORD_THK_MAX, E.SUAN_THK_MAX)) / 2 || '[' ||
       DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MIN, E.SUAN_THK_MIN) || ',' ||
       DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MAX, E.SUAN_THK_MAX) || ']' || ';' || '[' ||
       DECODE(E.SUAN_WTH_MIN, NULL, E.C_ORD_WTH_MIN, E.SUAN_WTH_MIN) || ',' ||
       DECODE(E.SUAN_WTH_MAX, NULL, E.C_ORD_WTH_MAX, E.SUAN_WTH_MAX) || ']'   GCH --酸轧公差带
                              ,L.C_ORD_INDIA JQU --卷曲内经
                             ,L.HARSHNESS       --粗燥度
                             ,L.APPLICATION   --用途
                             ,L.L_BMD   GM    --光面、麻面
                              -- ,L.MK_CONTENT       --订单备注
                            ,L.OIL_DEF       --涂油代码
                           , K1.DEL_TOL_WTH_MIN, K1.DEL_TOL_WTH_MAX--宽度公差
                              --  ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.SM_CD=L.ORD_USE_ALIAS) USEAGE_CD  --用途
                             , PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP ) BAO  --包装方式
							 FROM   C_TBF03_SPEC_MILL A  
							 ,C_TBK02_COIL_COMM B
							 ,TBE02_ORD_PRC   E
							 ,C_TBL02_COIL_COMM H
							 ,TBA01_ORD_LINE  L
							 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T) T1
							 ,(SELECT   SM_CD, SM_CFNM FROM TBZ00_COMMCD  WHERE LG_CD = 'A01012') T2
							 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T) T3
							 ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
							 FROM TBB01_ORD_INGR
							 WHERE DSN_KIND = '1') K,
							  (SELECT DISTINCT ORD_NO, ORD_SEQ,DEL_TOL_WTH_MIN, DEL_TOL_WTH_MAX
                                FROM TBB01_ORD_DEL
                                WHERE DSN_KIND = '4') K1
							 WHERE  A.ORD_NO           = E.ORD_NO(+)
							 AND A.ORD_SEQ          = E.ORD_SEQ(+) 
							 AND A.ORD_NO           = K.ORD_NO(+)
							 AND A.ORD_SEQ          = K.ORD_SEQ(+)
							 AND A.ORD_NO 			= K1.ORD_NO(+)
   							 AND A.ORD_SEQ 			= K1.ORD_SEQ(+)
							 AND A.ORD_NO           =L.ORD_NO(+)
							 AND A.ORD_SEQ         = L.ORD_SEQ(+)
							 AND A.COIL_NO          =  B.COIL_NO(+)
							 AND B.CUST_CD          =  T1.SM_CD(+)  
							 AND E.ORDCUST_CD       =  T3.SM_CD(+)
							 AND L.DLIV_TP          =  T2.SM_CD(+)  
							 AND A.C_COIL_NO      =  H.COIL_NO(+)
							 AND A.COIL_NO = B.COIL_NO(+)
							 AND A.STATUS_CD NOT LIKE 'R'
							 AND A.ROLL_MANA_NO  >= ?  AND A.ROLL_MANA_NO <= ? 
							 --AND SUBSTR(A.REG_DTIME,1,8)    BETWEEN ? AND ?
							 AND NVL(H.MILL_DTIME,'000000')  BETWEEN ?||'000000' AND ?||'999999'
							 and a.ord_no like ?||'%'
							 and a.ord_seq like ?||'%'
		 ]]>
	</query>

	<query id="UIK020040_09.SELECT" desc="有时间查询">
		<![CDATA[
		SELECT    ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO,A.ROLL_COIL_SEQ )  ROWSEQ     
							 ,A.ROLL_COIL_SEQ SEQ --轧辊内顺序
							 ,A.STL_GRD                                        --热轧牌号 
							 ,C_PKG_UIM.GET_STDDATESTR(B.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME                               --入库时间
							 ,B.COIL_THK                                                  --热卷厚度
							 ,B.COIL_INDIA                                                  --热卷内径
							 ,B.COIL_OUTDIA                                                  --热卷外径
							 ,B.ORD_FL                                                         --订单区分
							 ,B.COIL_WTH                                                 --热卷宽度
							 ,B.COIL_LEN                                                 --热卷长度
							 ,B.ACT_WGT COIL_WGT                                         --热卷重量 
               ,E.ORD_THK H_ORD_THK                                        --热轧订单厚度
               ,E.ORD_WTH H_ORD_WTH                                        --热轧订单宽度
               ,E.ORD_LEN H_ORD_LEN                                        --热轧订单长度
               ,E.ORD_INDIA H_ORD_INDIA                                    --热轧订单内径
               ,E.ORD_OUTDIA H_ORD_OUTDIA                                  --热轧订单外径
               ,B.CUR_LOAD_LOC
			   ,E.C_ORD_THK ORD_THK                                         --成品订单厚度
               ,E.C_ORD_WTH ORD_WTH                                         --成品订单宽度
               ,E.ORD_UNIT_WGT ORD_WGT                                      --成品订单重量
               ,E.C_SPEC_STL_GRD                                            --冷轧牌号
               ,E.C_ORD_INDIA INSTR_COIL_INDIA                              --订单内径
               ,E.C_ORD_OUTDIA INSTR_COIL_OUTDIA                            --订单外径
               ,E.C_ORD_LEN INSTR_COIL_LEN                                  --订单长度
               ,XB_PACKAGE.GF_COMNNAME_FIND('H02001' , B.CRK_CD1)||CASE WHEN B.CRK_CD2 IS NOT NULL THEN '+' ELSE ' ' END ||XB_PACKAGE.GF_COMNNAME_FIND('H02001' , B.CRK_CD2)  COIL_CRK --缺陷
               --20130111
               ,A.COIL_NO                                                   --热卷号
               ,A.C_COIL_NO OLD_SAMPL_NO                                    --实绩冷卷号
               ,(select E.C_EXTSHAPE_REQ from TBE02_ORD_PRC E WHERE E.ORD_SEQ = A.ORD_SEQ AND E.ORD_NO = A.ORD_NO ) C_EXTSHAPE_REQ                --表面要求
               ,(select E.ACID_PROD_PATH from TBE02_ORD_PRC E WHERE E.ORD_SEQ = A.ORD_SEQ AND E.ORD_NO = A.ORD_NO ) ACID_PROD_PATH                  --工艺流程
               -- ,SUBSTR(A.SLAB_NO,1,10)                          CHARGE_NO  --炉号
               ,T2.SM_CFNM                                      BZ   --发货方式
               ,T3.SM_CFNM ORDCUST_CD              --发货单位
               ,T1.SM_CFNM                          --订货单位
               --,A.C_COIL_NO                                                     --酸轧卷号
               ,CASE  WHEN (A.STATUS_CD = 'A' AND B.COIL_STAT = '2' )    THEN '轧制作业待机'
               WHEN (A.STATUS_CD = 'E'                           )  THEN '轧制吊销'
               WHEN (A.STATUS_CD = 'B'                           )  THEN '上料完成'
               WHEN (A.STATUS_CD = 'C')                            THEN '轧制进行'
               WHEN (A.STATUS_CD = 'D' AND H.MISSNO_CLF_CD is null) THEN '轧制完成'
               WHEN (A.STATUS_CD = 'D' AND H.MISSNO_CLF_CD =  '1')  THEN '轧废'
               ELSE ''                                      END    STATUS_CD
               ,A.ROLL_MANA_NO                                   --轧制单元号
               ,A.ORD_NO                         --合同号
               ,A.ORD_SEQ                      --订单号
               ,H.CUR_LOAD_LOC  C_COIL_LOAD_LOC                    --酸轧卷位置
               ,H.ACT_WGT                                --酸轧卷实际重量
               ,B.CUR_LOAD_LOC  H_COIL_LOAD_LOC     --热轧卷位置
               ,DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN     --客户特殊要求
               ,C_PKG_UIM.GET_STDTIMESTR(H.MILL_DTIME) MILL_DTIME               --轧制时间
               ,DECODE(B.INGR_DEC_GRD,'0','待判定','1','合格','2','不合格','') INGR_DEC_GRD    --成份等级 
               ,A.PRODNM_CD||'/'||L.C_EXTSHAPE_REQ||'/'||SUBSTR(PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP ),0,1)||'/大于'||L.PROD_WGT_MIN||'小于'||L.PROD_WGT_MAX||'/'||PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP )||'/厚度('||E.C_ORD_THK_MIN||'~'||E.C_ORD_THK_MAX||')/宽度('||E.C_ORD_WTH_MIN||'~'||E.C_ORD_WTH_MAX||')/内径('||L.C_ORD_INDIA||')'   JISHUYAOQIU
               ,CASE WHEN SUBSTR(B.ORD_NO  , 0,2)= '42' THEN '过度材' ELSE '订单材' END ||DECODE(L.EDGE_PROC_YN , NULL , '不切边' , '切边')   ORD_RMK
               ,L.PROD_LINE  
               ,  (DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MIN, E.SUAN_THK_MIN) +
       DECODE(E.SUAN_THK_MAX, NULL, E.C_ORD_THK_MAX, E.SUAN_THK_MAX)) / 2 || '[' ||
       DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MIN, E.SUAN_THK_MIN) || ',' ||
       DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MAX, E.SUAN_THK_MAX) || ']' || ';' || '[' ||
       DECODE(E.SUAN_WTH_MIN, NULL, E.C_ORD_WTH_MIN, E.SUAN_WTH_MIN) || ',' ||
       DECODE(E.SUAN_WTH_MAX, NULL, E.C_ORD_WTH_MAX, E.SUAN_WTH_MAX) || ']'   GCH --酸轧公差带
                              ,L.C_ORD_INDIA JQU --卷曲内经
                             ,L.HARSHNESS       --粗燥度
                             ,L.APPLICATION   --用途
                             ,L.L_BMD   GM    --光面、麻面
                              -- ,L.MK_CONTENT       --订单备注
                            ,L.OIL_DEF       --涂油代码
                             , K1.DEL_TOL_WTH_MIN, K1.DEL_TOL_WTH_MAX--宽度公差
                              --  ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.SM_CD=L.ORD_USE_ALIAS) USEAGE_CD  --用途
                             , PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP ) BAO  --包装方式         
 FROM   C_TBF03_SPEC_MILL A  
 ,C_TBK02_COIL_COMM B
 ,TBE02_ORD_PRC   E
 ,C_TBL02_COIL_COMM H
 ,TBA01_ORD_LINE  L
 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T) T1
 ,(SELECT   SM_CD, SM_CFNM FROM TBZ00_COMMCD  WHERE LG_CD = 'A01012') T2
 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T) T3
 ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
 FROM TBB01_ORD_INGR
 WHERE DSN_KIND = '1') K,(SELECT DISTINCT ORD_NO, ORD_SEQ,DEL_TOL_WTH_MIN, DEL_TOL_WTH_MAX
                                FROM TBB01_ORD_DEL
                                WHERE DSN_KIND = '4') K1
 WHERE  A.ORD_NO           = E.ORD_NO(+)
 AND A.ORD_SEQ          = E.ORD_SEQ(+) 
 AND A.ORD_NO           = K.ORD_NO(+)
 AND A.ORD_SEQ          = K.ORD_SEQ(+)
  AND A.ORD_NO           = K1.ORD_NO(+)
 AND A.ORD_SEQ          = K1.ORD_SEQ(+)
 AND A.ORD_NO           =L.ORD_NO(+)
 AND A.ORD_SEQ         = L.ORD_SEQ(+)
 AND A.COIL_NO          =  B.COIL_NO(+)
 AND B.CUST_CD          =  T1.SM_CD(+)  
 AND E.ORDCUST_CD       =  T3.SM_CD(+)
 AND L.DLIV_TP          =  T2.SM_CD(+)  
 AND A.C_COIL_NO      =  H.COIL_NO(+)
 AND A.COIL_NO = B.COIL_NO(+)
 AND A.STATUS_CD NOT LIKE 'R'
 --AND A.ROLL_MANA_NO  >= ? ||'%' AND A.ROLL_MANA_NO <= ?||'%'
 AND SUBSTR(A.REG_DTIME,1,8)    BETWEEN ? AND ?
 AND NVL(H.MILL_DTIME,'000000')  BETWEEN ?||'000000' AND ?||'999999'
 and a.ord_no like ?||'%'
 and a.ord_seq like ?||'%'

		 ]]>
	</query>
<query id="UIK020060_08.SELECT" desc="无时间查询"> 
		<![CDATA[
							SELECT
							  ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO,A.ROLL_COIL_SEQ )  ROWSEQ    
							 ,A.ROLL_COIL_SEQ SEQ --轧辊内顺序
							 ,A.STL_GRD                                        --热轧牌号 
							 ,C_PKG_UIM.GET_STDDATESTR(B.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME                               --入库时间
							 ,B.COIL_THK                                                  --热卷厚度
							 ,B.COIL_INDIA                                                  --热卷内径
							 ,B.COIL_OUTDIA                                                  --热卷外径
							 ,B.ORD_FL                                                         --订单区分
							 ,B.COIL_WTH                                                 --热卷宽度
							 ,B.COIL_LEN                                                 --热卷长度
							 ,B.ACT_WGT COIL_WGT                                         --热卷重量 
			               ,E.ORD_THK H_ORD_THK                                        --热轧订单厚度
			               ,E.ORD_WTH H_ORD_WTH                                        --热轧订单宽度
			               ,E.ORD_LEN H_ORD_LEN                                        --热轧订单长度
			               ,E.ORD_INDIA H_ORD_INDIA                                    --热轧订单内径
			               ,E.ORD_OUTDIA H_ORD_OUTDIA                                  --热轧订单外径
			               ,B.CUR_LOAD_LOC
										 ,E.C_ORD_THK ORD_THK                                         --成品订单厚度
			               ,E.C_ORD_WTH ORD_WTH                                         --成品订单宽度
			               ,E.ORD_UNIT_WGT ORD_WGT                                      --成品订单重量
			               ,E.C_SPEC_STL_GRD                                            --冷轧牌号
			               ,E.C_ORD_INDIA INSTR_COIL_INDIA                              --订单内径
			               ,E.C_ORD_OUTDIA INSTR_COIL_OUTDIA                            --订单外径
			               ,E.C_ORD_LEN INSTR_COIL_LEN                                  --订单长度
			               ,XB_PACKAGE.GF_COMNNAME_FIND('H02001' , B.CRK_CD1)||CASE WHEN B.CRK_CD2 IS NOT NULL THEN '+' ELSE ' ' END ||XB_PACKAGE.GF_COMNNAME_FIND('H02001' , B.CRK_CD2)  COIL_CRK --缺陷
			                --20130111
			               ,A.COIL_NO                                                   --热卷号
			               ,A.C_COIL_NO OLD_SAMPL_NO                                    --实绩冷卷号
			               ,(select E.C_EXTSHAPE_REQ from TBE02_ORD_PRC E WHERE E.ORD_SEQ = A.ORD_SEQ AND E.ORD_NO = A.ORD_NO ) C_EXTSHAPE_REQ                --表面要求
			               ,(select E.ACID_PROD_PATH from TBE02_ORD_PRC E WHERE E.ORD_SEQ = A.ORD_SEQ AND E.ORD_NO = A.ORD_NO ) ACID_PROD_PATH                  --工艺流程
			               -- ,SUBSTR(A.SLAB_NO,1,10)                          CHARGE_NO  --炉号
			               ,T2.SM_CFNM                                      BZ   --发货方式
			               ,T3.SM_CFNM ORDCUST_CD              --发货单位
			               ,T1.SM_CFNM                          --订货单位
			               --,B.RCAL_CNT					--返修次数
       					   --,DECODE(NVL(B.RCAL_CNT,0),0,'正常酸洗','返修') RACLTYPE --酸洗类型
       						,DECODE(SUBSTR(b.OLD_SAMPL_NO, 1, 1), 'L', '返修', '正常酸洗') RACLTYPE,
       						NVL(b.RCAL_CNT, '0') + 1 RCAL_CNT
			               --,A.C_COIL_NO                                                     --酸轧卷号
			               ,CASE  WHEN (A.STATUS_CD = 'A' AND B.COIL_STAT = '2' )    THEN '轧制作业待机'
			               WHEN (A.STATUS_CD = 'E'                           )  THEN '轧制吊销'
			               WHEN (A.STATUS_CD = 'B'                           )  THEN '上料完成'
			               WHEN (A.STATUS_CD = 'C')                            THEN '轧制进行'
			               WHEN (A.STATUS_CD = 'D' AND H.MISSNO_CLF_CD is null) THEN '轧制完成'
			               WHEN (A.STATUS_CD = 'D' AND H.MISSNO_CLF_CD =  '1')  THEN '轧废'
			               ELSE ''                                      END    STATUS_CD
			               ,A.ROLL_MANA_NO                                   --轧制单元号
			               ,A.ORD_NO                         --合同号
			               ,A.ORD_SEQ                      --订单号
			               ,H.CUR_LOAD_LOC  C_COIL_LOAD_LOC                    --酸轧卷位置
			               ,H.ACT_WGT                                --酸轧卷实际重量
			               ,B.CUR_LOAD_LOC  H_COIL_LOAD_LOC     --热轧卷位置
			               ,DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN     --客户特殊要求
			               ,C_PKG_UIM.GET_STDTIMESTR(H.MILL_DTIME) MILL_DTIME               --轧制时间
			               ,DECODE(B.INGR_DEC_GRD,'0','待判定','1','合格','2','不合格','') INGR_DEC_GRD    --成份等级 
                           ,A.PRODNM_CD||'/'||L.C_EXTSHAPE_REQ||'/'||SUBSTR(PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP ),0,1)||'/大于'||L.PROD_WGT_MIN||'小于'||L.PROD_WGT_MAX||'/'||PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP )||'/厚度('||E.C_ORD_THK_MIN||'~'||E.C_ORD_THK_MAX||')/宽度('||E.C_ORD_WTH_MIN||'~'||E.C_ORD_WTH_MAX||')/内径('||L.C_ORD_INDIA||')'   JISHUYAOQIU
                             ,CASE WHEN SUBSTR(B.ORD_NO  , 0,2)= '42' THEN '过度材' ELSE '订单材' END ||DECODE(L.EDGE_PROC_YN , 'Y' , '切边' , '不切边')   ORD_RMK
                             ,L.PROD_LINE
                             ,  (DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MIN, E.SUAN_THK_MIN) +
       DECODE(E.SUAN_THK_MAX, NULL, E.C_ORD_THK_MAX, E.SUAN_THK_MAX)) / 2 || '[' ||
       DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MIN, E.SUAN_THK_MIN) || ',' ||
       DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MAX, E.SUAN_THK_MAX) || ']' || ';' || '[' ||
       DECODE(E.SUAN_WTH_MIN, NULL, E.C_ORD_WTH_MIN, E.SUAN_WTH_MIN) || ',' ||
       DECODE(E.SUAN_WTH_MAX, NULL, E.C_ORD_WTH_MAX, E.SUAN_WTH_MAX) || ']'   GCH --酸轧公差带
                              ,L.C_ORD_INDIA JQU --卷曲内经
                             ,L.HARSHNESS       --粗燥度
                             ,L.APPLICATION   --用途
                             ,L.L_BMD   GM    --光面、麻面
                             ,L.MK_CONTENT       --订单备注
                            ,L.OIL_DEF       --涂油代码
                              --  ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.SM_CD=L.ORD_USE_ALIAS) USEAGE_CD  --用途
                             , PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP ) BAO  --包装方式
							 FROM   S_TBF03_SPEC_MILL A  
							 ,C_TBK02_COIL_COMM B
							 ,TBE02_ORD_PRC   E
							 ,C_TBL02_COIL_COMM H
							 ,TBA01_ORD_LINE  L
							 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T) T1
							 ,(SELECT   SM_CD, SM_CFNM FROM TBZ00_COMMCD  WHERE LG_CD = 'A01012') T2
							 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T) T3
							 ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
							 FROM TBB01_ORD_INGR
							 WHERE DSN_KIND = '1') K
							 WHERE  A.ORD_NO           = E.ORD_NO(+)
							 AND A.ORD_SEQ          = E.ORD_SEQ(+) 
							 AND A.ORD_NO           = K.ORD_NO(+)
							 AND A.ORD_SEQ          = K.ORD_SEQ(+)
							 AND A.ORD_NO           =L.ORD_NO(+)
							 AND A.ORD_SEQ         = L.ORD_SEQ(+)
							 AND A.COIL_NO          =  B.COIL_NO(+)
							 AND B.CUST_CD          =  T1.SM_CD(+)  
							 AND E.ORDCUST_CD       =  T3.SM_CD(+)
							 AND L.DLIV_TP          =  T2.SM_CD(+)  
							 AND A.C_COIL_NO      =  H.COIL_NO(+)
							 AND A.COIL_NO = B.COIL_NO(+)
							 AND A.STATUS_CD NOT LIKE 'R'
							 AND A.ROLL_MANA_NO  >= ?  AND A.ROLL_MANA_NO <= ? 
							 --AND SUBSTR(A.REG_DTIME,1,8)    BETWEEN ? AND ?
							 AND NVL(H.MILL_DTIME,'000000')  BETWEEN ?||'000000' AND ?||'999999'
							 and a.ord_no like ?||'%'
							 and a.ord_seq like ?||'%'
		 ]]>
	</query>

	<query id="UIK020060_09.SELECT" desc="有时间查询">
		<![CDATA[
		SELECT    ROW_NUMBER() OVER (ORDER BY A.ROLL_MANA_NO,A.ROLL_COIL_SEQ )  ROWSEQ     
							 ,A.ROLL_COIL_SEQ SEQ --轧辊内顺序
							 ,A.STL_GRD                                        --热轧牌号 
							 ,C_PKG_UIM.GET_STDDATESTR(B.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME                               --入库时间
							 ,B.COIL_THK                                                  --热卷厚度
							 ,B.COIL_INDIA                                                  --热卷内径
							 ,B.COIL_OUTDIA                                                  --热卷外径
							 ,B.ORD_FL                                                         --订单区分
							 ,B.COIL_WTH                                                 --热卷宽度
							 ,B.COIL_LEN                                                 --热卷长度
							 ,B.ACT_WGT COIL_WGT                                         --热卷重量 
               ,E.ORD_THK H_ORD_THK                                        --热轧订单厚度
               ,E.ORD_WTH H_ORD_WTH                                        --热轧订单宽度
               ,E.ORD_LEN H_ORD_LEN                                        --热轧订单长度
               ,E.ORD_INDIA H_ORD_INDIA                                    --热轧订单内径
               ,E.ORD_OUTDIA H_ORD_OUTDIA                                  --热轧订单外径
               ,B.CUR_LOAD_LOC
			   ,E.C_ORD_THK ORD_THK                                         --成品订单厚度
               ,E.C_ORD_WTH ORD_WTH                                         --成品订单宽度
               ,E.ORD_UNIT_WGT ORD_WGT                                      --成品订单重量
               ,E.C_SPEC_STL_GRD                                            --冷轧牌号
               ,E.C_ORD_INDIA INSTR_COIL_INDIA                              --订单内径
               ,E.C_ORD_OUTDIA INSTR_COIL_OUTDIA                            --订单外径
               ,E.C_ORD_LEN INSTR_COIL_LEN                                  --订单长度
               ,XB_PACKAGE.GF_COMNNAME_FIND('H02001' , B.CRK_CD1)||CASE WHEN B.CRK_CD2 IS NOT NULL THEN '+' ELSE ' ' END ||XB_PACKAGE.GF_COMNNAME_FIND('H02001' , B.CRK_CD2)  COIL_CRK --缺陷
               --20130111
               ,A.COIL_NO                                                   --热卷号
               ,A.C_COIL_NO OLD_SAMPL_NO                                    --实绩冷卷号
               ,(select E.C_EXTSHAPE_REQ from TBE02_ORD_PRC E WHERE E.ORD_SEQ = A.ORD_SEQ AND E.ORD_NO = A.ORD_NO ) C_EXTSHAPE_REQ                --表面要求
               ,(select E.ACID_PROD_PATH from TBE02_ORD_PRC E WHERE E.ORD_SEQ = A.ORD_SEQ AND E.ORD_NO = A.ORD_NO ) ACID_PROD_PATH                  --工艺流程
               -- ,SUBSTR(A.SLAB_NO,1,10)                          CHARGE_NO  --炉号
               ,T2.SM_CFNM                                      BZ   --发货方式
               ,T3.SM_CFNM ORDCUST_CD              --发货单位
               ,T1.SM_CFNM                          --订货单位
               ,DECODE(SUBSTR(b.OLD_SAMPL_NO, 1, 1), 'L', '返修', '正常酸洗') RACLTYPE,
       						NVL(b.RCAL_CNT, '0') + 1 RCAL_CNT
               --,A.C_COIL_NO                                                     --酸轧卷号
               ,CASE  WHEN (A.STATUS_CD = 'A' AND B.COIL_STAT = '2' )    THEN '轧制作业待机'
               WHEN (A.STATUS_CD = 'E'                           )  THEN '轧制吊销'
               WHEN (A.STATUS_CD = 'B'                           )  THEN '上料完成'
               WHEN (A.STATUS_CD = 'C')                            THEN '轧制进行'
               WHEN (A.STATUS_CD = 'D' AND H.MISSNO_CLF_CD is null) THEN '轧制完成'
               WHEN (A.STATUS_CD = 'D' AND H.MISSNO_CLF_CD =  '1')  THEN '轧废'
               ELSE ''                                      END    STATUS_CD
               ,A.ROLL_MANA_NO                                   --轧制单元号
               ,A.ORD_NO                         --合同号
               ,A.ORD_SEQ                      --订单号
               ,H.CUR_LOAD_LOC  C_COIL_LOAD_LOC                    --酸轧卷位置
               ,H.ACT_WGT                                --酸轧卷实际重量
               ,B.CUR_LOAD_LOC  H_COIL_LOAD_LOC     --热轧卷位置
               ,DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN     --客户特殊要求
               ,C_PKG_UIM.GET_STDTIMESTR(H.MILL_DTIME) MILL_DTIME               --轧制时间
               ,DECODE(B.INGR_DEC_GRD,'0','待判定','1','合格','2','不合格','') INGR_DEC_GRD    --成份等级 
               ,A.PRODNM_CD||'/'||L.C_EXTSHAPE_REQ||'/'||SUBSTR(PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP ),0,1)||'/大于'||L.PROD_WGT_MIN||'小于'||L.PROD_WGT_MAX||'/'||PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP )||'/厚度('||E.C_ORD_THK_MIN||'~'||E.C_ORD_THK_MAX||')/宽度('||E.C_ORD_WTH_MIN||'~'||E.C_ORD_WTH_MAX||')/内径('||L.C_ORD_INDIA||')'   JISHUYAOQIU
               ,CASE WHEN SUBSTR(B.ORD_NO  , 0,2)= '42' THEN '过度材' ELSE '订单材' END ||DECODE(L.EDGE_PROC_YN , NULL , '不切边' , '切边')   ORD_RMK
               ,L.PROD_LINE  
               ,  (DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MIN, E.SUAN_THK_MIN) +
       DECODE(E.SUAN_THK_MAX, NULL, E.C_ORD_THK_MAX, E.SUAN_THK_MAX)) / 2 || '[' ||
       DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MIN, E.SUAN_THK_MIN) || ',' ||
       DECODE(E.SUAN_THK_MIN, NULL, E.C_ORD_THK_MAX, E.SUAN_THK_MAX) || ']' || ';' || '[' ||
       DECODE(E.SUAN_WTH_MIN, NULL, E.C_ORD_WTH_MIN, E.SUAN_WTH_MIN) || ',' ||
       DECODE(E.SUAN_WTH_MAX, NULL, E.C_ORD_WTH_MAX, E.SUAN_WTH_MAX) || ']'   GCH --酸轧公差带
                              ,L.C_ORD_INDIA JQU --卷曲内经
                             ,L.HARSHNESS       --粗燥度
                             ,L.APPLICATION   --用途
                             ,L.L_BMD   GM    --光面、麻面
                             ,L.MK_CONTENT       --订单备注
                            ,L.OIL_DEF       --涂油代码
                              --  ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.SM_CD=L.ORD_USE_ALIAS) USEAGE_CD  --用途
                             , PKG_QUALITY_COMM.FZ00_COMM('A01010' ,L.PAKMTH_TP ) BAO  --包装方式         
 FROM   S_TBF03_SPEC_MILL A  
 ,C_TBK02_COIL_COMM B
 ,TBE02_ORD_PRC   E
 ,C_TBL02_COIL_COMM H
 ,TBA01_ORD_LINE  L
 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T) T1
 ,(SELECT   SM_CD, SM_CFNM FROM TBZ00_COMMCD  WHERE LG_CD = 'A01012') T2
 ,(SELECT T.CUST_CD SM_CD,T.CUST_NM SM_CFNM FROM TBZ00_CUSTOMER T) T3
 ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
 FROM TBB01_ORD_INGR
 WHERE DSN_KIND = '1') K
 WHERE  A.ORD_NO           = E.ORD_NO(+)
 AND A.ORD_SEQ          = E.ORD_SEQ(+) 
 AND A.ORD_NO           = K.ORD_NO(+)
 AND A.ORD_SEQ          = K.ORD_SEQ(+)
 AND A.ORD_NO           =L.ORD_NO(+)
 AND A.ORD_SEQ         = L.ORD_SEQ(+)
 AND A.COIL_NO          =  B.COIL_NO(+)
 AND B.CUST_CD          =  T1.SM_CD(+)  
 AND E.ORDCUST_CD       =  T3.SM_CD(+)
 AND L.DLIV_TP          =  T2.SM_CD(+)  
 AND A.C_COIL_NO      =  H.COIL_NO(+)
 AND A.COIL_NO = B.COIL_NO(+)
 AND A.STATUS_CD NOT LIKE 'R'
 --AND A.ROLL_MANA_NO  >= ? ||'%' AND A.ROLL_MANA_NO <= ?||'%'
 AND SUBSTR(A.REG_DTIME,1,8)    BETWEEN ? AND ?
 AND NVL(H.MILL_DTIME,'000000')  BETWEEN ?||'000000' AND ?||'999999'
 and a.ord_no like ?||'%'
 and a.ord_seq like ?||'%'

		 ]]>
	</query>



</queryMap>