<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: LIJINGJING
    $Date: 2019-09-10 下午4:38:18
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
     select tt.*  from (       	SELECT t1.project_number,
       t1.contract_number,
       t1.bp_code,
       t1.bp_name,
       t1.overdue_max_days,
       t1.overdue_max_amount,
       t1.bp_type,
        t1.bp_class,
       t1.bp_id,
       t1.description,
       t1.project_id,
       t1.contract_id,
       t1.bp_category
  FROM prj_project_history_lv t1
WHERE t1.bp_id = ${@bp_id}
and  t1.project_id <> ${@project_id})   tt
#WHERE_CLAUSE#
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
