| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH052201_01.select" desc=" 查询已打印非计划发货明细的卷 ">
- <![CDATA[
- SELECT A.OLD_SAMPL_NO,
- A.APPOINT_NOTE DLIV_DIRNO,
- A.SHIP_DIRNO,
- A.SHIP_INVNO,
- A.CUR_PROG_CD,
- A.COIL_STAT,
- A.SHIP_PROG_CD,
- A.TRNF_DTIME,
- -- DECODE(C.DLIV_TP, 'C', '汽运', 'T', '火运') DLIV_TP,
- A.TRANS_CAR_NO,
- A.TRNF_REG,
- A.ORD_NO,
- A.ORD_SEQ,
- DECODE(A.TRNF_SHIFT, '1', '早', '2', '中', '3', '晚') TRNF_SHIFT,
- DECODE(A.TRNF_GROUP, 'A', '甲', 'B', '乙', 'C', '丙', 'D', '丁') TRNF_GROUP,
- A.TRNF_USE_TIME
- FROM TBH02_COIL_COMM A, tbh02_fjh_dlvno C
- WHERE a.APPOINT_NOTE = C.DLIV_DIRNO
- AND A.APPOINT_NOTE = :1
- AND A.COIL_STAT = '3'
- AND A.CUR_PROG_CD = 'SGF'
- AND A.APPOINT_YN = '08'
- AND A.TRNF_DTIME IS NOT NULL
- ]]>
- </query>
- <query id="UIH052201_01.update" desc="板加退回入库状态修改" fetchSize="10">
- <![CDATA[
- UPDATE TBH02_COIL_COMM T
- SET T.COIL_STAT = '2'
- ,T.CUR_LOAD_LOC = t.BEF_LOAD_LOC
- ,T.YARD_ENTRY_REG = :1
- ,T.YARD_ENTRY_USE_TIME =TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- ,T.APPOINT_YN = 'N'
- ,T.APPOINT_NOTE = ''
- ,T.TRANS_CAR_NO=''
- ,T.CUR_PROG_CD = 'SRC'--充当待机
- ,T.CUR_PROG_CD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')
- ,T.CUR_PROG_CD_PGM = 'UIH052201'
- ,T.BEF_PROG_CD = T.CUR_PROG_CD
- ,T.BEF_PROG_CD_DTIME = T.CUR_PROG_CD_DTIME
- ,T.BEF_PROG_CD_PGM = T.CUR_PROG_CD_PGM
-
- ,T.ORD_FL = '2'
- --NONORD_CAUSE_CD = ?
- ,T.NONORD_OCR_DTIME = TO_CHAR(SYSTIMESTAMP, 'YYYYMMDDHH24MISS')
- ,T.ORD_NO = ''
- ,T.ORD_SEQ = ''
- ,T.CUST_CD = ''
- ,T.ORDCUST_CD = ''
- ,T.ORD_USE_CD = ''
- ,T.SPEC_ABBSYM = ''
- ,T.DEVLMT_DTIME = ''
- ,T.DEST_CD = ''
- WHERE T.APPOINT_NOTE=:2
- ]]>
- </query>
-
-
- <query id="UIH052201_01.delete" desc="板加退回入库删除发运指示号" fetchSize="10">
- <![CDATA[
- delete from tbh02_fjh_dlvno t where t.dliv_dirno=:1
- ]]>
- </query>
-
- </queryMap>
|
