<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-5-8 下午4:58:58  
    $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 pbp.project_id,
            to_char(pbp.prj_bp_id) prj_bp_id,

       pbl.pro_tenant_bank_type,--借款类型
       pbl.pro_tenant_bank_number,--未结清笔数
       trim(to_char(pbl.pro_tenant_bank_amount,'999,999,999,999,990.99')) pro_tenant_bank_amount,--未结清余额
       pbl.pro_tenant_bank_note--备注
  from PRJ_BP_TRANSACTOR_LOAN_LV pbl,prj_project_bp pbp 
 where pbp.prj_bp_id=pbl.prj_bp_id
 and pbp.bp_category='GUARANTOR'
 --and PBP.BP_TYPE='GUARANTOR'
 AND pbp.project_id=${/parameter/@project_id}
 ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
