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 ------------------------------------------------------------------------------- WHERE 'B' = 'B' AND A.STATUS_CD IN ('A') AND A.PRC_LINE = substr(:1,3,1)/*(转炉标准)*/ AND A.L2_SEND = 'N' 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 ]]>