fnd_company_level.lwm 1.63 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
<?xml version="1.0" encoding="UTF-8"?>
<ns1:model xmlns:ns1="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="e" baseTable="fnd_company_levels">
    <ns1:fields>
        <ns1:field name="company_level_id" databaseType="BIGINT" datatype="java.lang.Long"/>
        <ns1:field name="company_level_code" databaseType="VARCHAR" datatype="java.lang.String"/>
        <ns1:field name="description_id" databaseType="BIGINT" datatype="java.lang.Long" multiLanguage="true" multiLanguageDescField="description"/>
        <!--<field databaseType="VARCHAR" datatype="java.lang.String" name="name" expression="(select e.company_level_code || '-' || d.description from fnd_company_levels_vl d where d.company_level_id=fc.company_level_id)" forInsert="false" forUpdate="false"/>-->
    </ns1:fields>
    <ns1:primary-key>
        <ns1:pk-field name="company_level_id"/>
    </ns1:primary-key>
    <ns1:query-fields><![CDATA[
    ]]></ns1:query-fields>
    <ns1:data-filters>
        <ns1:data-filter expression="e.enabled_flag =&apos;Y&apos;"/>
    </ns1:data-filters>
    <ns1:features>
        <ns1:sequence-pk/>
        <f:standard-who/>
        <f:multi-language-storage/>
    </ns1:features>
    <ns1:ref-fields/>
    <!--
    <operations>
        <operation name="query">
            <query-sql>
                select d.company_level_id value
    
                       d.company_level_code || '-' || d.description name
                  from fnd_company_levels_vl d
                 where d.enabled_flag ='Y'
                 order by d.company_level_code
            </query-sql>
        </operation>
    </operations>
    -->
</ns1:model>