<?xml version="1.0" encoding="UTF-8"?><bm:modelxmlns:bm="http://www.leaf-framework.org/schema/bm"><bm:operations><bm:operationname="query"><bm:query-sql><![CDATA[ SELECT * FROM ( select v.company_id as value_code, v.company_short_name as value_name from fnd_companies_vl v where v.start_date_active < sysdate and (v.end_date_active is null or v.end_date_active < sysdate))t1 #WHERE_CLAUSE# ]]></bm:query-sql></bm:operation></bm:operations><bm:fields><bm:fieldname="value_code"databaseType="VARCHAR2"datatype="java.lang.String"displayWidth="120"forDisplay="true"forQuery="true"prompt="代码"/><bm:fieldname="value_name"databaseType="VARCHAR2"datatype="java.lang.String"displayWidth="120"forDisplay="true"forQuery="true"prompt="描述"/></bm:fields><bm:query-fields><bm:query-fieldname="value_code"queryExpression="t1.value_code like '%'||${@value_code}||'%'"/><bm:query-fieldname="value_name"queryExpression="t1.value_name like '%'||${@value_name}||'%'"/></bm:query-fields></bm:model>