'D' ]]> 'D' and (select count(COIL_NO) from tbf05_spec_mill where SPM_MANA_NO = (select t.SPM_MANA_NO from tbf05_spec_mill t where t.COIL_NO = substr(?,1,12)||'0')) = (select count(COIL_NO) from tbf05_spec_mill where SPM_MANA_NO = (select t.SPM_MANA_NO from tbf05_spec_mill t where t.COIL_NO = substr(?,1,12)||'0') and (STATUS_CD = 'D' OR STATUS_CD = 'E')) ]]>