<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: jack
$Date: 2014-6-9 下午5:45:59
$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 t1.*,rownum from(
SELECT a.bp_name,
a.bp_id,
a.project_id,
a.founded_date,
a.registered_capital,
a.paid_up_capital,
b.legal_person,
b.business_license_num,
b.industry,
b.organization_code,
b.primary_business,
b.loan_card_num,
a.description tenant_description
FROM prj_project_bp a,
hls_bp_master b
WHERE
(a.bp_category = 'TENANT' or a.bp_category = 'TENANT_SEC')
and a.bp_id=b.bp_id
) t1 #WHERE_CLAUSE#
]]></bm:query-sql>
</bm:operation>
</bm:operations>
</bm:model>
-
Spencer Chang authoredbfd31bca