<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-5-8 下午6:38:23  
    $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 p.prj_bp_id,
            to_char(pbp.prj_bp_id) prj_bp_id,
       pbp.project_id,
       p.pro_tenant_guarantee_type,--担保类型
       p.pro_tenant_guarantee_number,--笔数
       trim(to_char(p.pro_tenant_guarantee_amount,'999,999,999,990.99')) pro_tenant_guarantee_amount,--担保金额
       p.pro_tenant_guarantee_company,--担保企业数量
       p.pro_tenant_guarantee_situation,--被担保企业情况
       p.pro_tenant_guarantee_note--备注
 from prj_bp_transactor_lv p ,prj_project_bp pbp 
 where pbp.prj_bp_id=p.prj_bp_id
and pbp.bp_category='TENANT'
and PBP.BP_TYPE='TENANT_SEC'
and pbp.project_id=${/parameter/@project_id}
]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
