<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: hp $Date: 2015-6-10 下午1:55:39 $Revision: 1.0 $Purpose: --> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ SELECT * FROM (SELECT bp.bp_code, bp.bp_id, bp.bp_name, ba.province_id_n, ba.city_id_n, ba.district_id_n, ba.province_id_n||ba.city_id_n||ba.district_id_n||ba.address as detail_address, ba.address, ba.zipcode, (ba.phone||ba.cell_phone) as phone FROM hls_bp_master_address_lv ba, hls_bp_master bp WHERE 1 = 1 AND ba.bp_id(+) = bp.bp_id AND ba.address_type(+) = 'DOC_SENT_ADDRESS' AND ba.enabled_flag(+) = 'Y') t1 #WHERE_CLAUSE# ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="bp_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_CODE"/> <bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID" required="true"/> <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME"/> <bm:field name="province_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROVINCE_ID_N"/> <bm:field name="city_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CITY_ID_N"/> <bm:field name="district_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DISTRICT_ID_N"/> <bm:field name="address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADDRESS"/> <bm:field name="phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PHONE"/> <bm:field name="zipcode"/> <bm:field name="detail_address"/> </bm:fields> <bm:query-fields> <bm:query-field field="bp_id" queryOperator="="/> </bm:query-fields> </bm:model>