<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:ns2="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
        		Select t1.*,replace(t1.service_url,
                                     'modules/prj/PRJ501N/prj_project_maintain_wfl_new.lview',
                                     'modules/prj/PRJ501N/prj_project_maintain_constru_wfl.lview') as service_url_constru,
				    replace(t1.service_url,
                                                    'modules/prj/PRJ501N/prj_project_maintain_wfl_new.lview',
                                                    'modules/prj/PRJ501N/prj_project_maintain_operat_wfl.lview') as service_url_operat,
					 replace(t1.service_url,
                                                    'modules/csh/CSH501/csh_payment_req.lview',
                                                    'modules/csh/CSH501/csh_payment_op_req.lview') as service_url_operat_payment
                   From (select zj_wfl_core_pkg.get_node_service_url(tt.record_id,
				                                            ${/parameter/@url_type},
				                                            ${/session/@user_id}) as service_url,tt.*
  				  from zj_wfl_instance_node_rcpt_ht tt) t1
  				  #WHERE_CLAUSE#
        	]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
