<?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 t.bp_id    code,
			       t.bp_name  code_name,
			      
			       to_char(t.founded_date,'yyyy-mm-dd') founded_date,
			       t.registered_capital,
			     
			       t.work_unit_phone,
			       t.contact_person,
			     
			     
			       t.business_license_num
			  from hls_bp_master t, hls_bp_master_role_lv ro
			 where t.bp_class = 'ORG'
			 and  t.bp_id(+)=ro.bp_id
			 and  ro.bp_type = 'TENANT'
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CODE" required="true"/>
        <bm:field name="code_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NAME"/>
        <bm:field name="founded_date"/>
        <bm:field name="contact_person"/>
        <bm:field name="registered_capital"/>
        <bm:field name="work_unit_phone"/>
        <bm:field name="business_license_num"/>
    </bm:fields>
</bm:model>
