<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: wujun  
    $Date: 2017-2-15 15:03:09  
    $Revision: 1.0  
    $Purpose: 央行调息数据查询主界面
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
            select * from(
            select cbai.batch_hd_id,
			       cbai.batch_num,  --调息编号
			       cbai.description,
			       cbai.batch_wfl_instance_id
			  from con_batch_adjust_interest_hd cbai
			 where cbai.approval_status = 'APPROVED'
			   and nvl(cbai.document_category,'CONTRACT') = 'CONTRACT'
			 ) t1 #WHERE_CLAUSE# order by t1.batch_num
			 ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:query-fields>
        <bm:query-field name="batch_num" queryExpression="t1.batch_num like &apos;%&apos;||${@batch_num}||&apos;%&apos;"/>
        <bm:query-field name="description" queryExpression="t1.description like &apos;%&apos;||${@description}||&apos;%&apos;"/>
    </bm:query-fields>
</bm:model>
