quotation_result.lwm 986 Bytes
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
<?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 
         T.times times,
         t.rental rental,
         t.due_date,
         t.principal principal,
         t.interest interest,
         T.outstanding_rental_tax_incld
    from hls_fin_calculator_ln_lv T,hls_fin_calculator_hd h 
    where h.calc_session_id = T.calc_session_id
    and h.calc_session_id = (select p.calc_session_id from prj_quotation p where p.quotation_id = ${@quotation_id})
    order by T.times

            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="times"/>
        <bm:field name="rental"/>
        <bm:field name="due_date"/>
        <bm:field name="principal"/>
        <bm:field name="interest"/>
        <bm:field name="outstanding_rental_tax_incld"/>
    </bm:fields>
</bm:model>