切割待机正在作业板坯信息图表****************************/ SELECT A.Charge_Edt_Seq, A.CHARGE_MANA_NO, B.Chg_Seq, C.SLAB_EDT_SEQ, /*板坯编制号*/ C.SLAB_EDT_SEQ, /*板坯编号*/ /* C.ORD_WTH, \*slab宽度*\ C.ORD_THK, \*轧制厚度*\*/ D.WTH_AIM, D.HOT_THK_AIM, C.HCR_CLF, /*热装状态*/ C.ORD_FL FROM TBF01_SPEC_CHARGE A, TBF01_CHARGE_IDX B, TBF01_SPEC_SLAB C, TBB01_ORD_PROD D WHERE A.STATUS_CD IN ('B') AND C.ORD_NO = D.ORD_NO(+) AND C.ORD_SEQ = D.ORD_SEQ(+) AND A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND A.PROG_CD >='JBB' AND A.CHARGE_EDT_SEQ = C.CHARGE_EDT_SEQ ORDER BY A.PRE_CCM_END_DTIME ASC, C.CHARGE_SLAB_SEQ ASC /*************************************************************************************/ ]]> = 'JBB' AND B.PROG_CD = T1.SM_CD(+) GROUP BY T.CHARGE_EDT_SEQ ,T.CHARGE_MANA_NO,B.PRE_CCM_END_DTIME,B.MILL_FL,B.HCR_CLF, T1.SM_CFNM ORDER BY B.PRE_CCM_END_DTIME ]]>