<?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
                    ROWNUM AS ROW_NUM,
                    FULL_NAME,
                    PPLI.PATTERN,
                    QUANTITY,
                    hb.bp_name AS VENDER_ID
                FROM
                    PRJ_PROJECT_LEASE_ITEM PPLI,
                    hls_bp_master hb
                WHERE
                    ppli.VENDER_ID  = hb.bp_id AND
                    PPLI.PROJECT_ID = ${@project_id}
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="row_num"/>
        <bm:field name="full_name"/>
        <bm:field name="pattern"/>
        <bm:field name="quantity"/>
        <bm:field name="vender_id"/>
    </bm:fields>
</bm:model>
