<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ SELECT * FROM (SELECT c.contract_id, c.project_id_n, c.contract_number, c.company_id_n, c.contract_name, c.document_type_n, c.lease_organization_n, c.bp_id_tenant_n, c.currency_n, c.business_type_n, c.lease_channel_n, c.employee_id_n, c.total_rental, c.lease_start_date, c.division_n, c.employee_id_of_manager_n, c.total_interest, c.lease_times, c.contract_status_n, c.total_fee, c.annual_pay_times_n, c.lease_term FROM con_Contract_lv c ) t1 #WHERE_CLAUSE# ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long"/> <bm:field name="project_id_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="company_id_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="contract_name" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="document_type_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="lease_organization_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="bp_id_tenant_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="currency_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="business_type_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="lease_channel_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="employee_id_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="total_rental" databaseType="NUMBER" datatype="java.lang.Double"/> <bm:field name="lease_start_date" databaseType="DATE" datatype="java.util.Date"/> <bm:field name="division_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="employee_id_of_manager_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="total_interest" databaseType="NUMBER" datatype="java.lang.Double"/> <bm:field name="lease_times" databaseType="NUMBER" datatype="java.lang.Double"/> <bm:field name="contract_status_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="total_fee" databaseType="NUMBER" datatype="java.lang.Double"/> <bm:field name="annual_pay_times_n" databaseType="VARCHAR2" datatype="java.lang.String"/> <bm:field name="lease_term" databaseType="NUMBER" datatype="java.lang.Double"/> </bm:fields> <bm:query-fields> <bm:query-field field="contract_id" queryExpression="t1.contract_id=${@contract_id}"/> </bm:query-fields> </bm:model>