| 123456789101112131415161718192021222324252627282930313233343536 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG010050_SLAB_CUT_INS.select" desc=" 包号查询 " fetchSize="10">
- <![CDATA[
- SELECT L2_SCH -- 生产号
- ,A.L2_SCH_NO -- 计划号
- ,'J'||SUBSTR(B.CHARGE_MANA_NO,2,9) CHARGE_NO
- ,'J'||SUBSTR(C.SLAB_MANA_NO,2,13) SLAB_NO
- ,B.STL_GRD
- ,A.SLAB_THK
- ,A.SLAB_WTH
- ,A.SLAB_LEN
- ,A.SLAB_WGT
- ,L2_CUTTYPE -- 切割方式
- ,A.KEEPWARM_YN
- ,L2_PLATE_PLY -- 成品厚度
- ,L2_PLATE_WIDTH -- 成品宽度
- ,L2_MEMO -- 备注
- ,L2_STEELCODE -- 成品牌号
- ,L2_SENDBEGINDATE -- 交货期
- ,A.REG_DATETIME
- ,A.DSN_SLAB_NO
- FROM TBD01_SLABDN_OBJ2 A
- ,TBF01_SPEC_CHARGE B
- ,TBF01_SPEC_SLAB C
- ,TBF01_CHARGE_IDX D
- WHERE A.DSN_SLAB_NO = C.DSN_SLAB_NO
- AND C.SLAB_RT IN ('P','Z')
- AND SUBSTR(C.SLAB_MANA_NO,1,10) = B.CHARGE_MANA_NO
- AND B.CHARGE_EDT_SEQ = D.CHARGE_EDT_SEQ
- AND TO_CHAR(A.REG_DATETIME,'YYYYMMDD') = ?
- AND B.STATUS_CD IN('A','B')
- ORDER BY B.CHARGE_MANA_NO ASC,A.REG_DATETIME ASC
- ]]>
- </query>
- </queryMap>
|
