<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-7-10 下午8:30:43  
    $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 ppm.project_id, --合同ID
       ppm.bp_id_mortgagor, --地质押人ID
       (select hbm.bp_name
          from hls_bp_master hbm
         where hbm.bp_id = ppm.bp_id_mortgagor) mortgagor_bp_name, --地质押人名称
       ppm.mortgage_name, --抵质押物名称
       ppm.specification,--规格型号（动产抵押）
       ppm.quantity --数量
  from prj_project_mortgage ppm
   where ppm.mortgage_type = 'MORTGAGE'   
   and ppm.project_id=${/parameter/@project_id}
   ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
