= ?) AND (SUBSTR(A.YARD_ENTRY_DTIME,1,8) <= ?) AND A.OLD_SAMPL_NO >= NVL(?, 'L0-000000-10') --20130104 AND A.OLD_SAMPL_NO <= NVL(?, 'L99-999999-10') --20130104 --AND (SUBSTR(A.OLD_SAMPL_NO,1,9))>=(NVL(?,'L1-000000')) --AND (SUBSTR(A.OLD_SAMPL_NO,1,9))<=(NVL(?,'L9-999999')) 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 (A.CUR_LOAD_LOC LIKE ?||'%' OR A.CUR_LOAD_LOC IS NULL) AND A.SPEC_STL_GRD||'&' LIKE ?||'%' AND A.YARD_ENTRY_SHIFT||'&' LIKE ?||'%' AND A.YARD_ENTRY_GROUP||'&' LIKE ?||'%' AND (SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG)||'&' LIKE ?||'%' AND D.ORDCUST_CD||'&' LIKE ?||'%' AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.PRODNM_CD||'&' LIKE ?||'%' --AND A.OLD_SAMPL_NO||'&' LIKE ?||'%' AND (NVL(SUBSTR(C.ORD_DEVLMT_DATE, 1, 8),(SUBSTR(A.YARD_ENTRY_DTIME, 1, 8))) >= NVL(?,'0')) AND (NVL(SUBSTR(C.ORD_DEVLMT_DATE, 1, 8),(SUBSTR(A.YARD_ENTRY_DTIME, 1, 8))) <= NVL(?,'99999999')) AND NVL(A.LINE_TP,'P')=? order by a.YARD_ENTRY_DTIME,a.spec_stl_grd,a.instr_coil_thk,a.instr_coil_wth ) A ]]> = ?) AND (SUBSTR(A.TRNF_DTIME,1,8) <= ?) and a.COIL_STAT = '3' AND A.OLD_SAMPL_NO >= NVL(?, 'L0-000000-10') --20130104 AND A.OLD_SAMPL_NO <= NVL(?, 'L99-999999-10') --20130104 --AND (SUBSTR(A.OLD_SAMPL_NO,1,9))>=(NVL(?,'L1-000000')) --AND (SUBSTR(A.OLD_SAMPL_NO,1,9))<=(NVL(?,'L9-999999')) 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 (A.CUR_LOAD_LOC LIKE ?||'%' OR A.CUR_LOAD_LOC IS NULL) AND A.SPEC_STL_GRD LIKE ?||'%' AND A.TRNF_SHIFT||'&' LIKE ?||'%' AND A.TRNF_GROUP||'&' LIKE ?||'%' AND (SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.TRNF_REG)||'&' LIKE ?||'%' AND D.ORDCUST_CD||'&' LIKE ?||'%' AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.PRODNM_CD||'&' LIKE ?||'%' -- AND A.OLD_SAMPL_NO||'&' LIKE ?||'%' AND (NVL(SUBSTR(C.ORD_DEVLMT_DATE, 1, 8),(SUBSTR(A.TRNF_DTIME, 1, 8))) >= NVL(?,'0')) AND (NVL(SUBSTR(C.ORD_DEVLMT_DATE, 1, 8),(SUBSTR(A.TRNF_DTIME, 1, 8))) <= NVL(?,'99999999')) AND NVL(A.LINE_TP,'P')=? order by a.TRNF_Dtime,a.spec_stl_grd,a.instr_coil_thk,a.instr_coil_wth ) A ]]> = ?) AND (SUBSTR(A.YARD_ENTRY_DTIME,1,8) <= ?) AND A.OLD_SAMPL_NO >= NVL(?, 'Y0000000S0101') --20130104 AND A.OLD_SAMPL_NO <= NVL(?, 'Y9999999S0101') --20130104 --AND (SUBSTR(A.OLD_SAMPL_NO,1,9))>=(NVL(?,'L1-000000')) --AND (SUBSTR(A.OLD_SAMPL_NO,1,9))<=(NVL(?,'L9-999999')) 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 (A.CUR_LOAD_LOC LIKE ?||'%' OR A.CUR_LOAD_LOC IS NULL) AND A.SPEC_STL_GRD||'&' LIKE ?||'%' AND A.YARD_ENTRY_SHIFT||'&' LIKE ?||'%' AND A.YARD_ENTRY_GROUP||'&' LIKE ?||'%' AND (SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.YARD_ENTRY_REG)||'&' LIKE ?||'%' AND D.ORDCUST_CD||'&' LIKE ?||'%' AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.PRODNM_CD||'&' LIKE ?||'%' --AND A.OLD_SAMPL_NO||'&' LIKE ?||'%' AND (NVL(SUBSTR(C.ORD_DEVLMT_DATE, 1, 8),(SUBSTR(A.YARD_ENTRY_DTIME, 1, 8))) >= NVL(?,'0')) AND (NVL(SUBSTR(C.ORD_DEVLMT_DATE, 1, 8),(SUBSTR(A.YARD_ENTRY_DTIME, 1, 8))) <= NVL(?,'99999999')) AND NVL(A.LINE_TP,'P')=? order by a.YARD_ENTRY_DTIME,a.spec_stl_grd,a.instr_coil_thk,a.instr_coil_wth ) A ]]> = ?) AND (SUBSTR(A.TRNF_DTIME,1,8) <= ?) and a.COIL_STAT = '3' AND A.OLD_SAMPL_NO >= NVL(?, 'Y0000000S0101') --20130104 AND A.OLD_SAMPL_NO <= NVL(?, 'Y9999999S0101') --20130104 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 (A.CUR_LOAD_LOC LIKE ?||'%' OR A.CUR_LOAD_LOC IS NULL) AND A.SPEC_STL_GRD LIKE ?||'%' AND A.TRNF_SHIFT||'&' LIKE ?||'%' AND A.TRNF_GROUP||'&' LIKE ?||'%' AND (SELECT USERNAME FROM CORE_APP_USER U WHERE U.USERID = A.TRNF_REG)||'&' LIKE ?||'%' AND D.ORDCUST_CD||'&' LIKE ?||'%' AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.PRODNM_CD||'&' LIKE ?||'%' -- AND A.OLD_SAMPL_NO||'&' LIKE ?||'%' AND (NVL(SUBSTR(C.ORD_DEVLMT_DATE, 1, 8),(SUBSTR(A.TRNF_DTIME, 1, 8))) >= NVL(?,'0')) AND (NVL(SUBSTR(C.ORD_DEVLMT_DATE, 1, 8),(SUBSTR(A.TRNF_DTIME, 1, 8))) <= NVL(?,'99999999')) AND NVL(A.LINE_TP,'P')=? order by a.TRNF_Dtime,a.spec_stl_grd,a.instr_coil_thk,a.instr_coil_wth ) A ]]>