= ? AND SUBSTR(A.MILL_DTIME, 1, 12) <= ? AND A.OLD_SAMPL_NO LIKE ? || '%' AND B.MISSNO_CLF_CD IS NULL order by a.MILL_DTIME ]]> = ? AND SUBSTR(A.SPM_DTIME, 1, 8) <= ? AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.SLAB_NO = D.SLAB_NO -- AND nvl(a.SPM_SHIFT, '空') like nvl(:3, '%') -- AND nvl(a.SPM_GROUP, '空') like nvl(:4, '%') AND A.OLD_SAMPL_NO LIKE ? || '%' and nvl(a.ISDIVI,'1')<>'0' order by A.MILL_DTIME ]]> = ? AND SUBSTR(A.MILL_DTIME, 1, 12) <= ? AND A.OLD_SAMPL_NO LIKE ? || '%' AND B.MISSNO_CLF_CD IS NULL --AND A.CUR_PROG_CD IN('SFA','DED') order by a.MILL_DTIME ]]>