<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="EXP_EXPENSE_ITEMS_VL"> <bm:fields> <bm:field name="expense_item_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EXPENSE_ITEM_ID" prompt="xx"/> <bm:field name="set_of_books_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="set_of_books_id" prompt="xx"/> <bm:field name="expense_item_code" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="299" forDisplay="true" forQuery="true" physicalName="EXPENSE_ITEM_CODE" prompt="EXP_EXPENSE_ITEMS.EXPENSE_ITEM_CODE"/> <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="300" forDisplay="true" forQuery="true" physicalName="DESCRIPTION" prompt="EXP_EXPENSE_ITEMS.DESCRIPTION_ID"/> <bm:field name="codeanddescription" databaseType="VARCHAR2" datatype="java.lang.String" expression="(expense_item_code||'-'||description)" forInsert="false" forUpdate="false"/> </bm:fields> <bm:features> <f:standard-who/> </bm:features> <bm:query-fields> <bm:query-field field="expense_item_code" queryOperator="="/> <bm:query-field field="description" queryOperator="like"/> </bm:query-fields> <bm:data-filters> <bm:data-filter name="set_of_books_id" enforceOperations="query" expression="t1.set_of_books_id=(select set_of_books_id from fnd_companies fc where fc.company_id=${/session/@company_id})"/> </bm:data-filters> </bm:model>