= ? || LPAD(TO_CHAR(?), 4, 0) -- AND A.HCR_CLF = T3.SM_CD AND b.ORD_USE_CD = T4.SM_CD(+) ORDER BY A.SPM_NO ASC, A.SPM_EDT_SEQ ASC /***************************************************************************************/ ]]> 'A7T' and t.SLAB_NO = t1.SLAB_NO group by SUBSTR(t1.CUR_LOAD_LOC,1,6) ]]>