<?xml version="1.0" encoding="UTF-8"?>
<!--
author:wht
date:20170614
-->
<a:screen xmlns:a="http://www.aurora-framework.org/application" trace="true">
<a:init-procedure/>
<a:view package="ui.template" template="empty">
<!--数据操作层-->
<a:dataSets>
<!--数据源-->
<a:dataSet id="find_company_result_ds" autoPageSize="true" canSubmit="true" model="gld.fnd_company"/>
<!--数据链接层-->
<a:dataSet id="functional_currency">
<a:fields>
<a:field name="functional_currency_name" autoComplete="true" autoCompleteField="currency_code" autoCompleteSize="1" lovAutoQuery="true" lovGridHeight="200" lovHeight="380" lovLabelWidth="100" lovService="gld.gld_currency" lovWidth="400" required="true" requiredMessage="公司货币不能为空" title="货币类型">
<a:mapping>
<a:map from="currency_code" to="function_currency_code"/>
<a:map from="currency_name" to="function_currency_name"/>
</a:mapping>
</a:field>
</a:fields>
</a:dataSet>
</a:dataSets>
<!--数据显示层-->
<a:screen-Body>
<a:form column="1" marginWidth="760" title="货币">
<a:lov name="functional_currency_name" bindTarget="functional_currency" prompt="功能货币" width="208"/>
</a:form>
</a:screen-Body>
</a:view>
</a:screen>
<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:e="aurora.service.exception" xmlns:o="aurora.database.local.oracle" xmlns:bm="http://www.aurora-framework.org/schema/bm" xmlns:f="aurora.database.features" alias="t" baseTable="FND_COMPANIES_6603">
<bm:fields>
<bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="FND_COMPANIES_6603.COMPANY_ID"/>
<bm:field name="company_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_CODE" prompt="FND_COMPANIES_6603.COMPANY_CODE"/>
<bm:field name="company_short_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_SHORT_NAME" prompt="FND_COMPANIES_6603.COMPANY_SHORT_NAME"/>
<bm:field name="company_full_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_FULL_NAME" prompt="FND_COMPANIES_6603.COMPANY_FULL_NAME"/>
<bm:field name="functional_currency_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FUNCTIONAL_CURRENCY_CODE" prompt="FND_COMPANIES_6603.FUNCTIONAL_CURRENCY_CODE"/>
<bm:field name="start_date_active" databaseType="DATE" datatype="java.util.Date" physicalName="START_DATE_ACTIVE" prompt="FND_COMPANIES_6603.START_DATE_ACTIVE"/>
<bm:field name="end_date_active" databaseType="DATE" datatype="java.util.Date" physicalName="END_DATE_ACTIVE" prompt="FND_COMPANIES_6603.END_DATE_ACTIVE"/>
<bm:field name="exchange_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXCHANGE_RATE_TYPE" prompt="FND_COMPANIES_6603.EXCHANGE_RATE_TYPE"/>
</bm:fields>
<bm:features>
<f:standard-who/>
<o:sequence-pk/>
</bm:features>
<bm:primary-key>
<bm:pk-field name="company_id"/>
</bm:primary-key>
<bm:order-by>
<bm:order-field name="company_id"/>
</bm:order-by>
<bm:data-filters>
<bm:data-filter enforceOperations="query" expression="t.start_date_active is not null"/>
<!-- <bm:data-filter name="activeValide" expression="t.start_date_active < t.end_date_active"/> -->
</bm:data-filters>
<bm:relations>
<bm:relation name="cc" joinType="LEFT OUTER" refModel="gld.gld_currency">
<bm:reference foreignField="currency_code" localField="functional_currency_code"/>
</bm:relation>
</bm:relations>
<bm:ref-fields>
<bm:ref-field name="functional_currency_name" relationName="cc" sourceField="currency_name"/>
</bm:ref-fields>
<bm:query-fields>
<bm:query-field field="company_code" queryOperator="like"/>
<bm:query-field name="company_name" queryExpression="t.company_full_name like '%' || ${@company_name} || '%'"/>
<!-- <bm:query-field field="company_short_name" queryExpression="t.company_short_name like ${@company_short_name} || ' % '"/>
<bm:query-field field="company_full_name" queryExpression="t.company_full_name like ${@company_full_name} || ' % '"/>
<bm:query-field name="start_date_active" queryExpression="t.start_date_active >= ${@start_date_active}"/>
<bm:query-field name="end_date_active" queryExpression="t.end_date_active < ${@end_date_active}"/> -->
</bm:query-fields>
<e:exception-descriptor-config>
<e:exception-descriptor exception="java.sql.SQLException" handleClass="aurora.database.SQLExceptionDescriptor">
<e:error-message code="1" message="FND_COMPANIES.COMPANY_CODE_DISTINCT"/>
</e:exception-descriptor>
</e:exception-descriptor-config>
<!-- <bm:operations>
<bm:operation name="insert">
<bm:update-sql><![CDATA[
begin
fnd_companies_pkg_6603.insert_fnd_companies(p_company_code => ${@company_code},
p_company_short_name => ${@company_short_name},
p_company_full_name => ${@company_full_name},
p_functional_currency_code => ${@functional_currency_code},
p_start_date_active => ${@start_date_active},
p_end_date_active => ${@end_date_active},
p_exchange_rate_type => ${@exchange_rate_type},
p_created_by => ${@create_by});
end;
]]></bm:update-sql>
</bm:operation>
<bm:operation name="update">
<bm:update-sql><![CDATA[
begin
fnd_companies_pkg_6603.update_fnd_companies(p_company_code => ${@company_code},
p_company_short_name => ${@company_short_name},
p_company_full_name => ${@company_full_name},
p_functional_currency_code => ${@functional_currency_code},
p_start_date_active => ${@start_date_active},
p_end_date_active => ${@end_date_active},
p_exchange_rate_type => ${@exchange_rate_type},
p_last_updated_by => ${@last_updated_by});
end;
]]></bm:update-sql>
</bm:operation>
<bm:operation name="delete">
<bm:update-sql><![CDATA[
begin
fnd_companies_pkg_6603.delete_fnd_companies(p_company_code => ${@company_code});
end;
]]></bm:update-sql>
</bm:operation>
</bm:operations> -->
</bm:model>