| 12345678910111213141516171819202122232425262728293031323334353637383940414243 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="">
-
- <query id="UIB030080_01.INITSELECT" desc="">
- SELECT SM_CD VALUE , SM_CFNM LABEL FROM TBZ00_COMMCD T WHERE LG_CD = 'E01010'
- </query>
-
- <query id = "UIB030080_02.INITSELECT">
- SELECT '全部' LABEL , '' VALUE FROM DUAL
- UNION ALL
- SELECT DISTINCT KPD.SPEC_STL_GRD LABEL , KPD.SPEC_STL_GRD VALUE FROM TBB01_KEY_PROD KPD
- </query>
-
- <query id="UIB030080_01.SELECT" desc="" fetchSize="10">
- <![CDATA[
- SELECT
- SPM.ROLL_MANA_NO
- ,CCM.OLD_SAMPL_NO
- ,CCM.SPEC_STL_GRD
- ,CCM.COIL_THK
- ,CCM.ACT_WGT
- ,CCM.NONORD_CAUSE_CD
- ,CCM.TOT_DEC_GRD
- ,CCM.MILL_DTIME
- ,CCM.TOT_DEC_EMP_ID
- ,SQ_QD_COMMON.COMMCD_CDTOCFNM('E01010',CCM.NONORD_CAUSE_CD) NONORD_CAUSE_CD
- ,DECODE(PMO.MISSNO_CLF , '1' , 1 , 0) DIAOXIAO ---吊销
- ,DECODE(PMO.MISSNO_CLF , '2' , 1 , 0) JIAHUI ---加回
- ,SQ_QD_COMMON.COMMCD_CDTOCFNM('H02001',CCM.CRK_CD1) CRK_CD
- ,(CASE WHEN MRT.MISSNO_BAR_THK||MRT.MISSNO_BAR_WTH||MRT.MISSNO_BAR_WGT IS NOT NULL AND MRT.MISSNO_CLF_CD = 'C' THEN 1 ELSE 0 END ) ZHONGBAN --中板
- FROM TBH02_COIL_COMM CCM , TBF02_SPEC_MILL SPM , TBH02_RHF_MISSNO PMO , TBH02_MILL_RESULT MRT
- WHERE CCM.COIL_NO = SPM.COIL_NO
- AND CCM.COIL_NO = PMO.COIL_NO(+)
- AND CCM.COIL_NO = MRT.COIL_NO(+)
- AND CCM.TOT_DEC_GRD IS NOT NULL
- AND CCM.ORD_FL = '2'
- AND CCM.SPEC_STL_GRD LIKE ?||'%'
- AND CCM.NONORD_CAUSE_CD LIKE ?||'%'
- AND CCM.MILL_DTIME BETWEEN ? AND ?
- ]]>
- </query>
- </queryMap>
|
