| 1234567891011121314151617181920212223242526272829 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="MAKE SPM PLAN QUERY">
- <query id="UIH060070_01.select" desc=" 平整分卷实绩查询 " fetchSize="10">
- <![CDATA[
- SELECT T1.OLD_SAMPL_NO
- ,T1.SPEC_STL_GRD
- ,T1.CUR_PROG_CD
- ,T1.CUR_LOAD_LOC
- ,T2.ORD_THK
- ,T2.ORD_WTH
- ,T2.WGT_ACVAL_MIN
- ,T2.WGT_ACVAL_MAX
- ,T1.COIL_THK
- ,T1.COIL_WTH
- ,T1.ACT_WGT
- ,T2.ORD_NO
- ,T2.ORD_SEQ
- ,T1.REG_DTIME
- --,T1.REG_GROUP
- ,T1.ISDIVI
-
- FROM TBH02_COIL_COMM T1
- ,TBE02_ORD_PRC T2
- WHERE T1.ORD_NO = T2.ORD_NO(+)
- AND T1.ORD_SEQ = T2.ORD_SEQ(+)
- AND SUBSTR(T1.OLD_SAMPL_NO,-1,1) <> '0'
- ]]>
- </query>
- </queryMap>
|
