<?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 cpy.company_id, cpy.company_code, company_short_name company_desc, cpy.company_code || '-' || company_short_name code_desc from fnd_companies cpy where cpy.parent_company_id = ${/session/@company_id} or cpy.company_id = ${/session/@company_id}) v #WHERE_CLAUSE# order by v.company_code ]]></bm:query-sql></bm:operation></bm:operations><bm:fields><bm:fieldname="company_code"forDisplay="true"forQuery="true"prompt="COMPANY_CODE"/><bm:fieldname="company_desc"forDisplay="true"forQuery="true"prompt="FND_COMPANIES.COMPANY_NAME"/><bm:fieldname="company_id"/><bm:fieldname="code_desc"/></bm:fields><bm:query-fields><bm:query-fieldfield="company_code"queryOperator="like"/><bm:query-fieldfield="company_desc"queryOperator="like"/></bm:query-fields></bm:model>