XinYu_RZMES/.svn/pristine/d3/d3cb20a629140cbaee0d2fddd6a8dfca8fa699f7.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="Order Project A">

    <query id="UIA020010.LOV.SpecStlGrd.find" desc=" " fetchSize="10">
        <![CDATA[
SELECT SM_CFNM AS SPEC_STL_GRD_DESC, SM_CD AS SPEC_STL_GRD
FROM TBZ00_COMMCD
WHERE LG_CD = 'A02001'
AND USED_YN = 'Y'
ORDER BY CD_SEQ
        ]]>
    </query>


    <query id="UIA020010.LOV.DlvtGrpTp.find" desc=" " fetchSize="10">
        <![CDATA[
SELECT SM_CFNM AS DLVT_GRP_TP_DESC, SM_CD AS DLVT_GRP_TP
FROM TBZ00_COMMCD
WHERE LG_CD = 'A02002'
AND USED_YN = 'Y'
ORDER BY CD_SEQ
        ]]>
    </query>


    <query id="UIA020010.LOV.MaxPKValue.find" desc=" " fetchSize="10">
        <![CDATA[
SELECT NVL(MAX(ELMT_SEQ),0) AS MAX_ELMT_SEQ FROM TBA02_DLVT_ELMT
        ]]>
    </query>


	<query id="UIA020010.List.DlvtElement.find" desc=" " fetchSize="10">
        <![CDATA[
SELECT ELMT_SEQ, ELMT_DESC, DEFAULT_SEQ, TERM_DAYS, TERM_DAYS_DESC
     , REG_ID, TO_CHAR(TO_DATE(REG_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS REG_DTIME
     , MOD_ID, TO_CHAR(TO_DATE(MOD_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS MOD_DTIME
     ,'N' AS CHK
FROM TBA02_DLVT_ELMT
WHERE 1 = 1
AND ELMT_DESC LIKE '%'||:1||'%'
ORDER BY ELMT_SEQ
        ]]>
    </query>


    <query id="UIA020010.List.DlvtElement.insert" desc=" " fetchSize="10">
        <![CDATA[
INSERT INTO TBA02_DLVT_ELMT (ELMT_SEQ, ELMT_DESC, DEFAULT_SEQ, TERM_DAYS, TERM_DAYS_DESC, REG_ID, REG_DTIME, MOD_ID, MOD_DTIME) 
       VALUES ( :1, :2, :3, :4, :5, :6, TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'), :7, TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') )
        ]]>
    </query>


    <query id="UIA020010.List.DlvtElement.update" desc=" " fetchSize="10">
        <![CDATA[
UPDATE TBA02_DLVT_ELMT
SET ELMT_DESC = :1
  , DEFAULT_SEQ = :2
  , TERM_DAYS = :3
  , TERM_DAYS_DESC = :4
  , MOD_ID = :5
  , MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
WHERE ELMT_SEQ = :6
        ]]>
    </query>


    <query id="UIA020010.List.DlvtElement.delete" desc=" " fetchSize="10">
        <![CDATA[
DELETE FROM TBA02_DLVT_ELMT WHERE ELMT_SEQ = :1
        ]]>
    </query>


    <query id="UIA020010.List.DlvtDetail.find" desc=" " fetchSize="10">
        <![CDATA[
SELECT A.ELMT_SEQ, B.SPEC_STL_GRD, B.DLVT_GRP_TP, B.ELMT_SEQ, B.TERM_DAYS, B.TERM_DAYS_DESC
     , B.REG_ID, TO_CHAR(TO_DATE(B.REG_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS REG_DTIME
     , B.MOD_ID, TO_CHAR(TO_DATE(B.MOD_DTIME,'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS') AS MOD_DTIME
     , ROW_NUMBER() OVER (PARTITION BY A.ELMT_SEQ ORDER BY B.SPEC_STL_GRD, B.DLVT_GRP_TP) AS RN
     , Z.DLVT_GRP_TP_DESC
FROM TBA02_DLVT_ELMT A, TBA02_DLVT_DTL B
   ,(SELECT SM_CFNM AS DLVT_GRP_TP_DESC, SM_CD AS DLVT_GRP_TP
     FROM TBZ00_COMMCD
     WHERE LG_CD = 'A02002') Z
WHERE 1 = 1
AND B.DLVT_GRP_TP = Z.DLVT_GRP_TP(+)
AND A.ELMT_SEQ = B.ELMT_SEQ(+)
AND A.ELMT_DESC LIKE '%'||:1||'%'
        ]]>
    </query>


</queryMap>