| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="物料充当处理">
- <!--
- 选定充当订单：UIE031010.RepOrd.Select
- -->
- <query id="UIE031025.RepSlab.Select" desc="" fetchSize="10">
- <![CDATA[
- SELECT
- B.SLAB_NO DSP_NO,
- B.SLAB_NO MAT_NO, -- 板坯号
- B.STL_GRD, -- 钢号
- B.SLAB_THK MAT_THK, -- 板坯厚度
- B.SLAB_WTH MAT_WTH, -- 板坯宽度
- B.SLAB_LEN MAT_LEN, -- 板坯长度
- B.SLAB_WGT MAT_WGT, -- 板坯重量
- B.PROD_DTIME, -- 生产日期
- XB_PACKAGE.GF_COMNNAME_FIND('E01010', B.WOO_RSN) WOO_RSN, -- 余材原因
- B.LOC, -- 堆放位置
- NVL(B.KEEPWARM_YN, 'N') KEEPWARM_YN, -- 是否需要进保温坑
- B.ORG_ORD_NO, -- 最初合同号
- B.ORG_ORD_SEQ, -- 最初订单号
- (B.SLAB_WGT * C.PROC_RATE / 100) REP_WGT
- FROM TBE04_REP_ORD A, TBE04_REP_SLAB B, (
- SELECT PROC_RATE FROM TBE01_PROC_RATE WHERE PROC_CD = 'R') C /*, TBG02_SLAB_COMM D */
- WHERE A.ORD_NO = ?
- AND A.ORD_SEQ = ?
- AND B.ORD_FL = '2'
- AND B.SLAB_WTH BETWEEN A.ORD_WTH AND A.ORD_WTH + 100
- AND (B.SLAB_WGT * C.PROC_RATE / 100) BETWEEN A.ORD_WGT_MIN AND A.ORD_WGT_MAX
- -- AND D.SLAB_NO = B.SLAB_NO
- AND ('Y' <> NVL(?, 'N') OR (B.STL_GRD = A.STL_GRD /* AND D.SLAB_INGR_DEC_GRD = '1' */)) -- 同牌号
- AND ('Y' <> NVL(?, 'N') OR GF_NIB028720(B.SLAB_NO, A.ORD_NO, A.ORD_SEQ) = 'YY') -- 检查成分项目
- ORDER BY B.SLAB_WGT DESC, B.LOC ASC
- ]]>
- </query>
- <query id="UIE031025.RepCoil.Select" desc="" fetchSize="10">
- <![CDATA[
- SELECT
- C.OLD_SAMPL_NO DSP_NO,
- B.COIL_NO MAT_NO, -- 钢卷号
- B.STL_GRD, -- 钢号
- --------------------------------------
- --MODIFY BY SJW 091010
- D.SPEC_STL_GRD, -- 钢号
- --------------------------------------
- B.COIL_THK MAT_THK, -- 钢卷厚度
- B.COIL_WTH MAT_WTH, -- 钢卷宽度
- B.COIL_LEN MAT_LEN, -- 钢卷长度
- B.COIL_WGT MAT_WGT, -- 钢卷重量
- B.COIL_INDIA, -- 钢卷内径
- B.COIL_OUTDIA, -- 钢卷外径
- B.PROD_DTIME, -- 生产日期
- XB_PACKAGE.GF_COMNNAME_FIND('E01010', B.WOO_RSN) WOO_RSN, -- 余材原因
- B.LOC, -- 堆放位置
- NVL(B.SAMPL_PICK_YN, 'N') SAMPL_PICK_YN,
- B.ORG_ORD_NO, -- 最初合同号
- B.ORG_ORD_SEQ, -- 最初订单号
- COIL_WGT REP_WGT
- FROM TBE04_REP_ORD A, TBE04_REP_COIL B, TBH02_COIL_COMM C
- -------------------------------------------
- --MODIFY BY SJW 091010
- --DESC: 成品同牌号更改为spec_stl_grd
- ,TBA01_ORD_LINE D
- -------------------------------------------
- WHERE A.ORD_NO = ?
- AND A.ORD_SEQ = ?
- -----------------------------------------------------------
- --MODIFY BY SJW 091010
- --DESC: 成品同牌号更改为spec_stl_grd
- AND A.ORD_NO = D.ORD_NO -- 合同号
- AND A.ORD_SEQ = D.ORD_SEQ -- 订单号
- -----------------------------------------------------------
- AND B.ORD_FL = '2'
- AND B.COIL_WGT BETWEEN A.ORD_WGT_MIN AND A.ORD_WGT_MAX
- AND B.COIL_NO = C.COIL_NO
- -- AND ('Y' <> NVL(?, 'N') OR B.STL_GRD = A.STL_GRD) -- 同牌号
- ------------------------------------------------------------------------------------------
- --MODIFY BY SJW 091010
- --DESC: 成品同牌号更改为spec_stl_grd
- AND ('Y' <> NVL(?, 'N') OR C.SPEC_STL_GRD = D.SPEC_STL_GRD) -- 同牌号
- ------------------------------------------------------------------------------------------
- AND GF_NIB028780(B.COIL_NO, A.ORD_NO, A.ORD_SEQ) = 'YY' -- 检查尺寸通过
- AND ('Y' <> NVL(?, 'N') OR GF_NIB028720(C.SLAB_NO, A.ORD_NO, A.ORD_SEQ) = 'YY') -- 检查成分项目
- AND ('Y' <> NVL(?, 'N') OR GF_NIB028750(B.COIL_NO, A.ORD_NO, A.ORD_SEQ) = 'YY') -- 检查材质项目
- ORDER BY COIL_WGT DESC, LOC ASC
- ]]>
- </query>
- </queryMap>
|
