<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: gaoyang  
    $Date: 2013-11-21 下午05:31:23  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="AUT_TRX_CATEGORY_V" defaultOrderBy="t1.enabled_flag desc">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                SELECT
                    trx.trx_category,
                    trx.trx_category_desc
                FROM
                    aut_trx_category_v trx
                WHERE
                    trx.enabled_flag        = 'Y' AND
                    trx.system_enabled_flag = 'Y' AND
                    trx.trx_category       IN ('BP', 'LEASE_ITEM', 'MORTGAGE')
                UNION ALL
                SELECT
                    c.document_category,
                    c.description
                FROM
                    hls_document_category c
                WHERE
                    c.enabled_flag       = 'Y' AND
                    c.document_category IN ('CHANCE', 'PROJECT', 'CONTRACT', 'CHANGE_REQUEST', 'LOAN_CONTRACT', 'CONTRACT_ET','ET', 'PAYMENT_REQ','CREDIT_INFO','VISIT_REPORT','CONFIG_REPORT','CONFIG_REPORT_RESULT','LEND','COLL_CALL')
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
