| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH052200_01.select" desc=" 查询已打印发货明细的卷 ">
- <![CDATA[
- SELECT A.OLD_SAMPL_NO
- ,A.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
- ,(select CUST_NM FROM TBZ00_CUSTOMER WHERE CUST_CD = (SELECT CUST_CD FROM TBA01_ORD_COMM WHERE ORD_NO = A.ORD_NO) and REC_TP='01') CUST_NM
- ,(select CUST_NM ORD_NM FROM TBZ00_CUSTOMER WHERE CUST_CD = C.ORD_CUST_CD and REC_TP='02') ORD_NM
- ,(SELECT A.SM_CFNM FROM TBZ00_COMMCD A WHERE A.LG_CD = 'A01009' AND A.SM_CD = C.DEST_PCD) DEST_PCD_DESC
- FROM TBH02_COIL_COMM A,TBJ01_DLIV_DIR C
- WHERE A.DLIV_DIRNO = C.DLIV_DIRNO
- AND A.DLIV_DIRNO = :1
- AND A.COIL_STAT = '3'
- AND A.CUR_PROG_CD = 'SFF'
- AND A.SHIP_PROG_CD = '08'
- AND A.TRNF_DTIME IS NOT NULL
- ]]>
- </query>
- <query id="UIH052200_02.select" desc=" 查询结算是否接收 ">
- <![CDATA[
- select A.ISCHANGEWGT from TBJ02_COIL_COMM A WHERE A.DLIV_DIRNO = :1
- ]]>
- </query>
- <query id="UIH052200_03.select" desc=" 查询没有车号的发货明细的卷 ">
- <![CDATA[
- SELECT A.OLD_SAMPL_NO
- ,A.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
- ,(select CUST_NM FROM TBZ00_CUSTOMER WHERE CUST_CD = (SELECT CUST_CD FROM TBA01_ORD_COMM WHERE ORD_NO = A.ORD_NO) and REC_TP='01') CUST_NM
- ,(select CUST_NM ORD_NM FROM TBZ00_CUSTOMER WHERE CUST_CD = C.ORD_CUST_CD and REC_TP='02') ORD_NM
- ,(SELECT A.SM_CFNM FROM TBZ00_COMMCD A WHERE A.LG_CD = 'A01009' AND A.SM_CD = C.DEST_PCD) DEST_PCD_DESC
- FROM TBH02_COIL_COMM A,TBJ01_DLIV_DIR C
- WHERE A.DLIV_DIRNO = C.DLIV_DIRNO
- AND A.DLIV_DIRNO = :1
- AND A.COIL_STAT = '3'
- AND A.CUR_PROG_CD = 'SFF'
- AND A.SHIP_PROG_CD = '03'
- AND A.TRNF_DTIME IS NOT NULL
- ]]>
- </query>
- <query id="UIH052200_COIL_COMM.UPDATE" desc=" 更新钢卷公共表 ">
- <![CDATA[
- UPDATE TBH02_COIL_COMM A SET
- A.COIL_STAT = '2'
- ,A.CUR_PROG_CD = 'SFB'
- ,A.SHIP_PROG_CD = '03'
- ,A.TRNF_DTIME = ''
- ,A.TRANS_CAR_NO = ''
- ,A.TRNF_REG = ''
- ,A.TRNF_SHIFT = ''
- ,A.TRNF_GROUP = ''
- ,A.TRNF_USE_TIME = ''
- ,A.BEF_SHIP_INVNO = A.SHIP_INVNO
- ,A.BEF_CRET_NO = A.CRET_NO
- ,A.RETURN_SHIP_REG = :1
- ,A.RETURN_SHIP_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
-
- WHERE A.DLIV_DIRNO = :2
- ]]>
- </query>
- <query id="UIH052200_DLIV_DIR.UPDATE" desc=" 更新发运表 ">
- <![CDATA[
- UPDATE TBJ01_DLIV_DIR A SET
- A.LANE_TP = ''
- ,A.ENTERANCE_SEQ = ''
- ,A.ALLOC_SEQ = ''
- ,a.TRANS_CAR_NO = ''
- WHERE A.DLIV_DIRNO = :1
- ]]>
- </query>
- <query id="UIH052200_SHIP_DIR.UPDATE" desc=" 更新运送表 ">
- <![CDATA[
- UPDATE TBJ01_SHIP_DIR A SET
- A.SHIP_PROG_CD = '03'
-
- WHERE A.SHIP_DIRNO = (SELECT T.SHIP_DIRNO FROM TBJ01_DLIV_DIR T WHERE T.DLIV_DIRNO = :1)
- ]]>
- </query>
- <query id="UIH052200_J02_COMM.UPDATE" desc=" 更新结算公共表 ">
- <![CDATA[
- DELETE TBJ02_COIL_COMM A WHERE A.DLIV_DIRNO = :1 AND A.ISCHANGEWGT = '1'
- ]]>
- </query>
- </queryMap>
|
