<?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.financial_code as code, vv.code_value_name as code_name
				   from hls_price_list_conds_financial t, sys_code_values_v vv
				  where t.PRICE_LIST = 'YONDA_STD_PRODUCT'
				    and t.financial_code = vv.code_value
				    and vv.code = 'HLS_052_FINANCIAL_SCALE'

            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CODE" required="true"/>
        <bm:field name="code_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NAME"/>
    </bm:fields>
</bm:model>
