XinYu_LZMES/.svn/pristine/8c/8c2337e39c8aadbf6eca7ecfacc13ed2177e2cef.svn-base

<?xml version="1.0" encoding="UTF-8"?>
<queryMap desc="成品库库存数据查询">
	<query id="UIM010232_01.SELECT"  desc="成品库库存数据查询">
		<![CDATA[
		SELECT A.OLD_SAMPL_NO
       --XB_PACKAGE.GF_COMNNAME_FIND('A01004' , A.PRODNM_CD)  PRODNM_CD 
      ,
       A.SPEC_STL_GRD,
       (SELECT T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'E01010'
           AND T.SM_CD = A.NONORD_CAUSE_CD) NONORD_CAUSE_CD
       
      ,A.COIL_INDIA,
       A.COIL_THK,
       A.COIL_WTH,
       A.INSTR_COIL_THK,
       A.INSTR_COIL_WTH,
       A.ACT_WGT,
       A.DCS_THK,
       A.DCS_WTH,
       A.FB_YN,
       A.FB_REASON,
       A.DEFECTIVE,
       DECODE(A.ORD_FL, '1', '订单材', '2', '余材', '', '未判') ORD_FL,
       A.ORD_NO,
       A.ORD_SEQ,
       L.YCSCCZYJ,
       L.YCJSCZYJ,
       M.YC_MEMO
  	   ,M.YC_GSDW
  		,ROUND(TO_NUMBER(SYSDATE -
              TO_DATE(A.MILL_DTIME, 'YYYY-MM-DD HH24:MI:SS')) * 24) ZKSJ,
       A.CUR_LOAD_LOC,
       DECODE(A.TOT_DEC_GRD,
              '1',
              '合格',
              '2',
              '不合格',
              '3',
              '次品',
              '4',
              '废品') TOT_DEC_GRD,
       DECODE(A.INGR_DEC_GRD,
              '0',
              '综合判定取消',
              '1',
              '合格',
              '2',
              '不合格') INGR_DEC_GRD,
       DECODE(A.MATLQLTY_DEC_GRD,
              '0',
              '无性能要求',
              '1',
              '合格',
              '2',
              '不合格') MATRL_END_CAUSE_CD,
       DECODE(A.SIZE_DEC_RST, '1', '合格', '2', '不合格') SIZE_DEC_RST,
       DECODE(A.EXTSHAPE_DEC_GRD,
              '1',
              '合格',
              '2',
              '订单外合格',
              '3',
              '次品',
              '4',
              '废品',
              '待判') EXTSHAPE_DEC_GRD,
       DECODE(A.WGT_DEC_RST, '1', '合格', '2', '不合格') WGT_DEC_RST,
       C_PKG_UIM.GET_STDDATESTR(A.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME,
       C_PKG_UIM.GET_STDTIMESTR(A.YARD_ENTRY_USE_TIME) YARD_ENTRY_USE_TIME,
       (SELECT USERNAME
          FROM CORE_APP_USER U
         WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG,
       DECODE(A.YARD_ENTRY_SHIFT,
              '0',
              '常白班',
              '1',
              '早班',
              '2',
              '中班',
              '3',
              '晚班') YARD_ENTRY_SHIFT,
       DECODE(A.YARD_ENTRY_GROUP,
              '0',
              '常白班',
              '1',
              '甲班',
              '2',
              '乙班',
              '3',
              '丙班',
              '4',
              '丁班') YARD_ENTRY_GROUP,
       SUBSTR(B.SLAB_NO, 0, 10) CHARGE_NO,
       (SELECT TBZ00_COMMCD.SM_CFNM
		FROM TBZ00_COMMCD
		WHERE TBZ00_COMMCD.SM_CD = J.DEST_PCD
		AND ROWNUM = 1) STATIONCODE, --到站
       (SELECT T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'A01012'
           AND T.SM_CD = C.DLIV_TP) DLIV_TP,
       (SELECT T.CUST_NM
          FROM TBZ00_CUSTOMER T
         WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD
       /*,DECODE(A.CUR_PROG_CD,'DRC','连退卷充当待机','DBA','重卷指示待机','DBB','重卷作业待机'
                      ,'DCA','包装指示待机','DCB','包装作业待机','DED','综合判定待机','DFA','发货指示待机'
                      ,'DFB','发货待机','CCA','连退作业指示待机','CCB','连退作业待机','CCC','连退卷取待机'
                      ) CUR_PROG_CD*/,
       (CASE
         WHEN XB_PACKAGE.GF_COMNNAME_FIND('E01002', A.CUR_PROG_CD) =
              '连退成品充当待机' AND a.DEFECTIVE = 'Y' then
          '二级库存'
         ELSE
          XB_PACKAGE.GF_COMNNAME_FIND('E01002', a.CUR_PROG_CD)
       END)
       
       CUR_PROG_CD,
       C_PKG_UIM.GET_STDDATESTR(C.ORD_DEVLMT_DATE) ORD_DEVLMT_DATE,
       E.SMP_SEND_DTIME,
       E.SMP_WORK_DTIME,
       TO_CHAR(TO_DATE(A.TOT_DEC_DTIME, 'YYYY-MM-DD HH24:MI:SS'),
               'YYYY-MM-DD HH24:MI:SS') QLTY_DCS_DTIME,
       E.SMP_INTO_DTIME,
       TO_CHAR(ROUND(((TO_DATE(E.SMP_SEND_DTIME, 'YYYY-MM-DD HH24:MI:SS') -
                     TO_DATE(A.MILL_DTIME, 'YYYY-MM-DD HH24:MI:SS')) *
                     86400) / 3600,
                     1)) GET_SEND_DTIME,
       TO_CHAR(ROUND(((TO_DATE(A.TOT_DEC_DTIME, 'YYYY-MM-DD HH24:MI:SS') -
                     TO_DATE(E.SMP_SEND_DTIME, 'YYYY-MM-DD HH24:MI:SS')) *
                     86400) / 3600,
                     1)) TO_YANG_DTIME,
       C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME,
       C.XSQY,
       TO_CHAR(TO_DATE(J.DLIV_DIR_DATE, 'YYYY-MM-DD'), 'YYYY-MM-DD') || '/' || '' AFFIRMTIME,
       C_PKG_UIM.GET_STDDATESTR(C.ORD_PLAN_DATA) ORD_PLAN_DATA,
       pkg_quality_comm.FZ00_COMM('A01010',A.PACKAGE_LEVEL) PACKAGE_LEVEL,
       DECODE(A.CAL_TYPE, '2', '返修', '3', '过渡', NULL) RCAL,
       A.ORG_ORD_NO,
       A.ORG_ORD_SEQ,
       A.BEF_STL_GRD,
       A.EXTSHAPE_QUALITY,
       F.CAL_NO,
       H.STL_GRD,
	   B.SLAB_DCS_DETAIL BPBZ,
       k.C_EXTSHAPE_REQ,
       C.TRTMTH_TP C_PRODNM_CD,
       K.MK_CONTENT,-----------订单注备
      -- A.PRODNM_CD,
/*  XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD1) || CASE
         WHEN A.CRK_CD2 IS NOT NULL THEN
          '+'
         ELSE
          ' '
       END || XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD2) COIL_CRK,*/
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD1) CRK_CD1,
       REGEXP_SUBSTR(A.CRK_CD1_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD1_TYPE,
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD2) CRK_CD2,
       REGEXP_SUBSTR(A.CRK_CD2_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD2_TYPE,
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD3) CRK_CD3,
       REGEXP_SUBSTR(A.CRK_CD3_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD3_TYPE,
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD4) CRK_CD4,
       REGEXP_SUBSTR(A.CRK_CD4_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD4_TYPE,
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD5) CRK_CD5,
       REGEXP_SUBSTR(A.CRK_CD5_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD5_TYPE
       ,TA.*
       ,K.ROLL_SURFACE_YN  --辊面要求
       ,K.ANNOITA_YN  --涂油要求
       ,A.OIL_TOP
       ,A.OIL_BOT
       ,C.C_ORD_INDIA
       ,(CASE WHEN A.ORD_FL = '2' THEN '' ELSE
         K.C_PRODNM_CD || '/' || C.C_EXTSHAPE_REQ || '/' ||
         SUBSTR(PKG_QUALITY_COMM.FZ00_COMM('A01010', C.PAKMTH_TP), 0, 1) ||
         '/大于' || C.PROD_WGT_MIN || '小于' || C.PROD_WGT_MAX || '/' ||
         PKG_QUALITY_COMM.FZ00_COMM('A01010', C.PAKMTH_TP) || '/厚度(' ||
         K.C_ORD_THK_MIN || '~' || K.C_ORD_THK_MAX || ')/宽度(' ||
         K.C_ORD_WTH_MIN || '~' || K.C_ORD_WTH_MAX || ')/内径(' ||
         C.C_ORD_INDIA || ')' END) JISHUYAOQIU
  FROM C_TBC02_COIL_COMM A,
       TBG02_SLAB_COMM B,
       TBA01_ORD_LINE C,
       TBA01_ORD_COMM D,
       TBJ01_DLIV_DIR J,
       TBB02_LOT_COM E,
       LZ_YCCZYJ	L,
       JB_YC		M,
       TBE02_ORD_PRC K,
       (SELECT CK.STL_GRD      STL_GRD,
               CK.SPEC_STL_GRD SPEC_STL_GRD,
               CT.C_COIL_NO    C_COIL_NO
          FROM C_TBK02_COIL_COMM CK, C_TBF03_SPEC_MILL CT
         WHERE CK.OLD_SAMPL_NO = CT.COIL_NO) H,
       (SELECT MAX(CAL_NO) CAL_NO, EXIT_COIL_NO
          FROM L_TBF03_SPEC_MILL
         GROUP BY EXIT_COIL_NO) F
         ,(SELECT T1.OLD_SAMPL_NO  OLDSAMPLNO,
         	      MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'YS000',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_YSREL --屈服强度REL   ReL
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'YS0.2',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_YSRP --屈服强度Rp0.2   Rp0.2
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'EL050',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_EL50 --伸长率A50  伸长率A50
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'EL080',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_EL80 --伸长率A50  伸长率A80
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'EL000',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_EL --伸长率A(非定标) 伸长率A
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2), 'TE', T2.QLTY_VAL_WK, NULL)) LC_TE --抗拉强度                            抗拉强度
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT09', T2.QLTY_VAL_WK, NULL)) LC_R --r值
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT20', T2.QLTY_VAL_WK, NULL)) LC_N --n值
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT19', T2.QLTY_VAL_WK, NULL)) LC_BH --烘烤硬化
       ,
       MAX(DECODE(T2.QLTY_CD, 'DC01', T2.QLTY_VAL_WK, NULL)) LC_TS --铁损  
      ,
       MAX(DECODE(T2.QLTY_CD, 'DC02', T2.QLTY_VAL_WK, NULL)) LC_CG -- 磁感
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT18', T2.QLTY_VAL_WK, NULL)) LC_TT18 -- 上表面粗糙度
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT26', T2.QLTY_VAL_WK, NULL)) LC_TT26 -- 下表面粗糙度
      ,
       ROUND(AVG(CASE WHEN SUBSTR(T4.QLTY_CD,1,2) = 'HD' THEN T4.QLTY_VAL_WK ELSE NULL END),1)  LC_YD  ---硬度

  FROM C_TBC02_COIL_COMM T1, TBB02_WORK_QLTY T2 , TBB01_SEQ_QLTY  T3  , TBB02_REWORK_QLTY T4
 WHERE T1.SMP_NO = T2.SMP_NO
   AND T1.SMP_CUT_LOC = T2.SMP_CUT_LOC
   AND T1.SMP_NO = T4.SMP_NO(+)
   AND T1.SMP_CUT_LOC = T4.SMP_CUT_LOC(+)
   AND T2.QLTY_CD     = T3.QLTY_CD
   AND T1.COIL_STAT='2'
   GROUP BY T1.OLD_SAMPL_NO  
   
     
         union all   --20221121 加入一体化上线之后的性能
         
         select T.OLD_SAMPL_NO LC_COIL_NO,
               
               MAX(DECODE(t2.phy_code_s || t3.phy_unit,
                          'A01ReL',
                          to_number(T2.VAL1),
                          NULL)) LC_YSREL, --屈服rel
               
               MAX(DECODE(t2.phy_code_s || t3.phy_unit,
                          'A01Rp0.2',
                          to_number(T2.VAL1),
                          NULL)) LC_YSRP, --屈服rp0.2
               
               MAX(DECODE(t2.phy_code_s || t3.phy_unit,
                          'A0650mm',
                          to_number(T2.VAL1),
                          NULL)) LC_EL50, --伸长A50
               MAX(DECODE(t2.phy_code_s || t3.phy_unit,
                          'A0680mm',
                          to_number(T2.VAL1),
                          NULL)) LC_EL80, --伸长A80
               MAX(DECODE(t2.phy_code_s || t3.phy_unit,
                          'A06',
                          to_number(T2.VAL1),
                          NULL)) LC_EL, --伸长A
               MAX(DECODE(t2.phy_code_s, 'A02', to_number(T2.VAL1), NULL)) LC_TE, --抗拉
               MAX(DECODE(t2.phy_code_s, 'A12', to_number(t2.val1), null)) LC_R, --塑性应变比(r90)
               MAX(DECODE(t2.phy_code_s, 'A09', to_number(t2.val1), null)) LC_N, --应变硬化指数(n90)
               MAX(DECODE(t2.phy_code_s, 'T01', to_number(t2.val1), null)) LC_TX, --铁损[P1.5/50，W/kg](原来的表TBB01_SEQ_QLTY是前面的名称，新表qcm_jhy_insp_physics只有铁损两个字)
               MAX(DECODE(t2.phy_code_s, 'T02', to_number(t2.val1), null)) LC_CG, --磁感[B5000,T](跟上面的一样，新表没有中括号里面的内容)
               to_number('') LC_BH, --老表中是烘烤硬化值(BH2)，新表没看到相关的数据
               MAX(DECODE(t2.phy_code_s, 'V01', to_number(t2.AVG_VAL), null)) LC_TT18, --上表面粗糙度
               MAX(DECODE(t2.phy_code_s, 'V02', to_number(t2.AVG_VAL), null)) LC_TT26, --下表面粗糙度
             
               MAX(DECODE(t2.phy_code_s, 'D01', to_number(T2.AVG_VAL), NULL)) YD_PJ --平均硬度
        
          from c_tbc02_coil_comm             t,
               qcm_jhy_sample_consign_d      t1,
               qcm_jhy_insp_physics          t2,
               qcm_jhy_sample_consign_d_item t3
         where t.SMP_NO = t1.inspection_lot
           and t1.specimen_no = t2.specimen_no
           and t2.specimen_no = t3.specimen_no
           and t2.seq = t3.seq
           AND T.COIL_STAT='2'
         GROUP BY T.OLD_SAMPL_NO
   
   ) TA
 WHERE '1' = '1'
   AND A.SLAB_NO = B.SLAB_NO(+)
   AND A.ORD_NO = C.ORD_NO(+)
   AND A.ORD_SEQ = C.ORD_SEQ(+)
   AND A.ORD_NO = D.ORD_NO(+)
   AND A.SMP_NO = E.SMP_NO(+)
   AND A.ORD_NO = K.ORD_NO(+)
   AND A.ORD_SEQ = K.ORD_SEQ(+)
   AND A.DLIV_DIRNO = J.DLIV_DIRNO(+)
   AND A.OLD_SAMPL_NO = F.EXIT_COIL_NO(+)
   AND A.OLD_SAMPL_NO = L.COIL_NO(+)
   AND A.OLD_SAMPL_NO = M.OLD_SAMPL_NO(+)
   AND A.COIL_STAT = '2'
   AND A.OLD_SAMPL_NO = TA.OLDSAMPLNO(+)
   AND NVL(A.EXTSHAPE_QUALITY,'NULLP') NOT IN('FP','CP')---屏蔽废次卷
   AND SUBSTR(A.OLD_SAMPL_NO, 1, 12) = H.C_COIL_NO(+)
   --AND A.CUR_PROG_CD  IN ('DFA'  ,'DFB')
   --AND A.PACKAGE_FL='1'
   AND A.OLD_SAMPL_NO || '&' LIKE '%' || ? || '%'
   AND A.SPEC_STL_GRD || '&' LIKE ? || '%'
   AND A.CUR_LOAD_LOC LIKE ? || '%'
   AND A.COIL_THK >= NVL(?, '000')
   AND A.COIL_THK <= NVL(?, '999')
   AND A.COIL_WTH >= NVL(?, '00000')
   AND A.COIL_WTH <= NVL(?, '99999')
   AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0)
   AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999)
   AND A.ORD_NO || '&' LIKE ? || '%'
   AND A.CUR_PROG_CD || '&' LIKE ? || '%'
   AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%'
   AND E.SMP_SEND_DTIME || '&' LIKE ? || '%'
   AND A.PRODNM_CD || '&' LIKE ? || '%'
   AND A.ORD_FL || '&' LIKE ? || '%'

		 ]]>
	</query>
	<query id="UIM010232_02.SELECT"  desc="成品库库存非计划数据查询">
		<![CDATA[
		SELECT A.OLD_SAMPL_NO
       --XB_PACKAGE.GF_COMNNAME_FIND('A01004' , A.PRODNM_CD)  PRODNM_CD 
      ,
       A.SPEC_STL_GRD,
       (SELECT T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'E01010'
           AND T.SM_CD = A.NONORD_CAUSE_CD) NONORD_CAUSE_CD
       
      ,A.COIL_INDIA,
       A.COIL_THK,
       A.COIL_WTH,
       A.INSTR_COIL_THK,
       A.INSTR_COIL_WTH,
       A.ACT_WGT,
       A.DCS_THK,
       A.DCS_WTH,
       A.FB_YN,
       A.DEFECTIVE,
       DECODE(A.ORD_FL, '1', '订单材', '2', '余材', '', '未判') ORD_FL,
       A.ORD_NO,
       A.ORD_SEQ,
       A.CUR_LOAD_LOC,
       DECODE(A.TOT_DEC_GRD,
              '1',
              '合格',
              '2',
              '不合格',
              '3',
              '次品',
              '4',
              '废品') TOT_DEC_GRD,
       DECODE(A.INGR_DEC_GRD,
              '0',
              '综合判定取消',
              '1',
              '合格',
              '2',
              '不合格') INGR_DEC_GRD,
       DECODE(A.MATLQLTY_DEC_GRD,
              '0',
              '无性能要求',
              '1',
              '合格',
              '2',
              '不合格') MATRL_END_CAUSE_CD,
       DECODE(A.SIZE_DEC_RST, '1', '合格', '2', '不合格') SIZE_DEC_RST,
       DECODE(A.EXTSHAPE_DEC_GRD,
              '1',
              '合格',
              '2',
              '订单外合格',
              '3',
              '次品',
              '4',
              '废品',
              '待判') EXTSHAPE_DEC_GRD,
       DECODE(A.WGT_DEC_RST, '1', '合格', '2', '不合格') WGT_DEC_RST,
       C_PKG_UIM.GET_STDDATESTR(A.YARD_ENTRY_DTIME) YARD_ENTRY_DTIME,
       C_PKG_UIM.GET_STDTIMESTR(A.YARD_ENTRY_USE_TIME) YARD_ENTRY_USE_TIME,
       (SELECT USERNAME
          FROM CORE_APP_USER U
         WHERE U.USERID = A.YARD_ENTRY_REG) YARD_ENTRY_REG,
       DECODE(A.YARD_ENTRY_SHIFT,
              '0',
              '常白班',
              '1',
              '早班',
              '2',
              '中班',
              '3',
              '晚班') YARD_ENTRY_SHIFT,
       DECODE(A.YARD_ENTRY_GROUP,
              '0',
              '常白班',
              '1',
              '甲班',
              '2',
              '乙班',
              '3',
              '丙班',
              '4',
              '丁班') YARD_ENTRY_GROUP,
       SUBSTR(B.SLAB_NO, 0, 10) CHARGE_NO,
        (SELECT TBZ00_COMMCD.SM_CFNM
		FROM TBZ00_COMMCD
		WHERE TBZ00_COMMCD.SM_CD = J.DEST_PCD
		AND ROWNUM = 1) STATIONCODE, --到站
       (SELECT T.SM_CFNM
          FROM TBZ00_COMMCD T
         WHERE T.LG_CD = 'A01012'
           AND T.SM_CD = C.DLIV_TP) DLIV_TP,
       (SELECT T.CUST_NM
          FROM TBZ00_CUSTOMER T
         WHERE T.CUST_CD = D.ORDCUST_CD) ORDCUST_CD
       /*,DECODE(A.CUR_PROG_CD,'DRC','连退卷充当待机','DBA','重卷指示待机','DBB','重卷作业待机'
                      ,'DCA','包装指示待机','DCB','包装作业待机','DED','综合判定待机','DFA','发货指示待机'
                      ,'DFB','发货待机','CCA','连退作业指示待机','CCB','连退作业待机','CCC','连退卷取待机'
                      ) CUR_PROG_CD*/,
       (CASE
         WHEN XB_PACKAGE.GF_COMNNAME_FIND('E01002', A.CUR_PROG_CD) =
              '连退成品充当待机' AND a.DEFECTIVE = 'Y' then
          '二级库存'
         ELSE
          XB_PACKAGE.GF_COMNNAME_FIND('E01002', a.CUR_PROG_CD)
       END)
       
       CUR_PROG_CD,
       C_PKG_UIM.GET_STDDATESTR(C.ORD_DEVLMT_DATE) ORD_DEVLMT_DATE,
       E.SMP_SEND_DTIME,
       E.SMP_WORK_DTIME,
       TO_CHAR(TO_DATE(A.TOT_DEC_DTIME, 'YYYY-MM-DD HH24:MI:SS'),
               'YYYY-MM-DD HH24:MI:SS') QLTY_DCS_DTIME,
       E.SMP_INTO_DTIME,
       TO_CHAR(ROUND(((TO_DATE(E.SMP_SEND_DTIME, 'YYYY-MM-DD HH24:MI:SS') -
                     TO_DATE(A.MILL_DTIME, 'YYYY-MM-DD HH24:MI:SS')) *
                     86400) / 3600,
                     1)) GET_SEND_DTIME,
       TO_CHAR(ROUND(((TO_DATE(A.TOT_DEC_DTIME, 'YYYY-MM-DD HH24:MI:SS') -
                     TO_DATE(E.SMP_SEND_DTIME, 'YYYY-MM-DD HH24:MI:SS')) *
                     86400) / 3600,
                     1)) TO_YANG_DTIME,
       C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME,
       C.XSQY,
       TO_CHAR(TO_DATE(J.DLIV_DIR_DATE, 'YYYY-MM-DD'), 'YYYY-MM-DD') || '/' || '' AFFIRMTIME,
       C_PKG_UIM.GET_STDDATESTR(C.ORD_PLAN_DATA) ORD_PLAN_DATA,
       DECODE(A.PACKAGE_LEVEL,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装',
              '5',
              '出口包装') PACKAGE_LEVEL,
       DECODE(A.CAL_TYPE, '2', '返修', '3', '过渡', NULL) RCAL,
       A.ORG_ORD_NO,
       A.ORG_ORD_SEQ,
       L.YCSCCZYJ,
       L.YCJSCZYJ
       ,M.YC_MEMO
  		,M.YC_GSDW
  		,ROUND(TO_NUMBER(SYSDATE -
              TO_DATE(A.MILL_DTIME, 'YYYY-MM-DD HH24:MI:SS')) * 24) ZKSJ,
       A.BEF_STL_GRD,
       A.EXTSHAPE_QUALITY,
       F.CAL_NO,
       H.STL_GRD,
       B.SLAB_DCS_DETAIL BPBZ,
       k.C_EXTSHAPE_REQ,
       C.TRTMTH_TP C_PRODNM_CD,
       K.MK_CONTENT,-----------订单注备
      -- A.PRODNM_CD,
/*  XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD1) || CASE
         WHEN A.CRK_CD2 IS NOT NULL THEN
          '+'
         ELSE
          ' '
       END || XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD2) COIL_CRK,*/
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD1) CRK_CD1,
       REGEXP_SUBSTR(A.CRK_CD1_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD1_TYPE,
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD2) CRK_CD2,
       REGEXP_SUBSTR(A.CRK_CD2_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD2_TYPE,
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD3) CRK_CD3,
       REGEXP_SUBSTR(A.CRK_CD3_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD3_TYPE,
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD4) CRK_CD4,
       REGEXP_SUBSTR(A.CRK_CD4_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD4_TYPE,
       XB_PACKAGE.GF_COMNNAME_FIND('B02001', A.CRK_CD5) CRK_CD5,
       REGEXP_SUBSTR(A.CRK_CD5_TYPE, '[【][A-Za-z0-9,-]+[】]$') CRK_CD5_TYPE
       ,TA.*
       ,K.ROLL_SURFACE_YN  --辊面要求
       ,K.ANNOITA_YN  --涂油要求
       ,A.OIL_TOP
       ,A.OIL_BOT
       ,C.C_ORD_INDIA
       ,(CASE WHEN A.ORD_FL = '2' THEN '' ELSE
         K.C_PRODNM_CD || '/' || C.C_EXTSHAPE_REQ || '/' ||
         SUBSTR(PKG_QUALITY_COMM.FZ00_COMM('A01010', C.PAKMTH_TP), 0, 1) ||
         '/大于' || C.PROD_WGT_MIN || '小于' || C.PROD_WGT_MAX || '/' ||
         PKG_QUALITY_COMM.FZ00_COMM('A01010', C.PAKMTH_TP) || '/厚度(' ||
         K.C_ORD_THK_MIN || '~' || K.C_ORD_THK_MAX || ')/宽度(' ||
         K.C_ORD_WTH_MIN || '~' || K.C_ORD_WTH_MAX || ')/内径(' ||
         C.C_ORD_INDIA || ')' END) JISHUYAOQIU
  FROM C_TBC02_COIL_COMM A,
       TBG02_SLAB_COMM B,
       TBA01_ORD_LINE C,
       TBA01_ORD_COMM D,
       TBJ01_DLIV_DIR J,
       TBB02_LOT_COM E,
       LZ_YCCZYJ	L,
       JB_YC		M,
       TBE02_ORD_PRC K,
       (SELECT CK.STL_GRD      STL_GRD,
               CK.SPEC_STL_GRD SPEC_STL_GRD,
               CT.C_COIL_NO    C_COIL_NO
          FROM C_TBK02_COIL_COMM CK, C_TBF03_SPEC_MILL CT
         WHERE CK.OLD_SAMPL_NO = CT.COIL_NO) H,
       (SELECT MAX(CAL_NO) CAL_NO, EXIT_COIL_NO
          FROM L_TBF03_SPEC_MILL
         GROUP BY EXIT_COIL_NO) F
         ,(SELECT T1.OLD_SAMPL_NO  OLDSAMPLNO,
         	      MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'YS000',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_YSREL --屈服强度REL   ReL
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'YS0.2',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_YSRP --屈服强度Rp0.2   Rp0.2
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'EL050',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_EL50 --伸长率A50  伸长率A50
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'EL080',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_EL80 --伸长率A50  伸长率A80
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2) || T3.MS_QLTY_RP,
                  'EL000',
                  T2.QLTY_VAL_WK,
                  NULL)) LC_EL --伸长率A(非定标) 伸长率A
      ,
       MAX(DECODE(SUBSTR(T2.QLTY_CD, 1, 2), 'TE', T2.QLTY_VAL_WK, NULL)) LC_TE --抗拉强度                            抗拉强度
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT09', T2.QLTY_VAL_WK, NULL)) LC_R --r值
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT20', T2.QLTY_VAL_WK, NULL)) LC_N --n值
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT19', T2.QLTY_VAL_WK, NULL)) LC_BH --烘烤硬化
       ,
       MAX(DECODE(T2.QLTY_CD, 'DC01', T2.QLTY_VAL_WK, NULL)) LC_TS --铁损  
      ,
       MAX(DECODE(T2.QLTY_CD, 'DC02', T2.QLTY_VAL_WK, NULL)) LC_CG -- 磁感
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT18', T2.QLTY_VAL_WK, NULL)) LC_TT18 -- 上表面粗糙度
      ,
       MAX(DECODE(T2.QLTY_CD, 'TT26', T2.QLTY_VAL_WK, NULL)) LC_TT26 -- 下表面粗糙度
      ,
       ROUND(AVG(CASE WHEN SUBSTR(T4.QLTY_CD,1,2) = 'HD' THEN T4.QLTY_VAL_WK ELSE NULL END),1)  LC_YD  ---硬度

  FROM C_TBC02_COIL_COMM T1, TBB02_WORK_QLTY T2 , TBB01_SEQ_QLTY  T3  , TBB02_REWORK_QLTY T4
 WHERE T1.SMP_NO = T2.SMP_NO
   AND T1.SMP_CUT_LOC = T2.SMP_CUT_LOC
   AND T1.SMP_NO = T4.SMP_NO(+)
   AND T1.SMP_CUT_LOC = T4.SMP_CUT_LOC(+)
   AND T2.QLTY_CD     = T3.QLTY_CD
   AND T1.COIL_STAT='2'
   GROUP BY T1.OLD_SAMPL_NO) TA
   ,(select t3.old_sampl_no from tbb02_stat_lian t3 where t3.YN_FJH='Y' and t3.COIL_STAT='2')tb
 WHERE '1' = '1'
   AND A.SLAB_NO = B.SLAB_NO(+)
   AND A.ORD_NO = C.ORD_NO(+)
   AND A.ORD_SEQ = C.ORD_SEQ(+)
   AND A.ORD_NO = D.ORD_NO(+)
   AND A.SMP_NO = E.SMP_NO(+)
   AND A.ORD_NO = K.ORD_NO(+)
   AND A.ORD_SEQ = K.ORD_SEQ(+)
   AND A.DLIV_DIRNO = J.DLIV_DIRNO(+)
   AND A.OLD_SAMPL_NO = F.EXIT_COIL_NO(+)
   AND A.OLD_SAMPL_NO = L.COIL_NO(+)
   AND A.OLD_SAMPL_NO = M.OLD_SAMPL_NO(+) 
   AND A.COIL_STAT = '2'
   AND A.old_sampl_no=tb.old_sampl_no
   AND A.OLD_SAMPL_NO = TA.OLDSAMPLNO(+)
   AND NVL(A.EXTSHAPE_QUALITY,'NULLP') NOT IN('FP','CP')---屏蔽废次卷
   AND SUBSTR(A.OLD_SAMPL_NO, 1, 12) = H.C_COIL_NO(+)
   --AND A.CUR_PROG_CD  IN ('DFA'  ,'DFB')
   --AND A.PACKAGE_FL='1'
   AND A.OLD_SAMPL_NO || '&' LIKE '%' || ? || '%'
   AND A.SPEC_STL_GRD || '&' LIKE ? || '%'
   AND A.CUR_LOAD_LOC LIKE ? || '%'
   AND A.COIL_THK >= NVL(?, '000')
   AND A.COIL_THK <= NVL(?, '999')
   AND A.COIL_WTH >= NVL(?, '00000')
   AND A.COIL_WTH <= NVL(?, '99999')
   AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0)
   AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999)
   AND A.ORD_NO || '&' LIKE ? || '%'
   AND A.CUR_PROG_CD || '&' LIKE ? || '%'
   AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%'
   AND E.SMP_SEND_DTIME || '&' LIKE ? || '%'
   AND A.PRODNM_CD || '&' LIKE ? || '%'
   AND A.ORD_FL || '&' LIKE ? || '%'

		 ]]>
	</query>
	
		<query id="UIM010232_03.SELECT"  desc="待包装钢卷查询">
		<![CDATA[
	
SELECT 'False' CHK,
		A.OLD_SAMPL_NO,
       A.SPEC_STL_GRD,
       A.COIL_THK,
       A.COIL_WTH,
       A.INSTR_COIL_THK,
       A.INSTR_COIL_WTH,
       A.ACT_WGT,
       DECODE(A.ORD_FL, '1', '订单材', '2', '余材', '', '未判') ORD_FL,
       A.ORD_NO,
       A.ORD_SEQ,
       A.CUR_LOAD_LOC,
       /*,DECODE(A.CUR_PROG_CD,'DRC','连退卷充当待机','DBA','重卷指示待机','DBB','重卷作业待机'
                                    ,'DCA','包装指示待机','DCB','包装作业待机','DED','综合判定待机','DFA','发货指示待机'
                                    ,'DFB','发货待机','CCA','连退作业指示待机','CCB','连退作业待机','CCC','连退卷取待机'
                                    ) CUR_PROG_CD*/
       (CASE
         WHEN XB_PACKAGE.GF_COMNNAME_FIND('E01002', A.CUR_PROG_CD) =
              '连退成品充当待机' AND a.DEFECTIVE = 'Y' then
          '二级库存'
         ELSE
          XB_PACKAGE.GF_COMNNAME_FIND('E01002', a.CUR_PROG_CD)
       END) CUR_PROG_CD,
       C_PKG_UIM.GET_STDDATESTR(C.ORD_DEVLMT_DATE) ORD_DEVLMT_DATE,
       C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME
  FROM C_TBC02_COIL_COMM A, TBA01_ORD_LINE C
 WHERE '1' = '1'
   AND A.ORD_NO = C.ORD_NO(+)
   AND A.ORD_SEQ = C.ORD_SEQ(+)
   and a.FB_YN = 'N'
   and a.PACKAGE_LEVEL is null
   AND A.COIL_STAT = '2'
   and a.package_close_dtime is null
   AND A.OLD_SAMPL_NO LIKE ?||'%'
  -- and substr(a.mill_dtime,1,8) between ? and ?
   AND NVL(A.EXTSHAPE_QUALITY, 'NULLP') NOT IN ('FP', 'CP') ---屏蔽废次卷
   order by a.old_sampl_no desc
-- AND SUBSTR(A.OLD_SAMPL_NO, 1, 12) = H.C_COIL_NO(+)
--AND A.CUR_PROG_CD  IN ('DFA'  ,'DFB')
--AND A.PACKAGE_FL='1'
		 ]]>
	</query>
	
	
		<query id="UIM010232_04.UPDATE"  desc="待包装钢卷截止时间添加">
		<![CDATA[
	
				UPDATE C_TBC02_COIL_COMM T SET T.PACKAGE_CLOSE_DTIME=? WHERE T.OLD_SAMPL_NO=?
		 ]]>
	</query>
	
	
	<query id="UIM010232_04.SELECT"  desc="待包装钢卷查询">
		<![CDATA[
	
SELECT 'False' CHK,
		A.OLD_SAMPL_NO,
       A.SPEC_STL_GRD,
       A.COIL_THK,
       A.COIL_WTH,
       a.package_close_dtime,
       A.INSTR_COIL_THK,
       A.INSTR_COIL_WTH,
       A.ACT_WGT,
       DECODE(A.ORD_FL, '1', '订单材', '2', '余材', '', '未判') ORD_FL,
       A.ORD_NO,
       A.ORD_SEQ,
       A.CUR_LOAD_LOC,
       /*,DECODE(A.CUR_PROG_CD,'DRC','连退卷充当待机','DBA','重卷指示待机','DBB','重卷作业待机'
                                    ,'DCA','包装指示待机','DCB','包装作业待机','DED','综合判定待机','DFA','发货指示待机'
                                    ,'DFB','发货待机','CCA','连退作业指示待机','CCB','连退作业待机','CCC','连退卷取待机'
                                    ) CUR_PROG_CD*/
       (CASE
         WHEN XB_PACKAGE.GF_COMNNAME_FIND('E01002', A.CUR_PROG_CD) =
              '连退成品充当待机' AND a.DEFECTIVE = 'Y' then
          '二级库存'
         ELSE
          XB_PACKAGE.GF_COMNNAME_FIND('E01002', a.CUR_PROG_CD)
       END) CUR_PROG_CD,
       C_PKG_UIM.GET_STDDATESTR(C.ORD_DEVLMT_DATE) ORD_DEVLMT_DATE,
       C_PKG_UIM.GET_STDTIMESTR(A.MILL_DTIME) MILL_DTIME
  FROM C_TBC02_COIL_COMM A, TBA01_ORD_LINE C
 WHERE '1' = '1'
   AND A.ORD_NO = C.ORD_NO(+)
   AND A.ORD_SEQ = C.ORD_SEQ(+)
   and a.FB_YN = 'N'
   and a.PACKAGE_LEVEL is  null
   AND A.COIL_STAT = '2'
   and a.package_close_dtime is not null
   AND A.OLD_SAMPL_NO LIKE ?||'%'
   AND NVL(A.EXTSHAPE_QUALITY, 'NULLP') NOT IN ('FP', 'CP') ---屏蔽废次卷
-- AND SUBSTR(A.OLD_SAMPL_NO, 1, 12) = H.C_COIL_NO(+)
--AND A.CUR_PROG_CD  IN ('DFA'  ,'DFB')
--AND A.PACKAGE_FL='1'
		 ]]>
	</query>
	
	<query id="UIM010232_05.UPDATE"  desc="待包装钢卷截止时间添加">
		<![CDATA[
	
				UPDATE C_TBC02_COIL_COMM T SET T.PACKAGE_CLOSE_DTIME='' WHERE T.OLD_SAMPL_NO=?
		 ]]>
	</query>
	<query id="UIM010232_06.SELECT"  desc="二级库存查询">
		<![CDATA[
	SELECT '' GCZY,
	A.OLD_SAMPL_NO
      ,''  PINZHONG
      ,A.SPEC_STL_GRD
      , to_char(A.COIL_THK,'fm9999990.0099')||'*'|| A.COIL_WTH||'*'||A.COIL_LEN GUIGE
        , '新余钢铁' CHANDI,
       nvl(A.ACT_WGT,0)/1000 ACT_WGT,
       '' CANGKU,
       '' JIAGE,
       '' JIAGEMIN,
       '' YIJIA,
       A.SPEC_ABBSYM,
       '' CANKAOPAIHAO,
       '' ZLDJ, 
       A.EXTSHAPE_QUALITY||';' GGXQ,
       A.CUR_LOAD_LOC,
       '' QZA,
       '' DUCENG,
       '' BIAOMIAN,
       '' MIANQI,
       '' YANSE,
        DECODE(A.PACKAGE_LEVEL,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装',
              '5',
              '出口包装') PACKAGE_LEVEL,
       substr(A.YARD_ENTRY_DTIME,1,8) YARD_ENTRY_DTIME,
       substr(A.MILL_DTIME,1,8) MILL_DTIME,
       '' TESHUSHUOMING 
       ,DECODE(W.WANGGOU_YN,'Y','是','否') WANGGOU_YN
  FROM C_TBC02_COIL_COMM A,TBC01_WSXS_COIL_COM W
 WHERE A.COIL_STAT = '2'
   AND A.OLD_SAMPL_NO = W.COIL_NO(+)
   AND NVL(A.EXTSHAPE_QUALITY, 'NULLP') NOT IN ('FP', 'CP') ---屏蔽废次卷
   AND A.DEFECTIVE='Y'
   AND A.OLD_SAMPL_NO || '&' LIKE '%' || ? || '%'
   AND A.SPEC_STL_GRD || '&' LIKE ? || '%'
   AND SUBSTR(NVL(A.mill_dtime, 99999999999999), 1, 8) >= NVL(?, 0)
   AND SUBSTR(NVL(A.mILL_DTIME, 0), 1, 8) <= NVL(?, 99999999999999)
   AND NVL(W.WANGGOU_YN,'N') LIKE ? || '%'
  -- AND A.ORD_NO || '&' LIKE ? || '%'
  order by a.old_sampl_no desc
		 ]]>
	</query>
	<query id="UIM010232_07.SELECT"  desc="二级库存查询">
		<![CDATA[
		SELECT T.*,DECODE(W.WANGGOU_YN,'Y','是','否') WANGGOU_YN FROM TBC02_ERJI_ZLXX T,TBC01_WSXS_COIL_COM W
		WHERE T.OLD_SAMPL_NO = W.COIL_NO(+)
		AND T.OLD_SAMPL_NO || '&' LIKE '%' || ? || '%'
	    AND T.SPEC_STL_GRD || '&' LIKE ? || '%'
	    AND NVL(T.MILL_TIME, '99999999') >= NVL(?, '00000000')
	    AND NVL(T.MILL_TIME, '00000000') <= NVL(?, '99999999')
	    AND NVL(W.WANGGOU_YN,'N') LIKE ? || '%'
	  -- AND A.ORD_NO || '&' LIKE ? || '%'
  	order by T.old_sampl_no desc
		 ]]>
	</query>
	<query id="UIM010232_RZ.SELECT"  desc="热轧二级库存查询">
		<![CDATA[
	SELECT '' GCZY,
       A.OLD_SAMPL_NO,
       '' PINZHONG,
       A.SPEC_STL_GRD,
       to_char(A.COIL_THK, 'fm9999990.0099') || '*' || A.COIL_WTH || '*' || A.COIL_LEN GUIGE,
       '新余钢铁' CHANDI,
       nvl(A.ACT_WGT, 0) / 1000 ACT_WGT,
       '' CANGKU,
       '' JIAGE,
       '' JIAGEMIN,
       '' YIJIA,
       A.SPEC_ABBSYM,
       '' CANKAOPAIHAO,
       A.COIL_PROD_GRADE ZLDJ,
       DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','待判定') GGXQ,
       A.CUR_LOAD_LOC,
       '' QZA,
       '' DUCENG,
       '' BIAOMIAN,
       '' MIANQI,
       '' YANSE,
       DECODE(A.PACK_METHOD_CD,
              '1',
              '不包装',
              '2',
              '简易包装',
              '3',
              '普通包装',
              '4',
              '精包装',
              '5',
              '出口包装') PACKAGE_LEVEL,
       substr(A.YARD_ENTRY_DTIME, 1, 8) YARD_ENTRY_DTIME,
       substr(A.MILL_DTIME, 1, 8) MILL_DTIME,
       '' TESHUSHUOMING
       ,DECODE(W.WANGGOU_YN,'Y','是','否') WANGGOU_YN
  FROM TBH02_COIL_COMM A,TBC01_WSXS_COIL_COM W
 WHERE A.COIL_STAT = '2' 
   AND A.OLD_SAMPL_NO = W.COIL_NO(+)
   AND A.QK_YN = 'Y'
   --AND NVL(A.TOT_DEC_GRD, 'NULLP') NOT IN ('3', '4') ---屏蔽废次卷
   AND A.OLD_SAMPL_NO || '&' LIKE '%' || ? || '%'
   AND A.SPEC_STL_GRD || '&' LIKE ? || '%'
   AND SUBSTR(NVL(A.mill_dtime, 99999999999999), 1, 8) >= NVL(?, 0)
   AND SUBSTR(NVL(A.mILL_DTIME, 0), 1, 8) <= NVL(?, 99999999999999)
   AND NVL(W.WANGGOU_YN,'N') LIKE ? || '%'
-- AND A.ORD_NO || '&' LIKE ? || '%'
 order by a.old_sampl_no desc
		 ]]>
	</query>
	<query id="UIM010232_RZZL.SELECT"  desc="热轧二级库存质量查询">
		<![CDATA[
	SELECT T.*,DECODE(W.WANGGOU_YN,'Y','是','否') WANGGOU_YN FROM TBB02_ERJI_ZLXX T,TBC01_WSXS_COIL_COM W
		WHERE T.OLD_SAMPL_NO = W.COIL_NO(+)
		AND T.OLD_SAMPL_NO || '&' LIKE '%' || ? || '%'
	    AND T.SPEC_STL_GRD || '&' LIKE ? || '%'
	    AND NVL(T.MILL_TIME, '99999999') >= NVL(?, '00000000')
	    AND NVL(T.MILL_TIME, '00000000') <= NVL(?, '99999999')
	    AND NVL(W.WANGGOU_YN,'N') LIKE ? || '%'
	  -- AND A.ORD_NO || '&' LIKE ? || '%'
  	order by T.old_sampl_no desc
		 ]]>
	</query>
	<query id="UIM010232_WSXS.SELECT"  desc="根据钢卷号查询网购钢卷记录">
		<![CDATA[
	  		SELECT T.* FROM TBC01_WSXS_COIL_COM T WHERE T.COIL_NO    =   ? 
		 ]]>
	</query>
	<query   id="UIM010232_WSXS.INSERT" desc="把已经导出到网购的钢卷保存到网购钢卷记录表中TBC01_WSXS_COIL_COM">
			insert into TBC01_WSXS_COIL_COM (
				COIL_NO, 
				WANGGOU_YN, 
				PROD_LINE, 
				WANGGOU_INFO, 
				REMARKS, 
				REG_PGM_ID, 
				REG_ID, 
				REG_DTIME
			) VALUES(?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'))
	</query>
	<query   id="UIM010232_WSXS.UPDATE" desc="导出后修改网购钢卷的状态WANGGOU_YN为Y">
			UPDATE      TBC01_WSXS_COIL_COM 
		    SET 
                WANGGOU_YN       =   ?    --网购卷标识
               ,REMARKS 		 =   ?
			   ,MOD_PGM_ID       =   ?    
			   ,MOD_ID           =   ?
               ,MOD_DTIME        =   TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')	
			WHERE     COIL_NO    =   ?    --目标钢号
	</query>
</queryMap>