get_cashflow_amount.lwm 592 Bytes
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12
<?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 nvl((select l.amount
    from rsc_fin_statement_prj_lns l
   where l.fin_statement_id = rsc_fin_statement_prj_pkg.get_fin_statement_id(${@fin_statement_templet_id},${/session/@company_id},${@bp_id},4)
   and l.fin_statement_type = 'CASHFLOW_STATEMENT'
   and l.fin_statement_item = 'CF_IN_OPR'),0) ca_amount from dual]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>