| 12345678910111213141516171819202122232425262728293031323334353637383940 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="炼钢工序类别作业所需时间标准">
- <query id="UIF012050.find" desc="查询牌号组通过各工序所需时间标准" fetchSize="10">
-
- <![CDATA[
-
- /*用于查询slab在charge中的信息（状态：热装，紧急材,去向，规格：宽度，厚度，订单：订单要求）*/
-
- SELECT A.CHARGE_SLAB_SEQ ,/*炉次内顺序*/
- A.SLAB_EDT_SEQ ,/*板坯编制号*/
- A.SLAB_MANA_NO ,/*板坯管理号*/
- A.STL_GRD ,/*钢号*/
- A.SLAB_THK ,/*板坯厚度*/
- A.SLAB_WTH ,/*板坯宽度*/
- A.SLAB_LEN ,/*板坯长度*/
- A.SLAB_WGT ,/*板坯重量*/
- T1.SM_CFNM HCR_CLF ,/*热送代码*/
- A.EMGMTR_NMG_CLF ,/*紧急材代码*/
- A.OVER_ROLL_YN ,/*过量生产判断*/
- T2.SM_CFNM ORD_FL ,/*订单材余材区分*/
- A.ORD_THK ,/*订单厚度*/
- A.ORD_WTH, /*订单宽度*/
- T3.SM_CFNM ORD_USEAGE_CD ,/*订单用途代码*/
- A.DELV_REQ_DATE ,/*交货期*/
- T4.SM_CFNM SLAB_RT ,/*板坯去向*/
- A.CAST_MANA_NO /*浇次管理号*/
- FROM TBF01_SPEC_SLAB A ,
- (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T1,
- (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01007') T2,
- (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01007') T3,
- (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01004') T4
- WHERE A.CHARGE_MANA_NO = ?
- AND A.HCR_CLF = T1.SM_CD
- AND A.ORD_FL = T2.SM_CD
- AND A.ORD_USEAGE_CD = T3.SM_CD(+)
- AND A.SLAB_RT = T4.SM_CD
- ORDER BY A. CHARGE_SLAB_SEQ ASC
- ]]>
- </query>
- </queryMap>
|
