<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-4-27 上午10:52:06  
    $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 
change_number_to_cn( RANK() OVER(ORDER BY CI.ORDER_SEQ,ci.cdd_item_id)) RK,
ci.description,--文档名称
p.chance_id
from prj_chance p,prj_cdd_item ci ,prj_cdd_item_list_grp_tab lgt,
prj_cdd_item_tab_group tg
where p.cdd_list_id=ci.cdd_list_id
and ci.cdd_item_id=lgt.cdd_item_id
and tg.tab_group_id(+)=lgt.tab_group_id
and tg.tab_group='CHANCE'
and p.chance_id=${/parameter/@chance_id}
 
 ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
