<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: gaoyang  
    $Date: 2013-3-12 下午01:10:46  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:p="uncertain.proc" needAccessControl="false">
    <bm:fields>
        <bm:field name="first_fiscal_year"/>
        <bm:field name="second_fiscal_year"/>
        <bm:field name="third_fiscal_year"/>
        <bm:field name="fourth_fiscal_year"/>
        <bm:field name="fifth_fiscal_year"/>
        <bm:field name="sixth_fiscal_year"/>
        <bm:field name="seventh_fiscal_year"/>
        <bm:field name="eighth_fiscal_year"/>
        <bm:field name="ninth_fiscal_year"/>
        <bm:field name="tenth_fiscal_year"/>
        <bm:field name="eleventh_fiscal_year"/>
        <bm:field name="twelfth_fiscal_year"/>
    </bm:fields>
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
               select (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 1)) first_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 2)) second_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 3)) third_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 4)) fourth_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 5)) fifth_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 6)) sixth_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 7)) seventh_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 8)) eighth_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 9)) ninth_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 10)) tenth_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 11)) eleventh_fiscal_year,
                       (select hd.fiscal_year || '年' || hd.fiscal_month || '月' from rsc_fin_statement_prj_hds hd where fin_statement_id = rsc_excel_export_details.get_fin_statement_id(p_session_id => ${/session/@session_id}, p_number_id => 12)) twelfth_fiscal_year
                  from dual
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
