'S' --屏蔽酸洗线 20171222
AND NVL(A.EXTSHAPE_QUALITY, 'NULLP') NOT IN ('FP', 'CP') ---屏蔽废次卷
AND A.OLD_SAMPL_NO || '&' LIKE ? || '%'
AND A.SPEC_STL_GRD || '&' LIKE ? || '%'
AND A.CUR_LOAD_LOC LIKE ? || '%'
AND A.COIL_THK >= NVL(?, '000')
AND A.COIL_THK <= NVL(?, '999')
AND A.COIL_WTH >= NVL(?, '00000')
AND A.COIL_WTH <= NVL(?, '99999')
AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0)
AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999)
AND A.ORD_NO || '&' LIKE ? || '%'
AND A.CUR_PROG_CD || '&' LIKE ? || '%'
AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%'
AND E.SMP_SEND_DTIME || '&' LIKE ? || '%'
AND A.PRODNM_CD || '&' LIKE ? || '%'
AND A.ORD_FL || '&' LIKE ? || '%'
]]>
= NVL(?, '000')
AND A.COIL_THK <= NVL(?, '999')
AND A.COIL_WTH >= NVL(?, '00000')
AND A.COIL_WTH <= NVL(?, '99999')
AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 99999999999999), 1, 8) >= NVL(?, 0)
AND SUBSTR(NVL(A.YARD_ENTRY_DTIME, 0), 1, 8) <= NVL(?, 99999999999999)
AND A.ORD_NO || '&' LIKE ? || '%'
AND A.CUR_PROG_CD || '&' LIKE ? || '%'
AND C.ORD_DEVLMT_DATE || '&' LIKE ? || '%'
AND E.SMP_SEND_DTIME || '&' LIKE ? || '%'
AND A.PRODNM_CD || '&' LIKE ? || '%'
AND A.ORD_FL || '&' LIKE ? || '%'
]]>