= ?) AND(SUBSTR(A.YARD_ENTRY_DTIME,1,8) <= ?) -- AND A.COIL_NO >= NVL(?, 'R0-000000A000') --20130104 --AND A.COIL_NO <= NVL(?, 'R99-999999A999') --20130104 AND (SUBSTR(A.COIL_NO,1,10))>=(NVL(?,'R0-0000000')) AND (SUBSTR(A.COIL_NO,1,10))<=(NVL(?,'R9-9999999')) 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.STL_GRD LIKE ?||'%' AND A.YARD_ENTRY_SHIFT||'&' LIKE ?||'%' AND A.YARD_ENTRY_GROUP||'&' LIKE ?||'%' AND A.YARD_ENTRY_REG||'&' LIKE ?||'%' AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND D.ORDCUST_CD||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.PRODNM_CD||'&' LIKE ?||'%' AND '-1' <> nvl(?,'0') AND A.COIL_NO||'&' LIKE ?||'%' AND (NVL(SUBSTR(F.DEL_TO_DATE, 1, 8),(SUBSTR(A.YARD_ENTRY_DTIME, 1, 8))) >= NVL(?,'0')) AND (NVL(SUBSTR(F.DEL_TO_DATE, 1, 8),(SUBSTR(A.YARD_ENTRY_DTIME, 1, 8))) <= NVL(?,'99999999')) AND nvl(SUBSTR(A.CUR_LOAD_LOC,1,1),'%') LIKE ?||'%' order by a.YARD_ENTRY_DTIME,a.spec_stl_grd,a.instr_coil_thk,a.instr_coil_wth) TS ]]> 'E') R, TBE02_ORD_PRC F, (SELECT * FROM S_TBF03_SPEC_MILL WHERE STATUS_CD<>'E') H, C_TBL02_COIL_COMM J, TBH02_COIL_COMM T1 WHERE '1' = '1' AND A.SLAB_NO = B.SLAB_NO(+) AND A.OLD_SAMPL_NO = T1.OLD_SAMPL_NO AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.OLD_ORD_NO = F.ORD_NO(+) AND A.OLD_ORD_SEQ = F.ORD_SEQ(+) and R.COIL_NO(+) =A.OLD_SAMPL_NO --屏蔽吊销 and H.COIL_NO(+) =A.OLD_SAMPL_NO AND A.OLD_SAMPL_NO=J.H_COIL_NO1(+) -- AND J.COIL_STAT IN('2','3') -- and (r.STATUS_CD <> 'E' or r.STATUS_CD is null ) -- and (H.STATUS_CD <> 'E' or H.STATUS_CD is null ) --and ((r.STATUS_CD <> 'E' or r.STATUS_CD is null) or -- (H.STATUS_CD <> 'E' or H.STATUS_CD is null)) /* and (((r.STATUS_CD <> 'E' or r.STATUS_CD is null) AND H.STATUS_CD IS NULL) or ((H.STATUS_CD <> 'E' or H.STATUS_CD is null) AND R.STATUS_CD IS NULL))*/ /* AND (((r.STATUS_CD <> 'E' or r.STATUS_CD is null OR (r.STATUS_CD='E' AND A.COIL_STAT='3')) AND H.STATUS_CD IS NULL) or ((H.STATUS_CD <> 'E' or H.STATUS_CD is null OR (H.STATUS_CD='E' AND A.COIL_STAT='3')) AND R.STATUS_CD IS NULL)) */--20191030 AND (SUBSTR(A.TRNF_DTIME,1,8) >= ?) AND (SUBSTR(A.TRNF_DTIME,1,8) <= ?) AND (SUBSTR(NVL(J.COIL_NO,'L0-000000'),1,9))>=(NVL(?,'L0-000000')) --20130130 AND (SUBSTR(NVL(J.COIL_NO,'L0-000000'),1,9))<=(NVL(?,'L9-999999')) --20130130 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.STL_GRD LIKE ?||'%' AND A.TRNF_SHIFT||'&' LIKE ?||'%' AND A.TRNF_GROUP||'&' LIKE ?||'%' AND A.TRNF_REG||'&' LIKE ?||'%' AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_SEQ||'&' LIKE ?||'%' AND D.ORDCUST_CD||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.PRODNM_CD||'&' LIKE ?||'%' AND A.OUT_YARD_KIND||'&' LIKE ?||'%' AND A.COIL_NO ||'&' LIKE ?||'%' AND (NVL(SUBSTR(F.DEL_TO_DATE, 1, 8),(SUBSTR(A.TRNF_DTIME, 1, 8))) >= NVL(?,'0')) AND (NVL(SUBSTR(F.DEL_TO_DATE, 1, 8),(SUBSTR(A.TRNF_DTIME, 1, 8))) <= NVL(?,'99999999')) AND nvl(SUBSTR(A.CUR_LOAD_LOC,1,1),'%') LIKE ?||'%' order by a.TRNF_DTIME,a.spec_stl_grd,a.instr_coil_thk,a.instr_coil_wth) TS) A ]]>