0 THEN 'Y' ELSE '' END) L2DEMO --中厚板特殊要求 ,B.INS_CHARGE_STR_DTIME --计划炼钢起始时间 ,B.INS_CHARGE_END_DTIME --计划炼钢截止时间 ,C.DIVIDE_CHARGE_YN ,B.CHARGE_RT FROM TBF01_CHARGE_IDX A, TBF01_SPEC_CHARGE B, TBG02_CHARGE_COMM C, (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, ---------------------------------------------------------------------------- --MODIFY: BY SJW 090828 --DESC : 王艳辉要求增加显示客服特殊要求 --VERSION:1.8-->1.9 (SELECT DISTINCT B.CHARGE_MANA_NO,'1' DSN_KIND FROM TBF01_SPEC_CHARGE A ,TBF01_SPEC_SLAB B ,TBB01_ORD_HEAD C WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND B.ORD_NO = C.ORD_NO AND B.ORD_SEQ = C.ORD_SEQ AND A.STATUS_CD IN ('A','B') AND C.CUST_SPEC_NO_INGR IS NOT NULL) D ------------------------------------------------------------------------------- /*--MODIFY: BY WXY 100526 --DESC : 王艳辉要求增加显示中厚板客户特殊要求 ,( SELECT WMSYS.WM_CONCAT(DISTINCT C.SPEC_REQ_DESC) L2DEMO ,SUBSTR(C.SLAB_MANA_NO,1,10) CHARGE_MANA_NO FROM TBF01_SPEC_SLAB C WHERE SPEC_REQ_DESC IS NOT NULL GROUP BY SUBSTR(C.SLAB_MANA_NO,1,10)) E ------------------------------------------------------------------------------- */ WHERE 'B' = ? AND A.STATUS_CD IN ('A','B') AND A.PRC_LINE = '1' /*(转炉标准)*/ AND A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND B.CHARGE_MANA_NO = C.NEW_PLAN_CHARGE_NO(+) AND B.PROG_CD = T1.SM_CD(+) AND B.HCR_CLF = T2.SM_CD AND B.STATUS_CD = T3.SM_CD AND B.CHARGE_RT LIKE ? ---------------------------------------------------------- --MODIFY: BY SJW 090828 --DESC : 王艳辉要求增加显示客户特殊要求 --VERSION:1.8-->1.9 AND B.CHARGE_MANA_NO = D.CHARGE_MANA_NO(+) ---------------------------------------------------------- /*--MODIFY: BY WXY 100526 --DESC : 王艳辉要求增加显示中厚板客户特殊要求 AND B.CHARGE_MANA_NO = E.CHARGE_MANA_NO(+) ---------------------------------------------------------- */ ORDER BY A.CHG_SEQ ASC ]]> 0 then 'Y' else '' end) L2DEMO ,B.INS_CHARGE_STR_DTIME --计划炼钢起始时间 ,B.INS_CHARGE_END_DTIME --计划炼钢截止时间 ,C.DIVIDE_CHARGE_YN ,B.CHARGE_RT FROM TBF01_CHARGE_IDX A, TBF01_SPEC_CHARGE B, TBG02_CHARGE_COMM C, (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, ---------------------------------------------------------------------------- --MODIFY: BY SJW 090828 --DESC : 王艳辉要求增加显示客服特殊要求 --VERSION:1.8-->1.9 (SELECT DISTINCT B.CHARGE_MANA_NO,'1' DSN_KIND FROM TBF01_SPEC_CHARGE A ,TBF01_SPEC_SLAB B ,TBB01_ORD_HEAD C WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND B.ORD_NO = C.ORD_NO AND B.ORD_SEQ = C.ORD_SEQ AND A.STATUS_CD IN ('A','B') AND C.CUST_SPEC_NO_INGR IS NOT NULL) D ------------------------------------------------------------------------------- /*--MODIFY: BY WXY 100526 --DESC : 王艳辉要求增加显示中厚板客户特殊要求 ,( SELECT wmsys.wm_concat(DISTINCT c.SPEC_REQ_DESC) L2DEMO ,substr(c.SLAB_MANA_NO,1,10) CHARGE_MANA_NO FROM TBF01_SPEC_SLAB C WHERE SPEC_REQ_DESC IS NOT NULL GROUP BY substr(c.SLAB_MANA_NO,1,10)) E ------------------------------------------------------------------------------- */ WHERE 'B' = ? AND A.STATUS_CD IN ('A','B') AND A.PRC_LINE = '2' /*(转炉标准)*/ AND A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND B.CHARGE_MANA_NO = C.NEW_PLAN_CHARGE_NO(+) AND B.PROG_CD = T1.SM_CD(+) AND B.HCR_CLF = T2.SM_CD AND B.STATUS_CD = T3.SM_CD AND B.CHARGE_RT like ? ---------------------------------------------------------- --MODIFY: BY SJW 090828 --DESC : 王艳辉要求增加显示客服特殊要求 --VERSION:1.8-->1.9 AND B.CHARGE_MANA_NO = D.CHARGE_MANA_NO(+) /*---------------------------------------------------------- --MODIFY: BY WXY 100526 --DESC : 王艳辉要求增加显示中厚板客户特殊要求 AND B.CHARGE_MANA_NO = E.CHARGE_MANA_NO(+) ---------------------------------------------------------- */ ORDER BY A.CHG_SEQ ASC ]]> 1.9 (SELECT DISTINCT B.CHARGE_MANA_NO,C.DSN_KIND FROM TBF01_SPEC_CHARGE A ,TBF01_SPEC_SLAB B ,TBB01_ORD_INGR C WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND B.ORD_NO = C.ORD_NO AND B.ORD_SEQ = C.ORD_SEQ AND A.STATUS_CD IN ('A','B') AND C.DSN_KIND = '1') D ------------------------------------------------------------------------------- WHERE 'C' = ? AND A.STATUS_CD IN ('A','B') AND A.CCM_PRC_LINE = '1'/*(连铸标准)*/ AND A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND B.CHARGE_MANA_NO = C.NEW_PLAN_CHARGE_NO(+) AND B.PROG_CD = T1.SM_CD AND B.HCR_CLF = T2.SM_CD AND B.STATUS_CD = T3.SM_CD AND B.CHARGE_RT like ? ---------------------------------------------------------- --MODIFY: BY SJW 090828 --DESC : 王艳辉要求增加显示客服特殊要求 --VERSION:1.8-->1.9 AND B.CHARGE_MANA_NO = D.CHARGE_MANA_NO(+) ---------------------------------------------------------- ORDER BY A.CHG_SEQ ASC ]]> 1.9 (SELECT DISTINCT B.CHARGE_MANA_NO,C.DSN_KIND FROM TBF01_SPEC_CHARGE A ,TBF01_SPEC_SLAB B ,TBB01_ORD_INGR C WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND B.ORD_NO = C.ORD_NO AND B.ORD_SEQ = C.ORD_SEQ AND A.STATUS_CD IN ('A','B') AND C.DSN_KIND = '1') D ------------------------------------------------------------------------------- WHERE 'C' = ? AND A.STATUS_CD IN ('A','B') AND A.CCM_PRC_LINE = '2'/*(连铸标准)*/ AND A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND B.CHARGE_MANA_NO = C.NEW_PLAN_CHARGE_NO(+) AND B.PROG_CD = T1.SM_CD AND B.HCR_CLF = T2.SM_CD AND B.STATUS_CD = T3.SM_CD AND B.CHARGE_RT like ? ---------------------------------------------------------- --MODIFY: BY SJW 090828 --DESC : 王艳辉要求增加显示客服特殊要求 --VERSION:1.8-->1.9 AND B.CHARGE_MANA_NO = D.CHARGE_MANA_NO(+) ---------------------------------------------------------- ORDER BY A.CHG_SEQ ASC ]]>