| 123456789101112131415161718192021222324252627282930313233343536373839404142 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="出钢参数接收现况分析(中厚板)">
- <query id="UIF013030.findSlabComm" desc="在线板坯实绩现况" fetchSize="10">
- <![CDATA[
-
- -------------------mody by wxy 20100719 增加交货期----------------------------
- SELECT a.SLAB_NO,
- T2.SM_CFNM HCR_CLF,
- a.CUR_LOAD_LOC,
- a.SLAB_THK,
- a.SLAB_WTH,
- a.SLAB_LEN,
- a.SLAB_WGT,
- a.ORD_NO,
- a.ORD_SEQ,
- a.STL_GRD,
- T1.SM_CFNM SLAB_RT
- ,XB_PACKAGE.GF_COMNNAME_FIND('E01002', A.CUR_PROG_CD) CUR_PROG_CD
- ,A.SLAB_CUT_DTIME
- ,b.DEL_TO_DATE
- FROM TBG02_SLAB_COMM A,
- -------------------mody by wxy 20100719 增加交货期----------------------------
- tbe02_ord_prc b,
- -------------------mody by wxy 20100719 增加交货期----------------------------
- (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01004') T1,
- (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T2
- WHERE (A.CUR_LOAD_LOC LIKE 'A%' OR A.CUR_LOAD_LOC LIKE 'C%')
- AND A.SLAB_STAT = '2'
- AND A.SLAB_RT = T1.SM_CD
- AND A.HCR_CLF = T2.SM_CD
- -------------------mody by wxy 20100719 增加交货期----------------------------
- and a.ORD_NO = b.ORD_NO(+)
- and a.ORD_SEQ = b.ORD_SEQ(+)
- -------------------mody by wxy 20100719 增加交货期----------------------------
- AND A.CUR_PROG_CD LIKE ?||'%'
- AND SUBSTR(A.SLAB_CUT_DTIME,1,8) BETWEEN nvl(?,'00000000') AND nvl(?,'55555555')
- ORDER BY A.CUR_LOAD_LOC, A.SLAB_NO
-
-
- ]]>
- </query>
- </queryMap>
|
