| 1234567891011121314151617181920212223242526272829303132333435363738 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH050040_01.select" desc="为了让没有钢卷的地方可以空出来" fetchSize="10">
- <![CDATA[
- SELECT a.YARD_CLF||a.STEP_CLF||a.STORELAY||a.STORE_SEQ FROM_ADDR
- ,a.COIL_NO OLD_SAMPL_NO
- ,b.COIL_OUTDIA OUT_DIA
- ,b.COIL_INDIA COIL_INDIA
- ,b.ACT_WGT ACT_WGT
- ,b.DEVLMT_DTIME DEVLMT_DTIME
- ,b.ord_no ord_no1
- ,B.ORD_SEQ
- ,b.SAMPL_PICK_YN SAMPL_PICK_YN
- ,DECODE(B.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品') TOT_DEC_GRD
- ,DECODE(b.ORD_FL,'1','订单材','2','余材') ORD_FL
- ,B.DLIV_DIRNO
- ,DECODE(C.DLIV_TP,'T','铁运','C','汽运') DLIV_TP
- ,B.SPEC_STL_GRD
- ,B.INSTR_COIL_THK||'*'||B.INSTR_COIL_WTH IT_IW
- ,B.COIL_THK||'*'||B.COIL_WTH T_W
- ,b.SPM_YN SPM_YN
- FROM TBH05_COIL_YARD a,TBH02_COIL_COMM b,TBJ01_DLIV_DIR C
- WHERE a.YARD_CLF = ?
- AND b.COIL_STAT = '2'
- AND a.coil_no = b.Old_Sampl_No(+)
- AND B.DLIV_DIRNO = C.DLIV_DIRNO(+)
- ]]>
- </query>
- <query id="UIH050040_02.select" desc="" fetchSize="10">
- <![CDATA[
- select (YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ) YARD_ADDR
- ,coil_no
- from tbh05_coil_yard
- where yard_clf like ?||'%'
- --and coil_no is not null
- ]]>
- </query>
- </queryMap>
|
