<?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,
            	   decode(hpci.data_class,'CON',hpci.contract_issue,'MANAGE',hpci.manage_require,'POINT',hpci.point_issue) practicable_issue,
			       hpci.confirm_status,
			       (select v.code_value_name from sys_code_values_v v
			       where v.code='HN_CHECK_IF_CERTAIN'
			       and v.code_value=hpci.confirm_status) confirm_status_n
			from hn_prj_check_issue hpci 
			where hpci.check_id = ${@check_id}
			      ]]></bm:query-sql>
            <bm:parameters>
                <bm:parameter name="check_id"/>
            </bm:parameters>
        </bm:operation>
    </bm:operations>
</bm:model>
