<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="HN_VIR_CON_CCR_APPROVE">
    <bm:fields>
        <bm:field name="ccr_approve_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CCR_APPROVE_ID" prompt="HN_VIR_CON_CCR_APPROVE.CCR_APPROVE_ID"/>
        <bm:field name="change_req_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CHANGE_REQ_ID" prompt="HN_VIR_CON_CCR_APPROVE.CHANGE_REQ_ID"/>
        <bm:field name="record_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RECORD_ID" prompt="HN_VIR_CON_CCR_APPROVE.RECORD_ID"/>
        <bm:field name="function_description" expression="(select hacc.function_description from hn_atm_complement hac,hn_atm_complement_config hacc where hac.config_id=hacc.config_id and hac.record_id=t1.record_id)" forInsert="false" forUpdate="false"/>
        <bm:field name="virtual_con_number" expression="(select pp.virtual_con_number from hn_atm_complement hac,prj_project pp where hac.document_id=pp.project_id and hac.record_id=t1.record_id)" forInsert="false" forUpdate="false"/>
        <bm:field name="virtual_con_name" expression="(select pp.virtual_con_name from hn_atm_complement hac,prj_project pp where hac.document_id=pp.project_id and hac.record_id=t1.record_id)" forInsert="false" forUpdate="false"/>
        <bm:field name="description" expression="(select hac.description from hn_atm_complement hac where hac.record_id=t1.record_id)" forInsert="false" forUpdate="false"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
        <o:sequence-pk/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="ccr_approve_id"/>
    </bm:primary-key>
    <bm:data-filters>
        <bm:data-filter name="query" expression="t1.change_req_id=${@change_req_id}"/>
    </bm:data-filters>
</bm:model>
