| 123456789101112131415161718192021222324252627282930313233343536 |
- <?xml version="1.0" encoding="UTF-8"?>
- <queryMap desc="包装作业管理">
- <query id="UIM030070_01.SELECT" desc="查询待包装钢卷">
- <![CDATA[
- SELECT
- T1.OLD_SAMPL_NO
- ,T1.SPEC_STL_GRD
- ,T1.INSTR_COIL_THK
- ,T1.INSTR_COIL_WTH
- ,T1.COIL_THK
- ,T1.COIL_WTH
- ,T1.TOT_DEC_GRD
- ,C_PKG_UIM.GET_RAWWEIGHT(T1.OLD_SAMPL_NO) RAWWEIGHT
- ,decode(t1.PACKAGE_GROUP,'0','常白班'
- ,'1','甲班'
- ,'2','乙班'
- ,'3','丙班'
- ,'4','丁班')PACKAGE_GROUP
- ,decode(t1.PACKAGE_SHIFT,'0','常白班'
- ,'1','早班'
- ,'2','中班'
- ,'3','晚班')PACKAGE_SHIFT
- ,t2.USERNAME PACKAGE_REG
- ,T1.ACT_WGT
- ,(SELECT t.SM_CFNM FROM tbz00_commcd t where t.LG_CD = 'A01010' and t.SM_CD = T1.PACKAGE_LEVEL) PACKAGE_LEVEL
- ,T1.PACKAGE_DTIME
- ,'' BZ
- FROM C_TBC02_COIL_COMM T1
- ,core_app_user t2
- WHERE substr(T1.PACKAGE_DTIME,1,8) BETWEEN :1 AND :2
- and t1.OLD_SAMPL_NO like :3||'%'
- and T1.PACKAGE_REG = t2.USERID(+)
- and T1.PACKAGE_LEVEL is not null
- ]]>
- </query>
- </queryMap>
|
