XinYu_LZMES/.svn/pristine/b6/b677f718c35d46b7c380fdb68334581204971517.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="入库待机钢卷查询">
	<query id="UIN063000_01.Select"  desc="无时间查询"> 
		<![CDATA[
		     
select substr(A.OLD_SAMPL_NO, 1, 10) SPM_NO,
       XB_PACKAGE.GF_COMNNAME_FIND('A01004', c.PRD_TY) PRD_TY, -- 产品类型
       A.OLD_SAMPL_NO,
       A.ORD_NO,
       A.ORD_SEQ,
       decode(A.MILL_SHIFT, '0', '常白班', '1', '早', '2','中', '3', '晚','') MILL_SHIFT,
       decode(A.MILL_GROUP, '1', '甲', '2', '乙', '3','丙', '4', '丁','') MILL_GROUP,
       E.CHARING_DTIME,
       round((select TO_DATE(NVL(A.MILL_DTIME, A.COIL_END_DTIME),
                            'YYYY-MM-DD HH24:MI:SS') -
                    TO_DATE(E.CHARING_DTIME, 'YYYY-MM-DD HH24:MI:SS')
               from dual)*24*60,
             2) ZZSJ,
       A.ORG_ORD_NO,
       A.ORG_ORD_SEQ,
       (select CUST_NM
          FROM TBZ00_CUSTOMER
         WHERE CUST_CD =
               (SELECT CUST_CD FROM TBA01_ORD_COMM WHERE ORD_NO = A.ORD_NO)
           and REC_TP = '01') CUST_NM, --合同单位
       C.DEL_TO_DATE, --交货期
       substr(a.SLAB_NO, 1, 10) CHARGE_NO,
       A.SPEC_STL_GRD,
       D.SLAB_THK,
       D.SLAB_WTH,
       D.SLAB_LEN,
       D.SLAB_STOCK_ENT_DTIME, --来料时间
       A.MILL_DTIME,
       DECODE(B.WKSHIFT, '1', '早', '2', '中', '3', '晚', null) WKSHIFT,
       DECODE(B.WKGROUP, 'A', '甲', 'B', '乙', 'C', '丙', 'D', '丁', null) WKGROUP,
       XB_PACKAGE.GF_COMNNAME_FIND('E01002', A.CUR_PROG_CD) COIL_STAT,
       B.WK_EMP_USE_NO,
       B.WK_EMP_USE_DTIME,
       A.YARD_ENTRY_REG,
       A.YARD_ENTRY_USE_TIME,
       A.COIL_THK,
       A.COIL_WTH,
       A.INSTR_COIL_THK,
       A.INSTR_COIL_WTH,
       TO_CHAR(A.ACT_WGT / 1000) ACT_WGT,
       nvl(d.WEIGHT_WGT,d.SLAB_WGT/1000) ENT_COIL_WGT,
       a.CAL_WGT,
       A.CUR_LOAD_LOC 
  from tbh02_coil_comm   a,
       tbh02_mill_result b,
       tbe02_ord_prc     c,
       TBG02_SLAB_COMM   d,
       TBH02_REHEATFUR   E
 where a.COIL_NO = b.COIL_NO(+)
   AND A.ORD_NO = C.ORD_NO(+)
   AND A.ORD_SEQ = C.ORD_SEQ(+)
   and A.SLAB_NO = D.SLAB_NO
   AND A.COIL_NO = E.COIL_NO(+)
   AND SUBSTR(A.MILL_DTIME, 1, 12) >= ?
   AND SUBSTR(A.MILL_DTIME, 1, 12) <= ?
   AND A.OLD_SAMPL_NO LIKE ? || '%'
   AND B.MISSNO_CLF_CD IS NULL
 order by a.MILL_DTIME
		 ]]>
	</query>
		
</queryMap>