exp_expense_items_vl.lwm

<?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||&apos;-&apos;||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>