XinYu_LZMES/.svn/pristine/00/000869785e4f4d9748ab7e513de24ea7750466e4.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="总貌图">
	<query id="UIM050010_01.SELECT"  desc="查询酸轧实时生产钢卷">
	 <![CDATA[
		SELECT WKNAME,
		       WKGROUP,
		       COIL_NO,
		       SPEC_STL_GRD,
		       COIL_SIZE,
		       COIL_WGT,
		       '订单号' ORDNAME,
		       ORD_NO,
		       BEGINTIME,
		       FLOOR(MILLMIN) || CHR(39) || ROUND((MILLMIN - FLOOR(MILLMIN)) * 60) || '"' MILLTIME
		  FROM (SELECT '酸轧机组' WKNAME,
		               '班次,班组' WKGROUP,
		               T.C_COIL_NO COIL_NO,
		               T.SPEC_STL_GRD,
		               TO_CHAR(T.COIL_THK, 'FM990.099') || '*' || T.COIL_WTH COIL_SIZE,
		               T.COIL_WGT,
		               T.ORD_NO || '-' || T.ORD_SEQ ORD_NO,
		               TO_CHAR(TO_DATE(NVL(T.MOD_DTIME,
		                                   TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')),
		                               'YYYYMMDDHH24MISS'),
		                       'YYYY-MM-DD HH24:MI:SS') BEGINTIME,
		               (SYSDATE - TO_DATE(NVL(T.MOD_DTIME,
		                                      TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')),
		                                  'YYYYMMDDHH24MISS')) * 24 * 60 MILLMIN
		          FROM C_TBF03_SPEC_MILL T
		         WHERE T.STATUS_CD = 'C'
		         ORDER BY T.ROLL_MANA_NO, T.COIL_EDT_SEQ)
		 WHERE ROWNUM = 1
        ]]>
	</query>
	<query id="UIM050010_02.SELECT"  desc="查询连退实时生产钢卷">
	 <![CDATA[
		SELECT WKNAME,
		       WKGROUP,
		       COIL_NO,
		       SPEC_STL_GRD,
		       COIL_SIZE,
		       COIL_WGT,
		       '订单号' ORDNAME,
		       ORD_NO,
		       BEGINTIME,
		       FLOOR(MILLMIN) || CHR(39) || ROUND((MILLMIN - FLOOR(MILLMIN)) * 60) || '"' MILLTIME
		  FROM (SELECT '连退机组' WKNAME,
		               '班次,班组' WKGROUP,
		               T.L_COIL_NO COIL_NO,
		               T.SPEC_STL_GRD,
		               TO_CHAR(T.COIL_THK, 'FM990.099') || '*' || T.COIL_WTH COIL_SIZE,
		               T.COIL_WGT,
		               T.ORD_NO || '-' || T.ORD_SEQ ORD_NO,
		               TO_CHAR(TO_DATE(NVL(T.MOD_DTIME,
		                                   TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')),
		                               'YYYYMMDDHH24MISS'),
		                       'YYYY-MM-DD HH24:MI:SS') BEGINTIME,
		               (SYSDATE - TO_DATE(NVL(T.MOD_DTIME,
		                                      TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')),
                                      'YYYYMMDDHH24MISS')) * 24 * 60 MILLMIN
              FROM L_TBF03_SPEC_MILL T
             WHERE T.STATUS_CD = 'C'
             ORDER BY T.CAL_NO, T.COIL_EDT_SEQ)
     	WHERE ROWNUM = 1
        ]]>
	</query>
	<query id="UIM050010_03.SELECT"  desc="查询重卷实时生产钢卷">
	 <![CDATA[
		SELECT WKNAME,
		       WKGROUP,
		       COIL_NO,
		       SPEC_STL_GRD,
		       COIL_SIZE,
		       COIL_WGT,
		       '订单号' ORDNAME,
		       ORD_NO,
		       BEGINTIME,
		       FLOOR(MILLMIN) || CHR(39) || ROUND((MILLMIN - FLOOR(MILLMIN)) * 60) || '"' MILLTIME
		  FROM (SELECT '重卷机组' WKNAME,
		               '班次,班组' WKGROUP,
		               T.R_COIL_NO COIL_NO,
		               C.SPEC_STL_GRD,
		               TO_CHAR(C.COIL_THK, 'FM990.099') || '*' || C.COIL_WTH COIL_SIZE,
		               C.ACT_WGT COIL_WGT,
		               T.ORD_NO || '-' || T.ORD_SEQ ORD_NO,
		               TO_CHAR(TO_DATE(NVL(T.MOD_DTIME,
		                                   TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')),
		                               'YYYYMMDDHH24MISS'),
		                       'YYYY-MM-DD HH24:MI:SS') BEGINTIME,
		               (SYSDATE - TO_DATE(NVL(T.MOD_DTIME,
		                                      TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')),
                                      'YYYYMMDDHH24MISS')) * 24 * 60 MILLMIN
              FROM L_TBF03_SPEC_REEL T,C_TBC02_COIL_COMM C
             WHERE T.C_COIL_NO = C.OLD_SAMPL_NO
               AND T.STATUS_CD = 'C'
             ORDER BY T.COIL_EDT_SEQ)
     	WHERE ROWNUM = 1
        ]]>
	</query>
	<query id="UIM050010_04.SELECT"  desc="查询酸轧实时生产钢卷">
	 <![CDATA[
		SELECT T.COIL_NO,
		       TO_CHAR(TO_DATE(NVL(T.MOD_DTIME,
		                           TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')),
		                       'YYYYMMDDHH24MISS'),
		               'YYYY-MM-DD HH24:MI:SS') BEGIN_TIME,
		       T.SPEC_STL_GRD,
		       T.COIL_THK THK,
		       T.COIL_WTH WTH,
		       T.COIL_WGT WGT,
		       T.ORD_NO,
		       T.ORD_SEQ,
		       T.ORD_THK,
		       T.ORD_WTH,
		       T.C_COIL_NO EXIT_COIL_NO
		  FROM C_TBF03_SPEC_MILL T
		 WHERE T.STATUS_CD = 'C'
		 ORDER BY T.ROLL_MANA_NO, T.COIL_EDT_SEQ
        ]]>
	</query>
	<query id="UIM050010_05.SELECT"  desc="查询连退实时生产钢卷">
	 <![CDATA[
		SELECT T.C_COIL_NO COIL_NO,
		       TO_CHAR(TO_DATE(NVL(T.MOD_DTIME,
		                           TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')),
		                       'YYYYMMDDHH24MISS'),
		               'YYYY-MM-DD HH24:MI:SS') BEGIN_TIME,
		       T.SPEC_STL_GRD,
		       T.COIL_THK THK,
		       T.COIL_WTH WTH,
		       T.COIL_WGT WGT,
		       T.ORD_NO,
		       T.ORD_SEQ,
		       T.ORD_THK,
		       T.ORD_WTH,
		       T.L_COIL_NO EXIT_COIL_NO
		  FROM L_TBF03_SPEC_MILL T
		 WHERE T.STATUS_CD = 'C'
		 ORDER BY T.CAL_NO, T.COIL_EDT_SEQ
        ]]>
	</query>
	<query id="UIM050010_06.SELECT"  desc="查询重卷实时生产钢卷">
	 <![CDATA[
		SELECT T.C_COIL_NO COIL_NO,
		       TO_CHAR(TO_DATE(NVL(T.MOD_DTIME,
		                           TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')),
		                       'YYYYMMDDHH24MISS'),
		               'YYYY-MM-DD HH24:MI:SS') BEGIN_TIME,
		       C.SPEC_STL_GRD,
		       C.COIL_THK THK,
		       C.COIL_WTH WTH,
		       C.ACT_WGT WGT,
		       T.ORD_NO,
		       T.ORD_SEQ,
		       C.INSTR_COIL_THK ORD_THK,
		       C.INSTR_COIL_WTH ORD_WTH,
		       T.R_COIL_NO EXIT_COIL_NO
		              FROM L_TBF03_SPEC_REEL T,C_TBC02_COIL_COMM C
		             WHERE T.C_COIL_NO = C.OLD_SAMPL_NO
		               AND T.STATUS_CD = 'C'
		             ORDER BY T.COIL_EDT_SEQ
        ]]>
	</query>
</queryMap>