= 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 SUBSTR(A.APPOINT_DTIME ,1,8 ) >= NVL(:8,'00000000') AND SUBSTR(A.APPOINT_DTIME ,1,8 ) <= NVL(:9,'99999999') AND A.CUR_LOAD_LOC||'&' LIKE :10||'%' AND A.COIL_STAT = :11 ]]> SELECT SM_CFNM LABEL , SM_CD VALUE FROM TBZ00_COMMCD T WHERE LG_CD='H02001' AND T.USED_YN = 'Y'