= NVL(:3,'000') AND A.COIL_THK <= NVL(:4,'999') AND A.COIL_WTH >= NVL(:5,'00000') AND A.COIL_WTH <= NVL(:6,'99999') AND A.CUR_PROG_CD||'&' LIKE :7||'%' AND INSTR(NVL(:8 , NVL(A.APPOINT_YN,'N')) , NVL(A.APPOINT_YN,'N')) > 0 ---zhiding AND A.CUR_LOAD_LOC||'&' LIKE :9||'%' AND A.COIL_STAT IN (:10) AND A.ORD_NO ||'&' LIKE :11||'%' AND NVL(H.REG_DTIME,'NULL') LIKE :12||'%'----待定 AND A.DLIV_DIRNO IS NULL AND A.APPOINT_NOTE IS NULL ]]>