XinYu_LZMES/.svn/pristine/75/755e9cf398f8b90e0374cf644b89112ffde1ef06.svn-base

<?xml version="1.0" encoding='UTF-8'?>

<queryMap desc="中间入库明细表">


<query id="UIC020200_01.SELECT">
  <![CDATA[
  SELECT (SELECT t.sm_cfnm
           FROM tbz00_commcd t
          WHERE t.lg_cd = 'E01002'
                AND t.sm_cd = t.cur_prog_cd) cur_prog_cd, t.old_sampl_no,
       t.spec_stl_grd, t.mill_dtime, t.act_wgt, t.instr_coil_thk,
       t.instr_coil_wth, t.coil_thk, t.coil_wth, t.cur_load_loc,
       m.act_wgt m_wgt, trunc((t.act_wgt / m.act_wgt), 4) * 100 cxl,
       t.extshape_quality,
       xb_package.gf_comnname_find('B02001', t.crk_cd1) crk_cd1,
       xb_package.gf_comnname_find('B02001', t.crk_cd2) crk_cd2,
       xb_package.gf_comnname_find('B02001', t.crk_cd3) crk_cd3,
       xb_package.gf_comnname_find('B02001', t.crk_cd4) crk_cd4,
       xb_package.gf_comnname_find('B02001', t.crk_cd5) crk_cd5,
       (SELECT c.sm_cfnm
           FROM tbz00_commcd c
          WHERE c.lg_cd = 'A01010'
                AND sm_cd = t.package_level) package_level
   FROM c_tbl02_coil_comm t, c_tbk02_coil_comm m
 WHERE t.old_sampl_no like '%' || ? || '%'
       AND t.cust_cd <> '224901'
       AND ((SUBSTR(t.ord_no,1,2)='W4') or (SUBSTR(t.ord_no,1,1)='4'))
       AND substr(t.mill_dtime, 1, 8) BETWEEN ? AND ?
       AND t.h_coil_no1 = m.coil_no
]]>

</query>

<query id="UIC020200_02.SELECT">
  <![CDATA[
  
SELECT T.CUST_CD,(SELECT t.sm_cfnm
          FROM tbz00_commcd t
         WHERE t.lg_cd = 'E01002'
           AND t.sm_cd = t.cur_prog_cd) cur_prog_cd,
       t.old_sampl_no,
       t.spec_stl_grd,
       t.mill_dtime,
       t.act_wgt,
       t.instr_coil_thk,
       t.instr_coil_wth,
       t.coil_thk,
       t.coil_wth,
       t.cur_load_loc,
       m.act_wgt m_wgt,
       trunc((t.act_wgt / m.act_wgt), 4) * 100 cxl,
       t.extshape_quality,
       xb_package.gf_comnname_find('B02001', t.crk_cd1) crk_cd1,
       xb_package.gf_comnname_find('B02001', t.crk_cd2) crk_cd2,
       xb_package.gf_comnname_find('B02001', t.crk_cd3) crk_cd3,
       xb_package.gf_comnname_find('B02001', t.crk_cd4) crk_cd4,
       xb_package.gf_comnname_find('B02001', t.crk_cd5) crk_cd5,
       (SELECT c.sm_cfnm
          FROM tbz00_commcd c
         WHERE c.lg_cd = 'A01010'
           AND sm_cd = t.package_level) package_level
  FROM c_tbl02_coil_comm t, c_tbk02_coil_comm m
 WHERE t.old_sampl_no like '%' || ? || '%'
   AND t.PACKAGE_LEVEL is not null
   and t.line_tp = 'S'
   AND substr(t.mill_dtime, 1, 8) BETWEEN ? AND ?
   AND t.h_coil_no1 = m.coil_no
]]>

</query>

</queryMap>