<?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 hpcid.item_name,
			       rownum sequence,
			       hpcid.item_status,
			       (select v.code_value_name
			          from sys_code_values_v v
			         where v.code = 'HN_POINT_CHECK_STATUS'
			           and v.code_value = hpcid.item_status) item_status_n
			from hn_prj_check_item_detail hpcid,
			     hn_prj_check_item hpci
			where hpcid.check_item_id = hpci.check_item_id AND
			      hpci.check_item_type = '抵质押检查状态' AND
			      hpci.check_id = ${@check_id}
			      ]]></bm:query-sql>
            <bm:parameters>
                <bm:parameter name="check_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
