<?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>
-
Spencer Chang authoredbfd31bca