• - AI 대상목록 SQL 변경
    
    	<!-- AI 작업리스트 -->
    	<select id="getAiReadData" parameterType="map" resultType="map">
    		SELECT DISTINCT sys_se
    		     , accnut_ym
    		     , cpr_code    --자기법인
    		     , partn_cpr   --상대법인
    		     , delng_crncy --통화유형
    		FROM   PUBLIC.BATCH_TBCR_INNER_DELNG
    		WHERE  SYS_SE = #{sysSe}
    		AND    ACCNUT_YM = #{accnutYm}
    		AND    MTCH_KY IS NULL
    		AND    DTA_TY IN ('11','12','21','22','41','42')
    		AND    CPR_CODE != 'OTHER'
    		AND    PARTN_CPR != 'OTHER'
    	</select>
    ggun12 authored
     
    Browse File »