XinYu_RZMES/.svn/pristine/a7/a72f1cb8b1d58ec3e3f841634477398a2bf5c139.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Project T">
    <query id="ExcelPrint.SearchCommCd.find" desc="ExcelPrint Example.Select" fetchSize="10">
        <![CDATA[
SELECT LG_CD, LG_NM
     , SM_CD, SM_CFNM, SM_CSNM, SM_EFNM, SM_ESNM
     , BIZ_CLF, CD_SEQ, USED_YN, CD_DESC, CD_LEN
     , MOD_ID, TO_CHAR(TO_DATE(MOD_DATE,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS MOD_DATE
FROM TBZ00_COMMCD
WHERE LG_CD LIKE :1||'%'
AND USED_YN = 'Y'
ORDER BY CD_SEQ
        ]]>
    </query>
    <query id="ExcelPrint.SearchLgCdLOV.search" desc="ExcelPrint Example.Select" fetchSize="10">
        <![CDATA[
SELECT UNIQUE LG_CD, '('||LG_CD||') '||LG_NM AS LG_NM
FROM TBZ00_COMMCD
WHERE 1 = 1
ORDER BY LG_CD
        ]]>
    </query>

</queryMap>