>BOF'),'C','>>CAS'),'L','>>LF'),'R','>>RH'),'V','>>VD'),'J','>>CCM') LINE_PROC_CD ,/*处理路径代码*/ B.CCM_THK ,/*浇铸厚度*/ B.CCM_WTH ,/*浇铸宽度*/ B.ORD_SLAB_CNT ,/*订单板坯块数*/ B.NONORD_SLAB_CNT ,/*余材板坯块数*/ B.PRE_BOF_STR_DTIME ,/*计划出钢开始*/ T1.SM_CFNM PROG_CD ,/*进程代码*/ T3.SM_CFNM STATUS_CD ,/*状态区分*/ T2.SM_CFNM HCR_CLF ,/*热送代*/ A.L2_SEND ,/*L2传送*/ B.MILL_FL, /*轧制编制区分*/ B.CHARGE_EDT_SEQ/* 炉次编制号*/ FROM TBF01_CHARGE_IDX A, TBF01_SPEC_CHARGE B, (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002') T1, (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T2, (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'Z01001') T3 WHERE A.STATUS_CD = 'A' AND A.L2_SEND = 'N' AND B.HCR_CLF = T2.SM_CD AND B.PROG_CD = T1.SM_CD AND B.STATUS_CD = T3.SM_CD AND A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND B.STL_GRD LIKE ?||'%' AND A.PRC_LINE LIKE ?||'%' AND A.CCM_PRC_LINE LIKE ?||'%' AND A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ ORDER BY A.CHG_SEQ ASC ]]> >BOF'),'C','>>CAS'),'L','>>LF'),'R','>>RH'),'V','>>VD'),'J','>>CCM') SM_CFNM ,A.SM_EFNM FROM ( SELECT INSTR(T1.SM_CFNM,NVL(:1,T1.SM_CFNM),1) BOF ,INSTR(T1.SM_CFNM,NVL(:2,T1.SM_CFNM),1) CAS ,INSTR(T1.SM_CFNM,NVL(:3,T1.SM_CFNM),1) LF ,INSTR(T1.SM_CFNM,NVL(:4,T1.SM_CFNM),1) RH ,INSTR(T1.SM_CFNM,NVL(:5,T1.SM_CFNM),1) VD ,INSTR(T1.SM_CFNM,NVL(:6,T1.SM_CFNM),1) CCM ,T1.* FROM TBZ00_COMMCD T1 WHERE T1.LG_CD = 'F01004' AND LENGTHB(T1.SM_CFNM) = :7 ) A WHERE BOF > 0 AND CAS > 0 AND LF > 0 AND RH > 0 AND VD > 0 AND CCM > 0 ]]>