= :1) AND (SUBSTR(A.YARD_ENTRY_DTIME,1,8) <= :2) AND A.OLD_SAMPL_NO LIKE :3||'%' AND A.COIL_THK >= NVL(:4,'000') AND A.COIL_THK <= NVL(:5,'999') AND A.COIL_WTH >= NVL(:6,'00000') AND A.COIL_WTH <= NVL(:7,'99999') AND (A.CUR_LOAD_LOC LIKE :8||'%' OR A.CUR_LOAD_LOC IS NULL) AND A.SPEC_STL_GRD LIKE :9||'%' AND A.YARD_ENTRY_SHIFT||'&' LIKE :10||'%' AND A.YARD_ENTRY_GROUP||'&' LIKE :11||'%' AND A.YARD_ENTRY_REG||'&' LIKE :12||'%' AND A.TRANS_CAR_NO||'&' LIKE :13||'%' AND A.ORD_NO||'&' LIKE :14||'%' AND A.ORD_SEQ||'&' LIKE :15||'%' AND A.DLIV_DIRNO||'&' LIKE :l6||'%' AND D.ORDCUST_CD||'&' LIKE :17||'%' AND A.DLIV_TP||'&' LIKE :18||'%' AND A.COIL_DEFECTIVE||'&' LIKE :19||'%' AND A.ORD_FL||'&' LIKE :20||'%' AND A.QK_YN||'&' LIKE :21||'%' AND INSTR(NVL(:22 , NVL(D.PRDNM_CD,'NULL')) , NVL(D.PRDNM_CD,'NULL')) > 0 AND C.XSQY||'&' like :23||'%' --AND A.COIL_STAT = '2' and a.SPM_YN||'&' like :24||'%' AND A.COIL_IN_REG IS NULL -- ADD BY JUNGAN 2010-12-29 不查询盘入记录 order by a.OLD_SAMPL_NO desc ]]> = :1) --or (a.QK_YN = 'Y' and SUBSTR(a.QK_REG_DTIME,1,8)>= :2)) AND (SUBSTR(A.TRNF_DTIME,1,8) <= :2) --or (a.QK_YN = 'Y' and SUBSTR(a.QK_REG_DTIME,1,8)<= :4)) and a.COIL_STAT = '3' AND nvl(a.ISDIVI,1) <> '0' AND A.OLD_SAMPL_NO LIKE :3||'%' AND A.COIL_THK >= NVL(:4,'000') AND A.COIL_THK <= NVL(:5,'999') AND A.COIL_WTH >= NVL(:6,'00000') AND A.COIL_WTH <= NVL(:7,'99999') AND (A.CUR_LOAD_LOC LIKE :8||'%' OR A.CUR_LOAD_LOC IS NULL) AND A.SPEC_STL_GRD LIKE :9||'%' AND A.TRNF_SHIFT||'&' LIKE :10||'%' AND A.TRNF_GROUP||'&' LIKE :11||'%' AND A.TRNF_REG||'&' LIKE :12||'%' AND A.TRANS_CAR_NO||'&' LIKE :13||'%' AND A.ORD_NO||'&' LIKE :14||'%' AND A.ORD_SEQ||'&' LIKE :15||'%' AND A.DLIV_DIRNO||'&' LIKE :l6||'%' AND D.ORDCUST_CD||'&' LIKE :17||'%' AND A.DLIV_TP||'&' LIKE :18||'%' AND A.COIL_DEFECTIVE||'&' LIKE :19||'%' AND A.ORD_FL||'&' LIKE :20||'%' AND A.QK_YN||'&' LIKE :21||'%' AND INSTR(NVL(:22 , NVL(D.PRDNM_CD,'NULL')) , NVL(D.PRDNM_CD,'NULL')) > 0 AND C.XSQY||'&' like :23||'%' and a.SPM_YN||'&' like :24||'%' AND (A.SHIP_PROG_CD <> '10' or A.SHIP_PROG_CD IS NULL) -- ADD BY JUNGAN 2010-12-29 不查询盘出记录 order by a.OLD_SAMPL_NO desc ]]> = :1) AND (SUBSTR(A.YARD_ENTRY_DTIME,1,8) <= :2) AND A.OLD_SAMPL_NO LIKE :3||'%' AND A.COIL_THK >= NVL(:4,'000') AND A.COIL_THK <= NVL(:5,'999') AND A.COIL_WTH >= NVL(:6,'00000') AND A.COIL_WTH <= NVL(:7,'99999') AND (A.CUR_LOAD_LOC LIKE :8||'%' OR A.CUR_LOAD_LOC IS NULL) AND A.SPEC_STL_GRD LIKE :9||'%' AND A.YARD_ENTRY_SHIFT||'&' LIKE :10||'%' AND A.YARD_ENTRY_GROUP||'&' LIKE :11||'%' AND A.YARD_ENTRY_REG||'&' LIKE :12||'%' AND A.TRANS_CAR_NO||'&' LIKE :13||'%' AND A.ORD_NO||'&' LIKE :14||'%' AND A.ORD_SEQ||'&' LIKE :15||'%' AND A.DLIV_DIRNO||'&' LIKE :l6||'%' AND D.ORDCUST_CD||'&' LIKE :17||'%' AND A.DLIV_TP||'&' LIKE :18||'%' AND A.COIL_DEFECTIVE||'&' LIKE :19||'%' AND A.ORD_FL||'&' LIKE :20||'%' AND A.QK_YN||'&' LIKE :21||'%' AND INSTR(NVL(:22 , NVL(D.PRDNM_CD,'NULL')) , NVL(D.PRDNM_CD,'NULL')) > 0 AND C.XSQY||'&' like :23||'%' and a.SPM_YN||'&' like :24||'%' --AND A.COIL_STAT = '2' AND A.COIL_IN_REG IS NULL -- ADD BY JUNGAN 2010-12-29 不查询盘入记录 ]]> = :1) --or (a.QK_YN = 'Y' and SUBSTR(a.QK_REG_DTIME,1,8)>= :2)) AND (SUBSTR(A.TRNF_DTIME,1,8) <= :2) --or (a.QK_YN = 'Y' and SUBSTR(a.QK_REG_DTIME,1,8)<= :4)) AND A.OLD_SAMPL_NO LIKE :3||'%' AND A.COIL_THK >= NVL(:4,'000') AND A.COIL_THK <= NVL(:5,'999') AND A.COIL_WTH >= NVL(:6,'00000') AND A.COIL_WTH <= NVL(:7,'99999') AND (A.CUR_LOAD_LOC LIKE :8||'%' OR A.CUR_LOAD_LOC IS NULL) AND A.SPEC_STL_GRD LIKE :9||'%' AND A.TRNF_SHIFT||'&' LIKE :10||'%' AND A.TRNF_GROUP||'&' LIKE :11||'%' AND A.TRNF_REG||'&' LIKE :12||'%' AND A.TRANS_CAR_NO||'&' LIKE :13||'%' AND A.ORD_NO||'&' LIKE :14||'%' AND A.ORD_SEQ||'&' LIKE :15||'%' AND A.DLIV_DIRNO||'&' LIKE :l6||'%' AND D.ORDCUST_CD||'&' LIKE :17||'%' AND A.DLIV_TP||'&' LIKE :18||'%' AND A.COIL_DEFECTIVE||'&' LIKE :19||'%' AND A.ORD_FL||'&' LIKE :20||'%' AND A.QK_YN||'&' LIKE :21||'%' AND INSTR(NVL(:22 , NVL(D.PRDNM_CD,'NULL')) , NVL(D.PRDNM_CD,'NULL')) > 0 AND C.XSQY||'&' like :23||'%' and a.SPM_YN||'&' like :24||'%' AND (A.SHIP_PROG_CD <> '10' or A.SHIP_PROG_CD IS NULL) -- ADD BY JUNGAN 2010-12-29 不查询盘出记录 ]]>