| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="中厚板计划单查询 ">
- <query id="UIG040130_01.SELECT" desc="" fetchSize="10">
- <![CDATA[
- SELECT '' CHK
- ,T1.L2_SCH
- ,T1.L2_SCH_NO
- ,T1.FAC_STL_GRD
- ,T1.SLAB_WGT
- ,T1.SLAB_THK
- ,T1.SLAB_WTH
- ,T1.SLAB_LEN
- ,T1.ORD_NO
- ,T1.ORD_SEQ
- ,T1.PROC_STAT
- ,T1.PROC_PATH
- ,T1.DSN_SLAB_NO
- ,T1.REG_DTIME LGJH_GET_DTIME --炼钢计划接收时间（生产部）
- ,T2.SLAB_NO
- ,T2.SLAB_INGR_DEC_GRD
- ,T2.SLAB_INGR_DEC_DTIME
- ,T2.SLAB_CUT_DTIME --板坯切割时间
- ,T2.ZH_GD_DTIME --挂单时间
- ,T2.SLAB_OUT_TP --是否允许出库
- ,T2.SLAB_OUT_TP_DTIME --出库时间
- ,T2.SLAB_DCS_DETAIL
- ,T2.REG_DTIME LGJH_SEED_DTIME --计划下发时间
- FROM TBD01_SLABDN_OBJ2 T1
- ,(SELECT SC.SLAB_NO
- ,SC.DSN_SLAB_NO
- ,SC.SLAB_INGR_DEC_GRD
- ,SC.SLAB_INGR_DEC_DTIME
- ,SC.SLAB_CUT_DTIME --板坯切割时间
- ,SC.ZH_GD_DTIME --挂单时间
- ,SC.SLAB_OUT_TP --是否允许出库
- ,SC.SLAB_OUT_TP_DTIME --出库时间
- ,SC.SLAB_DCS_DETAIL
- ,SS.REG_DTIME
- FROM TBG02_SLAB_COMM SC
- ,TBF01_SPEC_SLAB SS
- WHERE SC.PLAN_SLAB_NO = SS.SLAB_MANA_NO(+)
- ) T2
- WHERE T1.DSN_SLAB_NO = T2.DSN_SLAB_NO(+)
- AND T1.L2_SCH_NO LIKE ?||'%'
- AND NVL(T2.REG_DTIME, 1) BETWEEN NVL(?, NVL(T2.REG_DTIME, 0)) AND NVL(?,NVL(T2.REG_DTIME,2))
- AND T1.ORD_NO LIKE ? || '%'
- AND T1.ORD_SEQ LIKE ? || '%'
- ]]>
- </query>
-
- <query id="UIG040130_01.CALL" desc="计划号错误修改">
- {call PKG_UIG.PROC_SCH_NO_MODIFY(?,?,?,?)}
- </query>
- </queryMap>
|
