<?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,
					replace(t1.service_url,
                                   'modules/prj/PRJ2000/purchase_order_deteail.lview') as service_url_purchase
            	From (select zj_wfl_core_pkg.get_wfl_service_url(tt.instance_id,
                                           				   ${/session/@user_id}) as service_url,tt.*
  				  from zj_wfl_workflow_instance tt) t1
  				 #WHERE_CLAUSE#
        	]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
