<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: weiwuzhen  
    $Date: 2016-5-5 下午3:45:05  
    $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 pll.project_id,
       pll.lease_item_b_name,--租赁物件名称
       pll.lease_item_b_sup,--租赁物供应商名称
       pll.lease_item_b_usage,--租赁物件用途
       pll.lease_item_b_tech,--租赁物技术先进性
       pll.lease_item_b_type,--租赁物件所属类别
       pll.lease_item_b_core_n,--是否为核心设备
       pll.lease_item_b_supervise,--产权及抵质押、海关监管等受限情况
       to_char(pll.lease_item_b_core_price,'999,999,990.99') lease_item_b_core_price,--核心设备价值（元）
       to_char(pll.lease_item_b_tprice,'999,999,990.99') lease_item_b_tprice,--总价值（元）
       pll.lease_item_b_cprice,--价值认定
       pll. lease_item_b_amount, --租赁物件数量
       pll.lease_item_b_time,--到货时间
       pll.lease_item_b_dep,--租赁期间租赁物件每期贬损率(%)
       nvl(pll.lease_item_b_lyear,0) lease_item_b_lyear,--实际可使用年限
       nvl(pll.lease_item_b_ayear,0) lease_item_b_ayear,--已使用年限
       nvl(pll.lease_item_b_tyear,0) lease_item_b_tyear,--折旧年限
       nvl(pll.lease_item_b_alyear,0) lease_item_b_alyear,--已折旧年限
       pll.lease_item_b_general,--租赁物件通用性分析
        (to_char(pll.lease_item_in_start,'yyyy')||'/'||to_char(pll.lease_item_in_start,'mm')||'/'||to_char(pll.lease_item_in_start,'dd'))||'至'||
        (to_char(pll.lease_item_in_end,'yyyy')||'/'||to_char(pll.lease_item_in_end,'mm')||'/'||to_char(pll.lease_item_in_end,'dd'))
       lease_item_in_start_and_end, --保险起止时间
       pll.lease_item_insurance_type,--租赁物险种
       to_char(pll.lease_item_in_amount,'999,999,990.99') lease_item_in_amount,--投保金额
       pll.lease_item_in_pay_n,--保险金支付方式
       pll.lease_item_in_company,--保险公司
       pll.lease_item_in_range,--投保范围
       pll.lease_item_in_other,--其他情况说明
       pll.lease_item_in_number,--保单号
       pll.lease_item_in_confer,--保险事项协商情况
       pll.lease_item_alr_number,--已投保单号
       pll.lease_item_alr_type,--已投保险种
       pll.lease_item_alr_way,--投保方式
       pll.lease_item_alr_company--保险公司
 from PRJ_LEASE_ITEM_BASIC_INFO_LV pll
 where pll.project_id=${/parameter/@project_id}
 ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
