<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
             select pp.prj_bp_id,
       pp.bp_name,
       pp.bp_id,
       pp.id_card_no,
       pp.work_unit,
       to_char(pp.founded_date,'yyyy-mm-dd') founded_date,
       pp.project_id,
       pp.tax_registry_num,
       p.guaranty_mode,
       p.guaranty_mode_n,
       
       p.other_mortgage,
       p.other_mortgage_n,
       p.other_guarantee,
       p.business_license_num,
       pp.bp_class

  from prj_project_bp pp, prj_project_detail_lv p
 where pp.project_id = p.project_id
 and pp.bp_type = 'GUTA_NP'
   and pp.project_id = ${@project_id}
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="business_license_num"/>
        <bm:field name="guaranty_mode"/>
        <bm:field name="guaranty_mode_n"/>
        <bm:field name="other_mortgage"/>
        <bm:field name="other_mortgage_n"/>
        <bm:field name="other_guarantee"/>
        <bm:field name="bp_class"/>
        <bm:field name="prj_bp_id"/>
        <bm:field name="bp_id"/>
        <bm:field name="bp_name"/>
        <bm:field name="id_card_no"/>
        <bm:field name="work_unit"/>
        <bm:field name="founded_date"/>
        <bm:field name="project_id"/>
        <bm:field name="tax_registry_num"/>
    </bm:fields>
</bm:model>
