<select id="chlTransQueryByChlType" parameterType="map" resultType="java.util.Map">
SELECT
A .*, (
SELECT
PARA_NAME
FROM
${MMC}.SYS_PARAM_INFO
WHERE
PAR_PARA_ID = 'CHNL_TYPE'
AND PARA_VALUE = A .CHL_TYPE
) AS CHNL_NAME
FROM
${MMC}.MKP_CHL_TRANS_CODE A
<where>
<if test="CHL_TYPE != null and CHL_TYPE != ''">
A.CHL_TYPE = #{CHL_TYPE}
</if>
<if test="SRC_TRANS_NAME != null and SRC_TRANS_NAME != ''">
AND A.SRC_TRANS_NAME like CONCAT('%',#{SRC_TRANS_NAME},'%')
</if>
</where>
</select>
