<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: LR $Date: 2013-8-12 上午10:08:35 $Revision: 1.0 $Purpose: --> <bm:model xmlns:e="leaf.service.exception" xmlns:ns2="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="fc" baseTable="fnd_companies" defaultOrderBy="company_code"> <bm:fields> <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" forInsert="true" physicalName="COMPANY_ID" prompt="FND_COMPANIES.COMPANY_ID"/> <bm:field name="company_code" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="234" forDisplay="true" forInsert="true" forQuery="true" fordisplay="true" physicalName="COMPANY_CODE" prompt="FND_COMPANIES.COMPANY_CODE"/> <bm:field name="company_type" databaseType="VARCHAR" datatype="java.lang.String" lookupCode="COMPANY_TYPE" lookupField="company_type_display"/> <bm:field name="company_type_display" forInsert="false" forUpdate="false" prompt="FND_COMPANIES.COMPANY_TYPE"/> <bm:field name="set_of_books_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SET_OF_BOOKS_ID" prompt="FND_COMPANIES.SET_OF_BOOKS_ID"/> <bm:field name="set_of_books_id_display" databaseType="VARCHAR" datatype="java.lang.String" expression="(select v.set_of_books_code||'-'||v.set_of_books_name from gld_set_of_books v where v.set_of_books_id=fc.set_of_books_id)" forInsert="false" forUpdate="false" prompt="FND_COMPANIES.SET_OF_BOOKS"/> <bm:field name="address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADDRESS" prompt="FND_COMPANIES.ADDRESS"/> <bm:field name="company_level_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_LEVEL_ID" prompt="FND_COMPANIES.COMPANY_LEVEL_ID"/> <bm:field name="company_level_id_display" databaseType="VARCHAR" datatype="java.lang.String" expression="(select fclv.company_level_code||'-'||fclv.description from fnd_company_levels_vl fclv where fclv.company_level_id=fc.company_level_id)" forInsert="false" forUpdate="false" prompt="FND_COMPANIES.COMPANY_LEVEL_ID"/> <bm:field name="parent_company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PARENT_COMPANY_ID" prompt="FND_COMPANIES.PARENT_COMPANY_ID"/> <bm:field name="chief_position_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CHIEF_POSITION_ID" prompt="FND_COMPANIES.CHIEF_POSITION_ID"/> <bm:field name="chief_position_id_display" databaseType="VARCHAR2" datatype="java.lang.String" expression="(select eopv.POSITION_CODE||'-'||eopv.DESCRIPTION from exp_org_position_vl eopv where eopv.company_id= fc.company_id AND eopv.position_id =fc.chief_position_id)" forInsert="false" forUpdate="false" prompt="FND_COMPANIES.CHIEF_POSITION_ID"/> <bm:field name="start_date_active" databaseType="DATE" datatype="java.util.Date" physicalName="START_DATE_ACTIVE" prompt="FND_COMPANIES.START_DATE_ACTIVE"/> <bm:field name="end_date_active" databaseType="DATE" datatype="java.util.Date" physicalName="END_DATE_ACTIVE" prompt="FND_COMPANIES.END_DATE_ACTIVE"/> <bm:field name="enable_role_authority" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENABLE_ROLE_AUTHORITY" prompt="FND_COMPANIES.ENABLE_ROLE_AUTHORITY"/> <bm:field name="enable_user_authority" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENABLE_USER_AUTHORITY" prompt="FND_COMPANIES.ENABLE_USER_AUTHORITY"/> <bm:field name="invoice_title" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_TITLE" prompt="FND_COMPANIES.INVOICE_TITLE"/> <bm:field name="tax_registry_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TAX_REGISTRY_NUM" prompt="FND_COMPANIES.TAX_REGISTRY_NUM"/> <bm:field name="invoice_bp_address_phone_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_BP_ADDRESS_PHONE_NUM" prompt="FND_COMPANIES.INVOICE_BP_ADDRESS_PHONE_NUM"/> <bm:field name="invoice_bp_bank_account" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_BP_BANK_ACCOUNT" prompt="FND_COMPANIES.INVOICE_BP_BANK_ACCOUNT"/> <bm:field name="vat_invoice_limit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_INVOICE_LIMIT" prompt="FND_COMPANIES.VAT_INVOICE_LIMIT"/> <bm:field name="invoice_limit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INVOICE_LIMIT" prompt="FND_COMPANIES.INVOICE_LIMIT"/> <bm:field name="company_short_name" databaseType="VARCHAR2" datatype="java.lang.String" displayWidth="234" forDisplay="true" forInsert="true" forQuery="true" fordisplay="true" physicalName="COMPANY_SHORT_NAME" prompt="FND_COMPANIES.COMPANY_SHORT_NAME"/> <bm:field name="company_full_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_FULL_NAME" prompt="FND_COMPANIES.COMPANY_FULL_NAME"/> <bm:field name="parent_biz_company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PARENT_BIZ_COMPANY_ID" prompt="FND_COMPANIES.PARENT_BIZ_COMPANY_ID"/> <bm:field name="spv_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SPV_FLAG" prompt="FND_COMPANIES.SPV_FLAG"/> <bm:field name="parent_biz_company_code" databaseType="VARCHAR2" datatype="java.lang.String" expression="(select fc1.company_code from fnd_companies fc1 where fc1.company_id=fc.parent_biz_company_id)" forInsert="false" forUpdate="false" prompt="FND_COMPANIES.PARENT_BIZ_COMPANY_CODE"/> <bm:field name="parent_biz_company_display" databaseType="VARCHAR2" datatype="java.lang.String" expression="(select fc1.company_short_name from fnd_companies fc1 where fc1.company_id=fc.parent_biz_company_id)" forInsert="false" forUpdate="false" prompt="FND_COMPANIES.PARENT_BIZ_COMPANY_DISPLAY"/> <bm:field name="sales_tax_invoice_limit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="SALES_TAX_INVOICE_LIMIT" prompt="FND_COMPANIES.SALES_TAX_INVOICE_LIMIT"/> <bm:field name="phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PHONE" prompt="FND_COMPANIES.PHONE"/> <bm:field name="bank_account_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BANK_ACCOUNT_ID" prompt="FND_COMPANIES.BANK_ACCOUNT_ID"/> <bm:field name="bank_info" expression="(select a.bank_branch_name||'-'||a.bank_account_num from CSH_BANK_ACCOUNT_V a where a.bank_account_id=fc.bank_account_id)" forInsert="false" forUpdate="false"/> <bm:field name="ele_vat_invoice_limit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="ELE_VAT_INVOICE_LIMIT"/> <bm:field name="ele_invoice_limit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="ELE_INVOICE_LIMIT"/> </bm:fields> <bm:primary-key> <bm:pk-field name="company_id"/> </bm:primary-key> <bm:query-fields> <bm:query-field field="company_id" queryOperator="="/> <bm:query-field field="company_code" queryOperator="like"/> <bm:query-field field="set_of_books_id" queryOperator="="/> <bm:query-field field="company_short_name" queryOperator="like"/> <bm:query-field name="valid_date" queryExpression="(sysdate between fc.start_date_active and nvl(fc.end_date_active,sysdate))"/> <bm:query-field field="company_type" queryOperator="="/> <bm:query-field name="not_company_id" queryExpression="fc.company_id != ${@not_company_id}"/> <bm:query-field name="include_disabled_flag" queryExpression="(${@include_disabled_flag}='Y' or( sysdate between start_date_active and nvl(end_date_active,sysdate)))"/> </bm:query-fields> <bm:features> <ns2:sequence-pk/> <f:standard-who/> <f:multi-language-storage/> </bm:features> <bm:ref-fields/> <e:exception-descriptor-config> <e:exception-descriptor exception="java.sql.SQLException" handleClass="leaf.database.SQLExceptionDescriptor"> <e:error-message code="1" message="FND_COMPANIES.COMPANY_CODE_DISTINCT"/> </e:exception-descriptor> </e:exception-descriptor-config> </bm:model>