<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-4-27 上午11:06:46  
    $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  bpc.description||':'||bp.bp_name bp_name
 from prj_chance_bp a ,hls_bp_category bpc,hls_bp_master bp where 
 a.bp_category=bpc.bp_category
 and a.bp_id=bp.bp_id
 and a.bp_category='TENANT'
 AND A.CHANCE_ID=${/parameter/@chance_id}
 UNION
 SELECT '出租人：华能天成融资租赁有限公司' bp_name FROM DUAL
 union
 select  bpc.description||':'||bp.bp_name bp_name
 from prj_chance_bp a ,hls_bp_category bpc,hls_bp_master bp where 
 a.bp_category=bpc.bp_category
 and a.bp_id=bp.bp_id
 and a.bp_category='GUARANTOR'
  AND A.CHANCE_ID=${/parameter/@chance_id}
  ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME"/>
    </bm:fields>
</bm:model>
